Data Engineer Company:
Coast Capital SavingsFederal Credit Union Location:
British Columbia (CA-BC),[[filter1]] Job Type:
Full Time 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. Why join Coast Capital Savings? Purpose is our North Star.
We look at everything through our purpose. It informs the advice we provide our members, the experiences and products we create, and the programs we build to support our employees and communities. Committed to inclusion and engagement.
We have an ongoing focus on equity, diversity, and inclusion and routinely track how we're doing, and what we need to do to keep improving. We foster a culture where everyone can feel safe to be who they really are and thrive. A career that grows with you.
We believe in developing our people and promoting from within. Many employees have spent decades, and sometimes their entire careers, with Coast Capital and have progressed from the frontlines to senior leadership. Work where you're most effective.
In 2020 the world changed, and that includes how we work. In response to COVID-19 we launched myWork, which gives employees flexibility in where they work based on the nature of their role. Benefits that flex to the needs of you and your family.
We offer comprehensive, customizable benefits for you and your family, so you can choose what fits best for you and your lifestyle. Retirement options.
We also take care of our employees once they retire. That's why we offer the choice of a defined contribution or defined benefit pension plan or RSP's. Mortgage and auto financing benefits.
Employees save thousands on their mortgages and auto loans with best-in-category benefits. Real Recognition.
We recognize excellence throughout the year, through an online community that lets employees give kudos and thanks throughout the year. We're human, which means we like to have fun with events, celebrations, and recognition throughout the year. An award winning culture.
We're a Platinum member of Canada's Best Managed Companies and are regularly recognized by Canada's Most Admired Corporate Cultures and the BC Top Employers Awards. We reinvest 10% back into the community.
When we do well, our communities do well. That's why since 2000 we've invested over $90 million into our member's communities. Double your impact.
Through our employee volunteer program, Coast Capital donates $10 for every hour you volunteer to a Canadian charity or non-profit of your choice.
D&I at Coast 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.