Lead BI Developer

Headquartered in Denver, the company has grown since 1988 by acquiring regional IT providers. Large rollouts are routine here, such as imaging 12,000 laptops for a state agency over one summer.

Overview:

Denver Computer Services is standardizing on Power BI. This hire will rebuild old Excel and SSRS reports and retire the ones nobody opens. Hybrid, with three days a week in our Denver office.

Duties:

• Validate report numbers against source systems before release.
• Develop Power BI reports and semantic models using DAX and Power Query (M)
• Create SSIS or Azure Data Factory packages to load reporting data.
• Schedule refreshes, maintain gateways and act on refresh failure alerts.
• Document data definitions, measures and report owners.
• Build Tableau workbooks and publish them to Tableau Server or Tableau Cloud.
• Train business users on self-service reporting.

Minimum qualifications:

• Good visual sense for dashboards: layout, color, labeling.
• Understanding of Kimball dimensional modeling.
• Strong T-SQL or equivalent SQL skills.
• Ability to turn loosely worded business requests into specific report requirements.
• Experience with ETL tools such as SSIS, Azure Data Factory or Informatica.
• Advanced Power BI (DAX, Power Query, data modeling) or Tableau (calculations, LOD expressions, extracts)
• Familiarity with ERP, CRM or HRIS data structures.

Preferred qualifications:

• Tabular Editor and ALM Toolkit.
• PL-300 or DP-600 certification.

The salary range for this role is $168,000 to $215,000/year. This range reflects base salary only.

Pay and benefits:

• Health, dental and vision coverage starting on day one.
• 401(k) with a 100% match up to 5%.
• 12 weeks of paid parental leave.
• Professional development budget.
• Employee assistance program.
• Referral program.
• Paid parental leave.

We are an equal opportunity employer and value diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Applicants must be authorized to work in the U.S.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Denver Computer Services.