OPEN: BI Developer

Cpus Engineering Staffing Solutions Inc.; Oshawa; Remote; CAD 80,000 - 100,000; Full time

Job summary

A prominent engineering staffing company is seeking a BI Developer to design and develop enterprise-grade data models. The role is 100% remote and requires 5+ years of experience in BI development, expertise in Power BI, and strong SQL skills. Candidates with a Bachelor's degree in computer science or related field are encouraged to apply. This position offers a unique opportunity to enhance data-driven decision-making processes within a supportive team environment.

Qualifications

• 5+ years of experience in BI development focused on enterprise-scale data modeling.
• Strong SQL skills and experience with cloud-based data warehousing solutions.
• Hands-on experience with Azure Synapse Analytics and Databricks for data modeling.

Responsibilities

• Designing, developing, and maintaining enterprise-grade semantic data models.
• Develop and optimize data models within the enterprise solution stack.
• Collaborate with data engineers to design data flows and pipelines.

Skills

Enterprise-scale data modeling

SQL

Power BI

DAX

Azure Synapse Analytics

Data governance

Education

Bachelor's degree in computer science or related field

Tools

Power BI

Azure

Databricks

Job description

Overview

We are currently requesting resumes for the following position: BI Developer

Resume Due Date: Tuesday, September 23, 2025 (5:00PM EST)

Job ID: 25-153

Number of Vacancies: 2

Level: MP4

Duration: 12 months

Hours of work: 40hours per week

Location: CHQ, 1908 Colonel Sam Drive, Oshawa

Work Mode: 100% remote

Responsibilities

• Semantic Modeling & Enterprise Reporting is responsible for designing, developing, and maintaining enterprise-grade semantic data models and scalable business intelligence solutions aligned with organizational reporting governance and data strategy.
• This role will ensure that Business Intelligence models and supporting data infrastructure will enable trusted, consistent, and self-service analytics across the organization.
• This role combines technical expertise in reporting applications such as Power Bl, enterprise data modeling, and cloud data platforms with a deep understanding of data governance and scalable analytics architecture.
• Semantic Model Development: Design and build robust, reusable, and governed semantic data models, ensuring consistency and scalability for enterprise reporting and self-service analytics.
• Data Platform Integration: Develop and optimize data models within the enterprise solution stack (i.e. Azure, Databricks, Power Bl, etc.) to serve as authoritative sources for Power Bl or similar reporting applications and other Bl tools.
• Alignment with Governance: Collaborate as required with data governance, enterprise architecture, and business teams to ensure all Bl models adhere to data quality, security, and reporting governance frameworks.
• Scalable Architecture: Architect Bl solutions that scale across business units, leveraging best practices in data modeling, partitioning, and performance optimization.
• Requirements Gathering & Translation: Engage with business stakeholders as required to gather analytics requirements and translate them into technical design specifications for semantic models and data pipelines.
• Data Quality & Documentation: Implement as required data validation, lineage tracking, and metadata documentation to ensure transparency, trust, and ease of use for business users.
• Collaboration: Work with data engineers to design data flows and pipelines within existing enterprise technology solution stack (i.e. Azure, Data Bricks, etc.) to ensure seamless integration with the reporting platform.
• User Enablement: Develop and maintain reusable datasets, certified data models, and documentation to support self-service Bl and reduce reporting duplication.
• Continuous Improvement: Stay up to date with advancements in Power Bl, Azure Synapse, Databricks, and enterprise Bl best practices; proactively recommend improvements to data modeling and governance.

Qualifications

• Bachelor’s degree in computer science, Information Systems, Engineering, Mathematics, or a related field.
• Certification in Power Bl, Azure, or related technologies is an asset.
• 5+ years of experience in Bl development, with a focus on enterprise-scale data modeling and reporting.
• Proven expertise in building and managing semantic models in Power Bl or similar tools (including DAX, tabular modeling, and dataset certification).
• Hands-on experience with Azure Synapse Analytics and Databricks for data modeling, transformation, and integration.
• Strong SQL skills and experience working with cloud-based data warehousing solutions.
• Demonstrated experience aligning Bl solutions with data governance, security, and quality standards.
• Experience collaborating with data engineering, governance, and business teams in a cross-functional environment.
• Strong and proven experience with Cl/CD for Power Bl and data models.
• Strong and proven familiarity with data cataloging and lineage tools (e.g., data cataloging software).
• Strong and proven experience with SQL, Python, DAX advanced data transformation.
• Strong and proven knowledge of security models (e.g., row-level security) in Power Bl and Azure.

Our client is dedicated to promoting employment equity and encourages applications from equity-seeking communities including but not limited to: Indigenous Peoples, racialized individuals, persons with disabilities, and women. Our client aims to build a diverse team that reflects the communities it serves, enhancing its ability to meet their needs. We are committed to an inclusive and accessible work environment and invites all qualified individuals to apply, offering accommodations during the application, interview and onboarding process as needed. This effort supports our client’s long-term strategy for equity, diversity, and inclusion.