Data Analyst: Government BI & SQL Specialist

Business Needs Inc; Everett (MA); Hybrid; USD 69,000 - 76,000; Full time

Job summary

Commonwealth of Massachusetts is seeking a Data Analyst to support enterprise initiatives. The role partners with stakeholders, project managers, and developers to analyze business needs, improve processes, and deliver scalable solutions in a fast-paced Agile setting.

The ideal candidate has 4-5 years of data analysis/BI experience, proficiency in SQL, Power BI, Salesforce reporting, and strong communication skills to bridge business and technical teams.

Qualifications

• 4-5 years professional data analysis / BI / reporting experience.
• Salesforce data / reporting experience.
• Snowflake experience.
• Advanced SQL including complex joins / query optimization.
• Power BI experience.
• Advanced Microsoft Excel experience.
• R / Stata / Python statistical analysis experience.
• Executive dashboard / KPI / outcome measurement experience.
• Data validation / quality / readiness assessment experience.
• Funnel / journey / trend / performance analysis experience.
• Licensing qualification / Family Child Care domain experience or knowledge (Y/N)
• LMS / web analytics / application lifecycle reporting experience (Y/N)
• Public sector / government / education experience (Y/N)

Responsibilities

• Utilizes program development series or other technical tools for agency reporting purposes.
• Develop reports and cubes according to analyst-defined specifications.
• Assume independent responsibility for specific subject area within the reporting and analysis arena.
• Provide expertise within the warehouse framework.
• Conduct technical training
• Work with architect and development lead to improve performance and extend functionality.
• Maintain and document operational environment.
• Install and upgrade the application.

Skills

SQL

Power BI

Salesforce

Snowflake

Excel

R/Python/Stata

Dashboards

Data validation

Tools

SAS

Business Objects

Job description

Commonwealth of Massachusetts is seeking a Data Analyst to support enterprise initiatives. The role partners with stakeholders, project managers, and developers to analyze business needs, improve processes, and deliver scalable solutions in a fast-paced Agile setting.

The ideal candidate has 4-5 years of data analysis/BI experience, proficiency in SQL, Power BI, Salesforce reporting, and strong communication skills to bridge business and technical teams.