remote
Data Operations Analyst Contract - OMERS
Systems Engineer
Contract Data Operations Analyst responsible for extracting, transforming, and validating large datasets, building automated pipelines, and ensuring data quality across enterprise systems using Python, SQL, and ETL tools.
About the role
Key Responsibilities
- Design, develop, and maintain automated data pipelines to ingest, transform, and load data from multiple source systems into data warehouses.
- Perform data profiling, cleansing, and validation to ensure accuracy, consistency, and completeness of datasets.
- Collaborate with business stakeholders to define data requirements, create data models, and deliver actionable insights through dashboards and reports.
- Implement and enforce data governance policies, including data lineage, metadata management, and security controls.
- Monitor pipeline performance, troubleshoot issues, and optimize processes for scalability and reliability.
Requirements
- Proven experience with Python (pandas, SQLAlchemy) and SQL for data manipulation and analysis.
- Hands‑on knowledge of ETL tools (e.g., Airflow, dbt) and data warehousing concepts.
- Strong analytical skills with the ability to translate business needs into technical solutions.
- Experience with data quality frameworks and data governance best practices.
- Excellent communication skills and ability to work collaboratively in a cross‑functional team.
Skills
pythonsqldata analysis