Lead BI Developer - Remote

Headquartered in New York City, the company has grown since 1987 by acquiring regional IT providers. Across New York, the company runs 14 branch offices and a central depot for hardware staging and imaging.

About the role

The previous person in this role moved to another team. The Data and Analytics team is three people supporting the whole business. You'll own reports from data source to published dashboard. We need another Lead BI Developer - Remote to build the semantic models, reports and dashboards that finance and operations run on.

What you'll do

• Tune slow DAX measures and heavy visuals with Performance Analyzer and DAX Studio.
• Maintain SSRS paginated reports for operational and regulatory use.
• Train business users on self-service reporting.
• Schedule refreshes, maintain gateways and act on refresh failure alerts.
• Build Tableau workbooks and publish them to Tableau Server or Tableau Cloud.
• Validate report numbers against source systems before release.

Minimum qualifications

• 7+ years of BI or reporting development experience.
• Advanced Power BI (DAX, Power Query, data modeling) or Tableau (calculations, LOD expressions, extracts)
• Bachelor's degree in information systems, computer science, finance or equivalent experience.
• Strong T-SQL or equivalent SQL skills.

Preferred

• Looker and LookML.
• Python or R for data prep.
• PL-300 or DP-600 certification.

The base pay range for this position is $177,000-$230,000 annually. Actual pay depends on experience, skills and location.

What you get

• Medical, dental and vision insurance.
• 401(k) with 4% match.
• Paid parental leave.
• Home office stipend.
• Tuition reimbursement.

Ambercrest IT is an Equal Opportunity Employer, including disability and protected veteran status.

Most hires start within two to three weeks of an offer.

We are unable to sponsor visas for this position.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Ambercrest IT.