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 modern 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 #LI-BD1