Modernizing data warehouse pipeline architecture by gradually reducing reliance on SSIS and SQL-only patterns, introducing Python-based ETL, improving modularity, and setting the groundwork for a future move into PySpark, distributed compute, and eventually Databricks or similar cloud platforms.
Compensation
USD $185,000.00 - USD $185,000.00 /Yr.
Responsibilities
Learn and understand the existing Kimball-modeled SQL Server structure over time
Reverse-engineer SSIS packages and convert them into Python-based modular ETL pipelines
Build reusable Python frameworks for extraction, transformation, and loading
Begin introducing PySpark for scalable transformation patterns
Contribute to planning a future transition path (Databricks, Azure Synapse, Snowflake, etc.)
Requirements
Bachelor's
Nice to have: Experience modernizing legacy ETL systems
The Migration Analyst Developer role requires an individual who can design and implement complex Client focussed data mapping in line with the FNZ Migration SDLC, working with big data, designing, developing, maintaining and supporting the Extract, Transform and Load (ETL) process.
Compensation
The salary range for this position is CAD$126,000-170,000 per year.
Responsibilities
Working with Internal and Client SME resource to provide complex data mapping solutions in line with Client requirements, FNZ Solution and FNZ Migration SDLC
Producing technical migration outputs, such as data models, data mapping definitions and data validation rules in line with the target FNZ Product and Client Migration requirements
Designing, creating and maintaining SSIS packages to migrate data to FNZ databases
Designing and developing ETL workflows conforming to best practices and creating re-usable components
Providing solutions and recommendations for the resolution of technical issues that arise, ensuring solutions meet the technical specs, design and non-functional requirements
The Application Developer Senior is responsible for providing design, development, implementation, and support of complex enterprise applications and AI-enabled solutions that support TRS's strategic goals and member services. The incumbent will provide senior level software engineering, systems analysis, and technical leadership for high-impact projects, leveraging modern development practices, automation, and approved AI technologies to deliver secure, scalable, and maintainable solutions.
Compensation
108,036.00 - 135,044.00, Annual Salary
Responsibilities
Leads multiple concurrent software applications and AI-enabled initiatives that significantly impact TRS operations and member services.
Performs advanced analysis of business processes, operational requirements, and automation opportunities to design, develop, enhance, and maintain enterprise applications and solutions.
Designs, codes, tests, debugs, integrates and supports applications using multiple programming languages, frameworks, and platforms.
Conducts and leads code reviews, technical demonstrations, and quality assurance activities to ensure high-quality, secure, and maintainable software solutions.
Promotes and utilizes approved AI-assisted development tools to improve developer productivity, software quality, code maintainability, testing effectiveness, and delivery efficiency.
Requirements
Bachelor's degree from an accredited college or university in computer science, computer engineering or a closely related field
High school diploma or equivalent and additional full-time experience in computer programming or related experience may be substituted on an equivalent year-for-year basis
The Business Intelligence Manager leads the company’s reporting, analytics, and decision support efforts. This role manages a team of BI analysts and developers and partners with internal customers to deliver reports, dashboards, data solutions, and analyses that drive better business decisions.
Responsibilities
Lead, mentor, and manage a team of Business Intelligence analysts and developers; set priorities and review work for quality.
Partner with internal customers and department leaders to gather requirements and translate information needs into reporting and analytics solutions.
Oversee data extraction, ETL development (SSIS), and reporting (SSRS, QlikView) across SQL Server, MongoDB/NoSQL, and other sources, ensuring data quality.
Identify and track key KPIs, and deliver ad-hoc and strategic analyses that support decision-making.
Support financial forecasting, budgeting, and variance analysis in partnership with the Controller.
Requirements
Bachelor’s degree in quantitative fields such as Mathematics, Statistics, Economics, Finance, Industrial Engineering, Computer Engineering, or Information Systems
Leads reporting, analytics and data solutions for Procurement, Supply Chain and Finance, including the Autonomous Source-to-Pay roadmap, overseeing technical leads and developers across SAP S/4HANA, Power BI, Databricks, CDS, Genie, AI and Fiori solutions.
Responsibilities
Define the strategy and roadmap for SAP S/4HANA reporting, data and technical development
Lead and develop technical leads and developers across ABAP, Fiori/UI5, data engineering and reporting
Manage hiring, performance, succession, budget, capacity and vendor resources
Own end-to-end delivery of the reporting and data portfolio across multiple projects
Support the Autonomous Source-to-Pay roadmap by translating Procurement, Supply Chain and Finance needs into reporting priorities, insights and delivery plans
Requirements
Bachelor's degree in Computer Science, Information Technology or a related field
The Data Analytics Engineer III is responsible for designing and creating tables within data marts, data lakes and data warehouse and all related extraction, transformation and load of data functions. Work in a variety of settings to build systems that collect, manage, and convert raw data into usable information for analytics developers and business analysts to interpret. Their goal is to make data accessible so that organizations can use it to evaluate and optimize their performance. They also develop and test architectures that enable data extraction and transformation for predictive or prescriptive modeling. Data engineer will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. Takes direction and guidance from lead data engineers and department leadership to work towards enhancement of self and the team's capabilities around data and analytic competencies. Mentors junior data engineers and guides users across the organization to promote data education and a data-driven culture in all aspects of clinical and business operation
Compensation
Data Analytics Engineer $82,931.74 - $114,031.14
Responsibilities
Designing and creating tables within data marts, data lakes and data warehouse and all related extraction, transformation and load of data functions
Building systems that collect, manage, and convert raw data into usable information for analytics developers and business analysts
Developing and testing architectures that enable data extraction and transformation for predictive or prescriptive modeling
Expanding and optimizing data and data pipeline architecture
Optimizing data flow and collection for cross functional teams
Requirements
Bachelor's Degree in Business, Computer Science, Engineering, Information Systems, Public Health, or related field
Perform day-to-day administrative duties on Microsoft SQL Server instances, develop and maintain SSIS jobs and write Transact-SQL code for database management and optimization, and conduct performance tuning.
Responsibilities
Perform day-to-day administrative duties on Microsoft SQL Server instances, including backup, restore, and general troubleshooting
Develop and maintain SSIS jobs and write Transact-SQL code for database management and optimization
Conduct performance tuning to enhance database efficiency and responsiveness
Collaborate with software engineers to develop solutions using open-source PostgreSQL or other cost-effective alternatives
Participate in initiatives to modernize infrastructure, reducing reliance on SQL Server by leveraging cloud technologies
The Associate Director, Applied Informatics role serves as a senior technical contributor responsible for designing, developing, and advancing the data infrastructure, automation frameworks, and analytical enablement capabilities that support SCA Health's Enterprise Analytics organization.
Compensation
USD $125,000.00/Yr. USD $135,000.00/Yr.
Responsibilities
Design, create, and maintain enterprise data solutions utilizing Microsoft SQL Server technologies, including stored procedures, functions, views, and SSIS package development using Visual Studio.
Serve as technical review steward for the team’s full development lifecycle, ensuring adherence to enterprise standards for data quality, coding, performance, scalability, and technical best practices.
Serve as a technical lead for complex healthcare data integration, transformation, and analytics enablement initiatives while supporting the implementation of enterprise data governance principles.
Establish scalable, reusable data architectures that support enterprise reporting and advanced analytics, while recommending technical approaches that maximize value while minimizing complexity and maintenance burden.
Support long-term modernization and standardization efforts across analytics platforms, database environments, data movement processes, and ETL workflows.