Description
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
