Remote BI Developer — Dashboards, SQL & Data Insights

Massachusetts Water Resources Authority; Norwich (MA); Hybrid; USD 91.000 - 134.000; Vollzeit

Zusammenfassung

Massachusetts Water Resources Authority (MWRA) is seeking a Reporting and BI Developer to design, develop, and maintain BI solutions for enterprise systems including EAM and ERP. The role focuses on reports and dashboards, with data analysis, requirements gathering, query development, testing and documentation as part of daily activities in a hybrid Chelsea, MA setting.

The position requires a Bachelor's degree in a related field, at least five years IT experience with three in enterprise

Qualifikationen

• Bachelor's degree in a computer science or related field is required or equivalent experience.
• At least five years IT experience with three years in IT development supporting enterprise apps (Infor CloudSuite Birst, IBM Maximo BIRT, SAP or Crystal Reports).
• Experience developing SQL queries, views, stored procedures, and BI dashboards/reports.
• ITIL Foundation v3 certification required or ability to obtain within 12 months.

Aufgaben

• Develops and maintains paginated reports and BI dashboards/visualizations.
• Gathers requirements and translates into reporting specifications and solutions.
• Creates complex SQL statements and data model relationships.
• Uses ETL and data management tools to prepare data for reporting sources.
• Maintains data access layers for user-friendly data access.
• Performs data analysis to verify report results against sources and expectations.
• Identifies data sources and performs cleaning and transformation.
• Provides proof of concept analyses on proposed datasets for sponsors.

Kenntnisse

SQL queries

BI dashboards

Data modeling

ETL

Ausbildung

Bachelor's degree in Computer Science or related field

Tools

Infor CloudSuite Birst

IBM Maximo BIRT

SAP

Crystal Reports

Jobbeschreibung

Massachusetts Water Resources Authority (MWRA) is seeking a Reporting and BI Developer to design, develop, and maintain BI solutions for enterprise systems including EAM and ERP. The role focuses on reports and dashboards, with data analysis, requirements gathering, query development, testing and documentation as part of daily activities in a hybrid Chelsea, MA setting.

The position requires a Bachelor's degree in a related field, at least five years IT experience with three in enterprise