Supports a Wealth Management data modernization project by analyzing and profiling source data, documenting functional specifications and business rules, contributing to ETL and data modeling, supporting QA and data governance, and assisting architects and developers with Azure data mart configuration. Requires collaboration with solution architects, developers, product owners, and business experts, plus practical knowledge of Azure storage and integration services and Power BI Desktop, Service, and gateway components.
Mandate Overview:
- The client is looking for a senior data analyst within the
delivery team of the GPAP modernization project in Wealth Management. The role
spans three fronts: understanding and enhancing source system data, supporting
quality assurance, and supporting design work with the architects. This person
documents the rules to apply, profiles data, participates in ETL work and
supports the developer in configuring the data mart, without owning core
development or model design. The requirements point to a profile bridging
functional and technical work: functional specifications, data modeling, ETL,
Azure storage and Power BI. QA and data governance tasks appear in the
responsibilities but are not listed among the requirements.
- Candidate sought: a senior data analyst who has
written functional specifications on large-scale data projects and has taken
part in ETL and data modeling work in an Azure environment (Data Factory, Data
Lake, Synapse or Azure SQL). This person works daily with architects,
developers, POs and business experts, and knows Power BI beyond report creation
(Service, gateway).
Requirements
Required:
- Writing functional specification documents
- Teamwork with solution architects, development teams, POs
and business experts
- Knowledge of operational analytics
- Knowledge of data modeling
- Familiarity with data modeling tools
- Knowledge of ETL
- Azure data storage environments (Data Storage, Data Lake,
Blob Storage, Azure Data Factory, Azure SQL Database, Synapse Analytics)
- Power BI (Desktop, Service and components, e.g. gateway)
Profiles to Exclude:
- Profile whose data experience is limited to building Power
BI reports and dashboards, with no data modeling or ETL work on the resume.
- Data engineer or ETL developer profile with no demonstrated
functional specification writing.
- Business analyst profile with no data modeling or ETL work
tied to projects.
- Profile with no Azure storage or integration component named
on the resume (data experience exclusively on other platforms).
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Analyze and document source data, business rules, functional specifications, data models, and ETL requirements for a large-scale Azure data platform. Support architects, developers, business experts, and QA through data profiling, Power BI platform configuration, test case creation, validation scripts, and execution. Quickly assume ownership of an ongoing project while managing complexity and meeting deadlines.
Top Skills:
AzureAzure Blob StorageAzure Data FactoryAzure Data LakeAzure Sql DatabaseAzure Synapse AnalyticsData ModellingETLPower BI
Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Lead end-to-end fault isolation and emergency service recovery for telecom network solutions. Manage critical incidents, conduct root cause analyses, participate in technical task forces, and support business-critical events. The role requires deep expertise in 5G Core, EPC, IMS, CNIS, and CCD products, customer troubleshooting experience, strong leadership, bilingual French and English communication, and availability for 24/7 shift rotations.
Top Skills:
5G CoreCcdCnisEpcImsRoot Cause Analysis (Rca)Telecommunications Networks
Automotive • Professional Services • Software • Consulting • Energy • Chemical • Renewable Energy
Performs on-site safety and non-safety certification inspections, quality-system audits, field evaluations, testing, equipment calibration checks, and compliance reviews. Analyzes test results, identifies nonconformities, supports corrective actions, documents findings, communicates with manufacturers and authorities, and performs engineering calculations across electrical, mechanical, chemical, and fire-protection disciplines. Requires local and regional travel, remote work, customer interaction, and bilingual French-English communication.
Top Skills:
AmmetersIndustrial Control PanelsMicrometersSchematic DiagramsUl 508AUl StandardsVoltmeters
What you need to know about the Montreal Tech Scene
With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal


