The Role
BGC is seeking a Senior Analytics Developer to join our Business Operations team. In this role, youll develop core datasets in our SQL Data Warehouse and build Power BI models and reports that drive decision-making across the organization. As a bridge between SQL developers, and BI developers and business analysts, youll design scalable, reusable data models and curated datasets that empower analytics at every level.
This position can be located at one of the following offices:Vancouver, Kamloops, or Calgary.
Responsibilities
* Translate business requirements into technical requirements for scalable data models that support self-service analytics.
* Design, develop, and maintain robust, scalable semantic data models to support enterprise-wide reporting and analytics (e.g., finance, operations, HR, project delivery).
* Lead the development of curated datasets and transformation pipelines using tools such as SQL, DAX, and python.
* Build and enhance BI dashboards, reports, and visualizations using Power BI.
* Establish and enforce best practices for data modeling and performance monitoring to ensure scalable and efficient analytics solutions.
* Support the evolution of BGCs data platform by recommending improvements in architecture, tooling, and workflows.
* Develop and manage documentation and governance standards to promote data quality, consistency, and transparency.
* Partner with data analysts to optimize data accessibility and performance in tools like Power BI and PowerApps.
* Mentor junior team members and contribute to the development of internal data capabilities.
* Evaluate and recommend modern data tools and platforms to enhance BGCs analytics ecosystem.
Required Education, Experience & Competencies
* Bachelors Degree in Computer Science, Information Systems, Software Engineering, or a related discipline.
* 7-12 years of experience in data modeling, analytics, or BI development.
* Demonstrated ability to lead cross-functional data initiatives and communicate effectively with both technical and non-technical stakeholders.
* Strong understanding of dimensional modeling, data warehousing principles, data governance frameworks, and best practices for semantic layer design.
* Proven expertise designing and implementing semantic models using Power BI datasets.
* Advanced SQL skills and experience with modern data platforms (e.g., Azure Synapse, Snowflake, SQL Server).
* Experience with version control (e.g., Git), CI/CD pipelines, and agile delivery methodologies.
* Fluent in scripting languages (Python, VBA, or C#) for data transformation and automation.
* Strong analytical thinking, attention to detail, and a collaborative mindset.
* Previous experience working with human resources, accounting, project management, or operational data in a professional services environment is an asset.
Position Requirements
Travel and Vaccination
BGC is committed to maintaining a safe work environment to ensure the health and safety of employees while on business travel and during field assignments. To meet travel and client requirements, employees may be required to receive vaccinations such as yellow fever, COVID-19, malaria, etc. If you require an accommodation or wish to discuss your situation, please contact. BGC requires that you have a current passport for this position.
Company Benefits
BGC offers our employees the following:
* Our One Team culture supporting health, wellness, safety and diversity
* Comprehensive benefits package
o Health, Dental and Vision coverage
o LTD, Life, AD&D and Business Travel Insurance
o Employee Assistance Program
* Parental leave top ups
* Professional development and mentoring opportunities
* Flat management structure
* Flexible workplace with office and home arrangements
* Social and wellness activities
* Casual and professional work environment
The estimated base salary range for this position is $95,000-$120,000 CAD per annum, however base pay will be commensurate with job-related knowledge, skills, and experience. BGC's compensation package also includes a training allowance and a comprehensive medical and dental plan.
Equity, Diversity and Inclusion
BGC strives to create a workplace where equity, diversity and inclusion are embedded throughout our workplace culture and practices. Join us in our commitment to honour individuality, ensure fairness, and create a welcoming environment for everyone. As an equal opportunity employer, we encourage applications from all candidates, including those experiencing inequity such as racialized individuals, Indigenous People, women, people of diverse sexual orientations, identities and expressions, veterans, individuals with disabilities, people of all faiths, nationalities, marital status, ages, and family status. For assistance or accommodation with your application, please contact us at .
#LI-HYBRID