Data Intelligence Specialist
- Hamilton, ON, Canada
- Waterdown, ON, L9H 0C5, Canada
In the province of Ontario, Canada, the pay range for this position will be $75,000 - $105,000
Applications open in a new tab.
Job details
- Pay
- In the province of Ontario, Canada, the pay range for this position will be $75,000 - $105,000
- Apply by
- Experience
- Graduate Degree with a minimum of 2 years of related experience; or
- Posting language
- English
- Posted
Original job description
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
More about this job
Responsibilities
The Data Intelligence Specialist designs and optimizes enterprise data solutions by cleaning, merging, and transforming data from multiple systems. They also build semantic models and analytical views to support business intelligence and ensure data governance across the organization.
Requirements
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 is required, along with strong analytical and communication skills.
Skills
- 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 Visualization
- Master Data Management
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Engineering
Keywords
- Data Intelligence
- SQL
- Python
- Data Lake
- Data Warehouse
- Azure
- Databricks
- Fabric
- Power BI
- Business Intelligence
- Data Governance
- Semantic Modeling
- API
- Data Integration
- Master Data Management
- Data Transformation
- Business Analysis
- Metadata
- Data Lineage
- Cloud Platforms
- Analytical Models
- Visualization
- Systems Integration
- Data Quality
- Reporting