Job Description
Title: BI Developer
Resume Due Date: Tuesday September 23 2025 (5:00PM EST) Number of Vacancies: 2
Level: MP4
Duration: 12 months
Hours of work:40
Location: Oshawa ON (100% 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
- Bachelors 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.