System Analyst (Data Engineer) –Information Technology

Alberta Blue Cross® is an Alberta based organization dedicated to delivering exceptional customer experience and community leadership. We’re committed to providing the best health coverage to over 1.8 million members and take an active role in promoting wellness. We believe in what we do—and place trust in our employees to deliver our vision.

Working at Alberta Blue Cross® means having a career where you’ll be recognized for your contributions. We value diversity, encourage our employees to maintain a healthy work-life balance and provide opportunities for career growth.

OVERVIEW:

With over 300 employees in our IT department, individuals contribute to the maintenance, enhancement, and new development of applications that serve both our internal and external customers.

Alberta Blue Cross has an immediate opportunity, for a permanent full-time Data Engineer to join our team. This position will lead designs and implement data integration and BI/DW solutions to enable business analytics across the organization. You will be part of a cross functional team to deliver a breadth of solutions to solve our most challenging business problems, with a focus on Big Data, BI/DW, Data Integration, Data Governance, Master Data and Analytics applications. Each of these applications leverage a different mix of traditional and emerging technologies to achieve business outcomes.

WHAT YOU WILL DO:

• Review requirements with users and provide time estimates for task completion.
• Communicate effectively with your team, team manager and business customers.
• Work with and lead cross functional teams on designing, building, and optimizing data systems
• Follow Systems Development Life Cycle best practices.
• Be a leader in your team to help bring in all viewpoints to resolve any differences and conflicts.
• Assess the root cause of issues, recommend changes, and resolve issues.
• Contribute and be accountable to your team’s activities and workload management.
• Work as part of a project team as required.
• Follow IT Controls practices (e.g. IT Governance, Data Privacy) to ensure quality output.
• Facilitate technical meetings with stakeholders, and advise technical option analyses based on leading practices in language understandable by stakeholders
• Translate business rules and requirements into data objects, data models, source to target mappings and write abstracted, reusable code components
• Help your team to persevere through distractions, shifting priorities, and repeated obstacles.
• Perform systems testing with both IT and business customers. Provide support during various phases of testing.
• Engineer data integration and BI/DW solutions to enable business analytics and insights
• Instill in others the willingness to do the job and work toward common objectives.
• Work collaboratively with multiple teams across the organization.
• Embrace continual learning and understanding of the application environment, interdependencies, and data and systems integrations.

WHAT YOU WILL HAVE:

• Exceptional planning, organizational, analytical, problem-solving skills.
• 3+ years of experience implementing distributed systems and data architecture - design and implement batch and stream data processing pipelines, knows how to optimize the distribution, partitioning, and MPP of high-level data structures.
• 3+ years of progressive experience with analysis, design, development, testing and deployment.
• Applied knowledge of data storage and BI technologies such as Data Lakes, Data Warehouse, Databricks, Azure analysis services.
• The ability to think outside the box to solve complex problems.
• Experience in Oracle database development and PL/SQL would be an asset.
• Experience with ETL development tools (e.g. Talend, Informatica, Synapse Pipelines).
• A bachelor’s degree or diploma in Computer Science or related technical discipline.
• A mindset for contributing to a healthy culture in a supportive and collaborative team environment.
• Exceptional consultation skills, with the ability to convey technical ideas to both technical and non-technical audiences.
• Ability to write efficient, complex SQL queries against very large data sets, perform ETL optimizations, working with big data processes.
• Leadership skills to create positive, respectful and productive working relationships with all types of stakeholders.
• Experience working with and building data pipelines, applications to stream and process datasets at low latencies leveraging Azure Cloud using Azure Data Factory, Azure Functions, and Python.

This position will remain open until suitable candidates are selected.

Alberta Blue Cross® is an inclusive employer committed to a workplace that reflects the diversity of the communities we serve. We empower and are advocates for our employees by welcoming, respecting and valuing their unique perspectives, backgrounds, and experiences.

We offer a competitive salary and benefits package and the opportunity to work in an innovative, high-energy team-focused environment. If you have the qualifications we are looking for, please apply.