Hybrid Data Analyst: SQL, Power BI & ETL

Jobot; Denver (CO); Hybrid; USD 75,000 - 85,000; Full time

Benefits offered by this job

Work from anywhere (camera ready)

Job summary

Jobot in Denver seeks a sharp Data Analyst to join a tech-driven warehousing and logistics team. This analyst-first role focuses on SQL, complex queries, and owning reports; you’ll map data across SQL Server and Dataverse and build Power BI dashboards from a backlog of priority reports for Operations, Finance, and leadership.

The position is hybrid with two days per week in the Denver office and offers growth toward Senior Data Analyst.

Qualifications

• Must write complex SQL queries to support reporting and operations.
• Ability to quickly learn data environments, map tables and relationships.
• Experience with Power Automate, Power BI Fabric refresh pipelines, or ETL/ELT processes is a big bonus.
• Own your work and deliver backlog reports with minimal guidance.

Responsibilities

• Write, optimize, and maintain complex SQL queries, views, and stored procedures.
• Learn data environment, map tables and relationships across SQL Server and Dataverse.
• Build and maintain Power BI reports and dashboards for Operations, Finance, and leadership.
• Translate business questions into data-driven insights for technical and non-technical audiences.
• Own data quality across facilities, rent, and invoices; identify root causes.
• Support invoice validation, reconciliation, and exception reporting with Finance and Operations.
• Automate manual tasks using Power Automate and ETL/ELT pipelines.
• Provide basic database support and troubleshoot slow queries and production jobs.
• Document data models, report logic, and dependencies.
• Deliver ad hoc analyses for Executive Leadership Team and highlight risks.

Skills

SQL

Power BI

Dataverse

ETL/ELT

Power Automate

AI tools

Reporting

Tools

Power BI

Dataverse

SQL Server

Job description

Jobot in Denver seeks a sharp Data Analyst to join a tech-driven warehousing and logistics team. This analyst-first role focuses on SQL, complex queries, and owning reports; you’ll map data across SQL Server and Dataverse and build Power BI dashboards from a backlog of priority reports for Operations, Finance, and leadership.

The position is hybrid with two days per week in the Denver office and offers growth toward Senior Data Analyst.