At a Glance
- Tasks: Transform legacy reporting into modern, cloud-based analytics with SQL and data modeling.
- Company: Join a forward-thinking company focused on BI modernization and innovation.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Dynamic team environment with a focus on cutting-edge technology and career advancement.
- Why this job: Make a real impact by modernizing analytics and collaborating with diverse teams.
- Qualifications: 5+ years in Analytics Engineering with strong SQL and data modeling skills.
The predicted salary is between 121500 - 148500 $ per year.
Analytics Engineer, BI Modernization Overview
We are seeking an Analytics Engineer to support the modernization of legacy reporting and analytics capabilities into a governed, cloud-based architecture.
This is a hands-on, SQL-heavy role focused on analytical data modeling, semantic layers, data quality, and BI modernization.
Key Responsibilities
- Develop complex SQL queries, views, and reusable analytical datasets.
- Build and maintain analytical, dimensional, and semantic data models.
- Translate business and reporting requirements into scalable, governed data solutions.
- Optimize SQL and analytical models for performance, scalability, and reuse.
- Develop shared metrics, calculations, business rules, and semantic models.
- Support migration and modernization of legacy BI, reporting, and analytics platforms.
- Analyze legacy reports, SQL, workflows, calculations, and data dependencies as needed.
- Simplify and consolidate duplicated legacy logic into reusable modern solutions.
- Validate modernized outputs and investigate data or business-rule discrepancies.
- Apply Git, version control, peer review, documentation, testing, and controlled deployment practices.
- Collaborate with BI, analytics, data engineering, and business teams.
- Required Qualifications
- 5+ years of experience in Analytics Engineering, BI Engineering, Data Engineering, or a related field.
- Strong experience developing complex SQL queries, views, and reusable datasets.
- Experience with dimensional and analytical data modeling, including facts, dimensions, grain, measures, and relationships.
- Experience with relational databases and cloud-based analytical platforms.
- Experience with BI modernization, reporting migration, or legacy platform transformation.
- Strong analytical, troubleshooting, validation, documentation, and communication skills.
- Technical Skills
- Expert-level SQL, including complex joins, CTEs, window functions, aggregations, and query optimization.
- Strong analytical, dimensional, and semantic modeling skills.
- Experience with cloud data platforms; GCP/Big Query preferred.
- Experience with semantic or metrics layers such as Cube, dbt Semantic Layer, Look ML, or similar technologies preferred.
- Experience with BI tools such as Cognos, Alteryx, Tableau, or Power BI is an asset.
- Proficiency with Git/version control and modern development practices.
- Experience using AI-assisted development tools for SQL, coding, documentation, analysis, or troubleshooting is preferred.
Education
Bachelor’s degree in Computer Science, Information Systems, Data, Analytics, Engineering, or a related field preferred. Equivalent professional experience will be considered.
#J-18808-Ljbffr
Analytics Engineer, BI Modernization in Kelowna employer: Alquemy
At Alquemy, we pride ourselves on being an exceptional employer that fosters a collaborative and innovative work culture. Our commitment to employee growth is evident through continuous learning opportunities and mentorship programs, especially for roles like the Hybrid & Cloud IAM Architect & Tech Lead. Located in a vibrant area, we offer competitive benefits and a supportive environment that values diversity and encourages meaningful contributions from all team members.
