Data Analyst (Lac-Brome)

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 - Robust 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 Apply on Kit Job: kitjob.ca/job/2ovf2p