Data Analyst - Data Integration & Enablement

• Partner with business and technology stakeholders to understand business needs and translate them into clear, actionable data integration, reporting, and analytics requirements.
• Profile and analyze source systems, data structures, and business rules using SQL and Python to identify data relationships, anomalies, quality issues, and integration requirements.
• Analyze and document source-to-target data flows supporting the Enterprise Data Warehouse, Data Lake, Data Mesh, ODS, and downstream reporting and analytics solutions.
• Define and maintain source-to-target mappings, transformation rules, metadata, business definitions, and data lineage to improve data transparency, traceability, and regulatory compliance.
• Develop and execute comprehensive data validation and testing activities, including data reconciliation, transformation validation, test cases, and data quality controls.
• Develop and enhance automated processes using SQL, Python, and modern data technologies to improve the efficiency of data profiling, validation, reconciliation, and reporting.
• Collaborate with data engineers, architects, business analysts, and end users to troubleshoot data issues, perform root cause analysis, and ensure delivered solutions meet business and functional requirements.
• Contribute to data modernization and continuous improvement initiatives using technologies and approaches such as dbt, Databricks on GCP, Data Mesh, and AI/GenAI.
• Promote data quality and documentation best practices, share knowledge across the team, and provide guidance or mentorship to team members as appropriate., * Exposure to modern data platforms and technologies such as Databricks, dbt, GCP, Enterprise Data Warehouses, Data Lakes, Data Mesh, and Operational Data Stores (ODS).
• Experience supporting data environments within financial services, banking, regulatory reporting, or another highly regulated industry.
• Experience coordinating project activities, supporting workstreams, or mentoring team members.
• Exposure to AI/GenAI concepts, AI-enabled data solutions, or prompt engineering.

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Business, or a related discipline, along with 2+ years of experience in data analysis, data integration, business intelligence, or a related data-focused role.
• Strong hands-on SQL skills, including complex queries, joins, aggregations, data profiling, transformation analysis, reconciliation, and data validation.
• Working proficiency in Python for data analysis, automation, data quality validation, and data integration activities.
• Experience analyzing source and target data models and documenting source-to-target mappings, transformation logic, metadata, data lineage, and business rules.
• Solid understanding of data quality, data testing, reconciliation, ETL/ELT, data integration, and troubleshooting within enterprise data environments.
• Strong analytical and problem-solving skills, with the ability to investigate complex data issues, identify root causes, and recommend solutions.
• Strong requirements gathering, documentation, and stakeholder communication skills, with the ability to translate business needs into actionable data requirements.
• Ability to collaborate effectively with both business and technology teams in a complex enterprise environment.