Sql server Jobs in Ajax, ON

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

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

Job ID: 25-

Number of Vacancies: 2

Level: MP4

Duration: 12 months

Hours of work: 40 hours per week

Location: Colonel Sam Drive, Oshawa

Work Mode: % remote

Job Overview

Job Functions:

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.

Job Duties:

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.