About the Role
Horizon Tech Services Inc. is seeking experienced consultants for two anticipated contract opportunities supporting an enterprise data and analytics team. Opportunities are subject to client award and final contract requirements.
Responsibilities
- Location: Calgary, Alberta - Hybrid
- Schedule: 40 hours per week, Monday–Friday
- Anticipated term: January 2027–December 2029
Role 1 - Denodo and Data Analyst Consultant
- Implement, administer, and support Denodo Virtual DataPort (VDP).
- Develop and maintain source connections and virtual views.
- Troubleshoot connectivity, query execution, and performance issues.
- Support access controls, deployments, monitoring, and production operations.
- Coordinate changes with infrastructure, database, integration, and reporting teams.
- Develop and maintain integrations supporting Denodo views and downstream analytics.
- Design and support Microsoft Fabric workspaces, Dataflow Gen2, data pipelines, lakehouses, and warehouses.
- Develop Bronze, Silver, and Gold data layers.
- Build and support Power BI semantic models, reports, dashboards, and refresh processes.
- Monitor data quality, troubleshoot failures, and optimize performance.
- Gather requirements and document data mappings, business rules, and support procedures.
- Hands-on Denodo experience in an enterprise production environment.
- Strong SQL, data integration, and query optimization skills.
- Experience connecting databases, warehouses, APIs, and reporting applications.
- Familiarity with SQL Server, Oracle, Snowflake, SAP BW, Power BI, or Tableau.
- Energy or utilities industry experience is an asset.
- Hands-on Microsoft Fabric and Power BI development and support.
- Strong SQL, Power Query, DAX, and data modeling skills.
- Experience with enterprise data integration and ETL/ELT processes.
- Familiarity with Denodo and Python.
- Power Automate and API integration experience is an asset.
