Data Engineer

Reporting to the Manager, Data and Information Services in the Information Technology Division, this position designs, builds and maintains data systems and pipelines to ensure accurate, secure, and timely information for SCIC’s reporting and analytics.

What You’ll Do :

Design, build, and maintain secure, scalable data pipelines and integrations using Azure Data Factory, Synapse Analytics, SSIS, SSRS and related tools.

Organize data into structured layers (Bronze, Silver, Gold) to improve quality, reliability, and traceability.

Implement technical solutions such as data masking, encryption, and access controls within data pipelines and platforms.

Configure tools to track data lineage and apply privacy safeguards, ensuring technical compliance with FOIP and internal standards.

Monitor and report on data quality and security issues to the manager for escalation when needed.

Monitor and analyze data pipelines to identify performance bottlenecks.

Tune and optimize transformation processes for speed, scalability, and reliability.

Investigate Data Lake ingestion and processing issues and take corrective actions.

Detect and handle unexpected changes in source data structure (Schema Drift) by updating pipeline logic and validation rules.

Partner with Actuarial and R&D teams to deliver accurate, timely data for analytics and other purposes.

Document technical processes, standards, and best practices; contribute to continuous improvement initiatives.

What You’ll Need

To be successful in this position you will need the completion of a bachelor’s degree in computer science, Data Engineering or related field and a minimum of three years’ experience in data engineering, including ETL / ELT, data modeling, and cloud platforms. Certifications in Azure Data Engineering is preferred.

Proficiency in SQL, Python, Spark, Git; experience with Azure tech stack (. Data Factory, Synapse, Purview, Azure Dev Ops).

Knowledge of data governance principles and privacy requirements (FOIP) to implement technical controls such as data masking, encryption, and access management.

Analytical and problem-solving skills to resolve complex technical issues independently.

Excellent communication skills to explain technical concepts to non-technical stakeholders.

Should the successful candidate participate in the Crop Insurance or AgriStability Programs, their account must be in good standing.

Competencies :

Service Excellence : Does more than what is required. Evaluates service delivery and makes recommendations to enhance the customer service experience. Builds strong, collaborative and mutually beneficial relationships with customers

Personal Leadership and Development : Leads as needed, regardless of position. Balances organizational, team and individual commitments. Embraces other perspectives in an empathetic manner

Strategic Thinking : Asks questions to gain a clear understanding. Prioritizes work in alignment with organizational objectives. Ensures that individual objectives relace the organizational direction

Decision Making : Can clearly explain their theory behind the decisions they made. Able to adapt decisions based on new and changing information. Considers the interests of various stakeholders when making decision.

Innovation : Challenges the status quo when needed and looks for ways to improve internal processes or practices. Looks for incremental improvements in work processes and results. Reflects on current environment and how the change will be received

Analytical Thinking : Asks questions to gain a clear understanding. Breaks down issues to identify core components. Identifies and breaks down critical components of complex situations to determine root causes.

Team Collaboration : Respects contributions of all team. Seeks the opinion of others when developing solutions. Gives credit and recognition to those who have contributed.

Communication : Responds to concerns in a respectful manner. Seeks input and sees things from others’ perspectives. Communicates complex issues clearly and with credibility.

Building Organizational Community : Is friendly, positive and professional with people they meet. Ensures cross-team collaboration for organizational effectiveness. Actively supports a one team approach.

Accountability : Acts in an ethical manner. Seeks and / or provides challenging assignments as a learning opportunity. Acknowledges the contributions and successes of others.

Process Management : Has basic knowledge of human resources policies, practices, and agreements. Prioritizes and streamlines work to maximize value added. Anticipates potential resource problems and makes needed adjustments to reduce concerns.

Performance Management : Achieves quality of work on a consistent basis. Makes timely decisions to move work forward; takes responsible risks to improve services and achieve goals. Takes / provides opportunities to lean and demonstrate new knowledge and skills.

Planning and Risk Management : Considers risks when developing plans. Thinks ahead, evaluates risks and plans contingencies. Organizes and prioritizes work to implement plans.

Saskatchewan Crop Insurance Corporation (SCIC) is committed to equity, diversity, inclusion and accessibility. SCIC welcomes applications from all individuals and encourages applicants to self-identify in their application. We affirm our Commitment to Reconciliation as we continue to build an inclusive culture that encourages, supports, and celebrates the diverse voices of our employees.

We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. Please tell us of accommodation measures required to help you be assessed fairly. Please note that the information you provide will be treated confidentially.