Specialist - Data Intelligence Specialist

Reference # 41873

Waterdown, ON About the Role The Data Intelligence Specialist is responsible for designing, developing, and optimizing enterprise data solutions that enable trusted, scalable, and actionable business intelligence across the WESCAM. This role supports cleaning, merging, transforming, and governing data from multiple enterprise systems into semantic models, analytical views, and contemporary data lake architectures. This role works closely with IT leadership, business stakeholders, engineering teams, data professionals, and external partners to ensure that enterprise data assets are standardized, accessible, and aligned with operational and strategic business goals.

This role combines business analysis, data transformation, systems integration, and data modeling expertise to improve organizational decision-making capabilities.

Primary Responsibilities Data Integration & Transformation Analyze and integrate data from multiple business applications, databases, APIs, cloud platforms, and external systems.

Create reusable semantic layers, curated datasets, and business-ready data models.

Support the design and maintenance of enterprise data lakes and modern data platforms.

Business

Analysis & Solution Design Translate business needs into logical and physical data models.

Document business rules, transformation logic, lineage, and technical specifications.

Semantic

Modeling & Analytics Enablement Build semantic views and analytical models to support BI tools and self-service reporting.

Support dashboard, visualization, and enterprise reporting initiatives. Data Governance & Quality Implement data quality standards, monitoring processes,



and governance controls.

Troubleshoot data discrepancies and resolve integration or transformation issues. Project & Stakeholder Management Coordinate work with cross-functional teams including developers, architects, analysts, and business leaders.

Communicate technical concepts and operational processes effectively to both technical and non-technical audiences.

Required Capabilities Technical

Skills SQL, Python, or similar data processing technologies

Data modeling and semantic layer design

Data lake and warehouse architecture

Metadata, lineage, and governance tooling Experience with Azure, Databricks, Fabric data platforms.

Experience building semantic models in Power BI, or similar BI platforms.

Knowledge of data governance frameworks and master data management.

Familiarity with API integrations, data virtualization, and real-time streaming.

Business Analysis Skills

Requirements gathering and documentation

Process analysis and workflow understanding

Problem-solving and analytical thinking Communication Skills Ability to explain technical concepts to non-technical audiences.

Strong written and verbal communication skills.

Ability to influence and collaborate across departments Desired Education and Experiences Bachelor’s Degree in Information Technology, Computer Science, Engineering, Data Analytics, Business Technology, or related discipline with a minimum of 4 years of relevant experience; or

Graduate Degree with a minimum of 2 years of related experience; or In lieu of a degree, a minimum of 8 years of directly related *This posting is for a current vacancy. In the province of Ontario, Canada, the pay range for this position will be $75,000 - $105,000

📌 Spec, IT Business Analysis (Canada)
🏢 L3HHCM20
📍 Canada