Denodo and Data Analytics
- Calgary, AB, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Working hours
- 40 hours per week
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
Implement, administer, and support Denodo Virtual DataPort, including virtual views, integrations, access controls, deployments, monitoring, and production operations. Build and support Microsoft Fabric data solutions and Power BI analytics, while monitoring data quality, optimizing performance, documenting requirements, and coordinating changes with related teams.
Requirements
Candidates need hands-on enterprise production experience with Denodo, strong SQL, data integration, and query optimization skills, and experience connecting databases, warehouses, APIs, and reporting applications. The role also requires hands-on Microsoft Fabric and Power BI development and support, with strong Power Query, DAX, and data modeling skills; energy or utilities experience and Power Automate experience are assets.
Skills
- Denodo Virtual DataPort
- SQL
- Data Integration
- Query Optimization
- Microsoft Fabric
- Power BI
- Power Query
- DAX
- Data Modeling
- ETL/ELT
- Python
- Data Quality
- API Integration
- Data Pipelines
- Data Warehousing
- Performance Troubleshooting
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Consulting
- Energy
Keywords
- Denodo
- Virtual DataPort
- Microsoft Fabric
- Power BI
- SQL
- Power Query
- DAX
- Python
- Power Automate
- Data Integration
- ETL/ELT
- Data Pipelines
- Dataflow Gen2
- Lakehouses
- Data Warehouses
- Bronze, Silver, And Gold Data Layers
- Semantic Models
- Data Modeling
- Virtual Views
- Query Optimization
- Data Quality
- API Integration
- SQL Server
- Oracle
- Snowflake
- SAP BW
- Tableau
- Energy
- Utilities
- Production Operations