Data Analyst

Title: Data Analyst Location: Remote Duration: June 2026 - May 2027 Bilingual : French/English Clearance: Must be Eligible for Reliability Status Responsibilities: Gather, document, and analyze data and information management requirements Work with stakeholders to translate business needs into data solutions and products Create and review data models, ETL mappings, SQL ETLs, solution designs, and data flows Ensure solutions align with enterprise data architecture and governance standards Understand source-to-target data lineage and legacy data structures Collaborate with data architects, governance teams, and business SMEs Produce clear documentation to support validation and sign-off processes Project Focus: Design and implement future-state data solutions using medallion architecture (Bronze/Silver/Gold) Support modernization of financial reporting data related to loans, guarantees, commitments, and credit exposure Reduce manual processes and transition away from legacy systems Required Skills: 7+ years as a Data Analyst or Data Modeler Strong SQL programming and ETL development experience Experience reverse engineering legacy ETL/DataStage processes Hands-on experience with dimensional/relational data modeling Experience with Databricks medallion architecture Strong skills in SQL, Python, Apache Spark, and Azure Data Platform technologies Strong analytical, communication, and documentation skills Assets: erWin, Denodo, Power BI CI/CD experience Agile environment experience Bilingual French/English