Competition number 12601

Enterprise BI Developer & Analytics Architect


Job Category

Information Technology

Permanent/Temporary/Non-Permanent Hourly

Permanent

Apply Before

May 11, 2026

Job Schedule

Full time

Hours per week

35

Pay range

$96,387.20 - $120,484.00

Job Description

The Enterprise Data Analyst III, Data Specialist provides senior-level leadership in enterprise analytics by shaping and advancing the County’s data strategy. This role is responsible for designing and governing enterprise analytics and BI platform data architecture, establishing standards for business intelligence (BI), and ensuring high-quality, trusted data across the organization.

As a technical leader, this position translates complex business needs into scalable data solutions that support self-service data analytics, artificial intelligence, and data-informed decision-making. The role also contributes to building data literacy across the organization by mentoring team members, collaborating with business partners, and fostering a strong data-driven culture.

Key Responsibilities:

  • Leads the design, development, and governance of enterprise Business Intelligence data layers, ensuring scalable, consistent semantic models and certified datasets across the organization
  • Establishes and enforces enterprise standards for modelling, KPIs, DAX, and naming conventions while delivering advanced performance optimization across BI datasets and models
  • Ensures raw data from multiple source systems is cleaned, standardized, validated, and transformed into reliable analysis-ready datasets through automated data pipelines, supporting accurate and trusted reporting across the organization
  • Provide technical leadership, mentorship, and coaching to data analysts and business users to strengthen data literacy
  • Collaborate with cross-functional teams to translate business needs into scalable, high-value data solutions
  • Act as a strategic advisor to leadership on data, analytics, and modernization opportunities
  • Drive continuous improvement through automation, innovation, and best practices
  • Support and expand self-service analytics capabilities and enterprise BI adoption
  • Lead BI visualization strategy and dashboard and reporting development using tools such as Power BI
  • Ensure compliance with data governance, security, and organizational standards
  • Contribute to the enterprise analytics roadmap, platform optimization, and cost-effective BI delivery
  • Foster strong relationships across teams and contribute to a collaborative Data Community of Practice
  • Staying current with technological developments in software development, systems support, and user support practices, ensuring the adoption of best practices as they evolve due to the dynamic nature of public IT offerings

Qualifications and Skills:

  • Post-secondary Degree in Computer Science, Data Science, Computer Engineering, Information Systems, or a related discipline and 6 years’ experience in a senior enterprise data analytics/BI specialist/architecture role or an IT related Post-secondary Diploma and 8 years’ progressive experience in an enterprise data environment.
  • Minimum 2 years of experience in BI data architecture, enterprise data modelling, semantic layer design and performance tuning, integrations, cloud analytics development, and enterprise analytics
  • Demonstrated experience deploying and operationalizing BI data governance standards, modeling guidelines, semantic conventions, and KPI/DAX governance
  • Proven hands‑on experience with modern BI and data platforms such as Microsoft Fabric, Power BI, Azure, Databricks, Synapse, or Snowflake
  • Experience working within ITIL‑based change management, incident management, and service management processes
  • Advanced knowledge of data modelling, including star schema, role‑playing dimensions, semantic model design, and best practices for enterprise analytics
  • Advanced Power BI solution delivery capabilities, including enterprise scale reporting, reusable design systems, accessibility and usability standards, and consistent user experience
  • Proficiency in ETL/ELT development, integration patterns, APIs, and orchestration tools
  • Python experience is an asset
  • Ability to translate business requirements into scalable technical data solutions
  • Working knowledge of data governance, data quality, and data management best practices
  • Ability to collaborate with cross-functional teams and manage multiple priorities in a complex environment
  • Demonstrated coaching and mentorship abilities
  • Strong communication and stakeholder engagement skills
  • Strong analytical, problem-solving, and strategic thinking abilities

Conditions of Employment:

  • Submission of a Satisfactory Criminal Record Check  

Who We Are:

Strathcona County is a specialized municipality located in the heart of Alberta.  Our vision is to become Canada’s most livable community, where our workplace culture and identity are supported by our people plan and values of integrity, respect, safety, fairness, and cooperation.  

Why Join Strathcona County: (depending on position)

  • Competitive salary and comprehensive benefits package, which includes:
    • Extended health and dental coverage    
    • Health and wellness spending account    
    • Life and disability insurance
    • Retirement and pension programs  
    • Earned day off program
    • Employee and family assistance program
  • Commitment to employee development, through internal and external training and development opportunities
  • Well-being programs and a safety culture focused on physical and psychological health in the workplace

Equivalencies of education and experience may be considered. This role may be eligible to participate in our hybrid work program.  

This competition may be used to fill future vacancies for similar positions within the next 6 months.  

Strathcona County is committed to an inclusive, respectful, and equitable workplace that represents the community we serve. We welcome applicants from all backgrounds who can contribute diverse perspectives and experiences.

We thank all applicants for their interest; however, only those selected for an interview will be contacted. 

Apply now

Back to Careers