Title:  Spec, IT Business Analysis

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