Data Intelligence Specialist

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 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 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. *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

The Data Intelligence Specialist designs and optimizes enterprise data solutions by cleaning, merging, and transforming data into actionable business intelligence. They also manage data governance, quality standards, and collaborate with cross-functional teams to align data assets with strategic business goals.

Candidates should possess a degree in a relevant field with at least 2 to 4 years of experience, or 8 years of equivalent experience without a degree. Proficiency in data platforms like Azure, Databricks, and Power BI, along with strong analytical and communication skills, is required.

• Microsoft AzurePreferred
• Power BIPreferred
• SQLPreferred
• Business analysisPreferred
• PythonPreferred

Identified from the job description. Confirm important requirements above.

• SQL
• Python
• Data modeling
• Semantic layer design
• Data lake architecture
• Data warehouse architecture
• Metadata management
• Data governance
• Business analysis
• Power BI
• Azure
• Databricks
• Fabric
• API integration
• Data virtualization
• Master data management
• Data Lakes
• Influencing Skills
• Solution Design
• Analytical Thinking
• Workflow Management
• Azure Databricks
• Application Programming Interface (API)
• Data Analysis
• Business Intelligence
• Business Analysis
• Dashboard
• Business Technologies
• Decision Making
• Textiles
• Communication
• Computer Science
• Data Processing
• Information Technology
• Data Governance
• Data Integration
• Data Transformation
• Data Modeling
• Data Quality
• Data Virtualization
• Warehousing
• Governance
• Leadership
• Scalability
• Data Intelligence
• Problem Solving
• Python (Programming Language)
• Metadata
• Process Analysis
• Program Process Monitoring

• Data & Analytics
• Technology
• Software
• Engineering
• Data Intelligence Analyst
• Business Intelligence Developer / Architect
• Software Developers

Minimum education

Bachelor’s degree

Minimum experience

2+ years

Apply by

Oct 31, 2026

Posting language

English

Working hours

40 hours per week