Associate Business Intelligence Developer

Founded in 2014, the business writes the billing, metering and customer portal software that small water and electric utilities run on. The product is a mobile app plus a React web dashboard, with a Python and PostgreSQL backend on AWS.

Role overview

Buffalo Digital is standardizing on Power BI. This hire will rebuild old Excel and SSRS reports and retire the ones nobody opens. You'll work with department heads to define KPIs and build reporting they can trust without calling us first. Remote within the US. The team meets in Buffalo once a quarter, travel covered. Weekday working hours, with room to shift your day when needed.

Job duties

• Gather requirements from business users and turn them into report mockups.
• Write stored procedures, views and T-SQL for reporting datasets.
• Maintain SSRS paginated reports for operational and regulatory use.
• Schedule refreshes, maintain gateways and act on refresh failure alerts.
• Validate report numbers against source systems before release.
• Build Tableau workbooks and publish them to Tableau Server or Tableau Cloud.
• Train business users on self-service reporting.
• Configure row-level security and workspace permissions.

Qualifications

• 1+ years of BI or reporting development experience.
• Ability to turn loosely worded business requests into specific report requirements.
• Bachelor's degree in information systems, computer science, finance or equivalent experience.
• Strong T-SQL or equivalent SQL skills.
• 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)

Preferred

• Background in finance or supply chain reporting.
• Looker and LookML.
• Microsoft Fabric or Synapse.

Perks and benefits

Compensation: $42.00 to $51.00 per hour

• Home office stipend.

Apply with your resume. A cover letter is optional.

Duration: 12 months. Start: Flexible.

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