The Senior Data Engineer designs and optimizes cloud-based data pipelines and integration solutions on Azure, ensuring data security and compliance. This role collaborates with product owners and data teams to build platforms for data-driven decisions, develops Power BI reports, and monitors data workflows.
Central 1 cooperatively empowers credit unions and other financial institutions to deliver banking choice to Canadians. Central 1 provides critical services at scale to enable a thriving credit union system. We do this by collaborating with our clients, developing strategies, products and services to support the financial well-being of their more than 5 million diverse customers in communities across Canada. For more information, visit www.central1.com.
What we offer:
- Work-life flexibility
- Hybrid work environment
- One time allowance to set up your office for remote first employees
- Variable annual incentive plan
- Generous annual vacation allotment
- Top-notch flexible benefits plan including family building and gender affirmation
- Retirement Plan, matched contributions at 6%
- Access to a learning platform and educational assistance support
- Access to a virtual wellness platform
- Career development opportunities
- Wellness Flex Fund to support personal interest and activities
- Day off to volunteer in your community and other paid time off options
- Corporate discounts
*subject to employment agreement
Job Summary:
This role acts as a subject matter expert in Azure Data Fabric to support the evolving data needs of Central 1. The Data Engineer is responsible for designing, implementing, and optimizing cloud-based data pipelines and integration solutions that enable secure, compliant, and actionable insights, supporting our mission of delivering exceptional financial services to our members.
This role collaborates with product owners, business intelligence teams, financial analysts, and IT stakeholders to build data platforms that empower data-driven decisions, enhance member experiences, and ensure regulatory compliance.
What you'll be doing:
- Design, Develop, and maintain scalable, secure data pipelines on Azure Data Fabric using Azure Data Factory, Azure Synapse Analytics, and similar tools
- Create and manage data pipelines to ingest, process, and store data from various sources.
- Integrate data from various source systems like payments systems, loan origination systems, and CRM data into a unified Azure Data Fabric for comprehensive analytics.
- Ensure data security, privacy, and compliance regulations across all Azure data environments.
- Document data solutions, processes, and best practices.
- Troubleshoots and resolves any data incidents and system disruptions
- Provide technical guidance and support to team members and stakeholders.
- Ensures all incidents are triaged, responded to and resolved in accordance with established standards and agreements
- Collaborate with data governance teams to enforce data quality standards, lineage tracking, and metadata management within the Azure ecosystem.
- Optimize data workflows for performance, cost-efficiency, and scalability in cloud environments, supporting the unique operational needs of a credit union.
- Monitor and optimize the performance of data solutions.
- Troubleshoot and resolve data-related issues.
- Support self-service data access initiatives, empowering business teams to extract insights securely and efficiently.
- Participate in data architecture reviews, contributing to the development of data lakes, data warehouses, and data mesh solutions that align with member-centric strategies.
- Develop, publish, and schedule Power BI reports and dashboards as per business requirements.
- Design user-friendly reports and visualizations that provide actionable insights.
- Collaborate with business stakeholders to gather reporting requirements and translate them into technical specifications.
- Build efficient data models using Azure Fabric and Power BI best practices for performance and usability.
- Create DAX queries and functions to support reporting needs.
- Maintain and optimize existing Power BI solutions, ensuring data accuracy and performance.
- Perform data analysis and troubleshooting to resolve data integrity and performance issues.
- Stay current with Azure innovations and financial industry best practices, ensuring our data solutions remain cutting-edge and compliant.
- Maintain a high level of quality and attention to detail, ensures all changes are implemented into production and do not generate any foreseeable incidents.
- Performs other duties as required to deliver exceptional service and to support Central’s business goals
- Participate in 24x7 on call responsibilities
What you'll have:
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
- 4+ years of experience in data engineering roles, with Azure cloud expertise.
- Strong proficiency in Azure Data Factory (ADF), Azure Synapse Analytics, Microsoft SQL Server Database, and Azure Blob Storage.
- Skilled in SQL, Python for building data transformation workflows
- Experience building data lakes and data warehouses optimized for payments and financial services data analytics.
- Strong understanding of ETL/ELT pipelines, data partitioning strategies
- Knowledge of DevOps practices for data solutions using Bitbucket, Argo and Azure DevOps, with a focus on automation and deployment efficiency.
- Experience integrating financial data systems and handling PII in accordance with financial regulations.
- Proficiency in Power BI Desktop, Power BI Service, and Power BI Gateway.
- Strong skills in DAX, Power Query (M Language), and data modeling.
- Experience with SQL and relational databases (e.g., SQL Server, Azure SQL).
- Proven ability to translate business requirements into technical specifications.
- Advanced knowledge and understanding of IT operations and processes
- Well-developed analytical, problem solving, organizational and time management skills.
- Familiarity using Jira, Confluence and Bitbucket
- Ability to communicate effectively both orally and in writing with technical teams and other co-workers, work to schedules, and adapt easily to changing priorities and business needs
Nice to Have:
- Microsoft Certified: Azure Data Engineer Associate or equivalent certifications.
- Microsoft Power BI certification: Microsoft Power BI Data Analyst.
- Knowledge of Python or R for advanced analytics.
- Experience integrating Power BI with other Microsoft products (e.g., Teams, SharePoint).
- Familiarity with Agile methodologies and tools (e.g., Jira, Azure DevOps).
- Previous experience working with credit unions, banks, or financial institutions.
- Good understanding of Problem, Incident and Change Management (ITIL Certification is preferred)
Central 1 is an equal opportunity employer and committed to building an inclusive workforce by creating an environment where everyone feels like they belong and has the opportunity to be successful. We welcome all applicants to join our diverse workforce and we will provide an accessible candidate experience including, but not limited to accommodations to interview sites and alternate formats upon request to our Recruitment team.
Top Skills
Argo
Azure Blob Storage
Azure Data Factory
Azure Devops
Azure Synapse Analytics
Bitbucket
Dax
Microsoft Sql Server
Power BI
Power Query
Python
SQL
Similar Jobs
Artificial Intelligence • Marketing Tech • Software
As a Principal Data Engineer, you will drive the direction of the Data Warehouse, enabling data access across departments and designing data pipelines to handle massive data ingestion and ensure compliance with data regulations. You will mentor less experienced team members and optimize pipeline performance.
Cloud • Mobile • Software
As a Data Engineer at BuildOps, you will design and maintain data pipelines, focusing on data processing, automation, and machine learning enhancement. Collaboration with various teams to resolve technical data challenges is key, as is the continuous improvement of data workflows and ETL infrastructure.
.png)
Big Data • Cloud • Digital Media • Machine Learning • Mobile • Software • Industrial
As a Principal Data Engineer at Autodesk, you will be responsible for enhancing data processing and analytics systems, developing ES pipelines, ensuring data quality, and collaborating with various teams. You will lead a team of engineers, make architectural decisions, and focus on modernizing existing systems to scale with business needs.
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
