Share this Job
Apply now »

Sr. Data Engineer

Jan 8, 2021

Company: Coast Capital Savings Federal Credit Union 

Location: British Columbia (CA-BC), Help Headquarters  

Job Type: Full-Time  

Pay Grade: 12 

Posting End Date:  

 

Together, we help empower you to achieve what’s important in your life.

 

What’s the job?

 

 

This role is responsible for the design and development of the Enterprise Analytics Data Warehouse and reporting environment, taking business reporting requirements and working with the data architect, platform engineering, DBA, and data governance teams to design ingestion mechanisms, process and transform this data into Data models that ultimately deliver the analytical layer of the Enterprise Data Warehouse (EDW) to serve the needs to data analysts and end users. The role is responsible for designing and building all processes required to extract data from source systems, transform it according to business rules, and load it into appropriate data models. This role will be responsible for setting up and monitoring development processes and best practices for the rest of the engineering team. The Data Engineer also ensures all development conforms to Coast Capital’s security and privacy guidelines.

 

 

What you’ll get to do:

 

  • Take responsibility for the design and building of robust Business Intelligence and Analytical environments that support self-serve analytics, canned reporting, and deep analysis for Data Scientists.
  • Be responsible for the design and development of the Enterprise Analytics Data Warehouse and reporting environment, taking business reporting requirements and working with the data architect, platform engineering, DBA, and data governance teams to design ingestion mechanisms,
  •  Process and transform this data into Data models that ultimately deliver the analytical layer of the Enterprise Data Warehouse (EDW) to serve the needs to data analysts and end users.
  • Work with business users and subject matter experts to conduct needs analysis, gathering, validating, and refining business requirements.
  • Perform data validation and testing with end users and subject matter experts. Documents requirements and business rules into appropriate specifications for new reports and/or system enhancements utilizing process and data modeling techniques.
  • Deliver on project objectives and the seamless delivery of same to business clients
  • Monitor new deployments and services
  • Act as the primary point of contact throughout the development delivery and follow up of project initiatives

 

 

 

 

 

 

Who are we looking for?

 

  • Expert in building Enterprise data warehouses using traditional ETL tools like SSIS, Talend, Informatica etc.
  • Experience and solid understanding of SQL constructs and expertise writing any one flavor of SQL (T-SQL, PL/SQL, PostreSQL)
  • Experience in building a scalable ELT/ETL framework to enable fast execution of the data warehouse.
  • Experience in building and maintaining data warehouses on AWS using AWS native tools would be an asset
  • Working knowledge of building Enterprise data warehouses on premise using any of the major platforms. Oracle/Microsoft/SAP etc.
  • Solid understanding of Data warehouse modeling constructs and solution architecture in the cloud
  • Experience programming in any of the modern languages limited to data processing. (Python, Java, Node.js) would be an asset
  • Experience working in an agile environment and familiarity with all sprint ceremonies.
  • Familiarity with any modern data visualization tools.
  • Experience building data quality validation both during solution build and for continuous data flows.
  • Experience handling moderate to large data set
  • Proficient in Microsoft Data Management Platform (SQL Server, SSIS, SSAS, SSRS, Power BI)
  • Working knowledge in Tableau
  • Strong interpersonal and communication skills to be a part of and support cross-functional teams
  • Have a team player attitude with enthusiasm to engage in and support organizational activities and share knowledge

At Coast Capital, we value diversity, equity and inclusion. We’re not all the same and we like it that way. We don’t just accept differences - we celebrate, support, and we thrive on them for the benefit of our employees, our members, and our community. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. We believe, the more inclusive we are, the better our work will be.

Apply now »