Data Analyst

Brooksource; United States; On-site; USD 47,000 - 52,000; Full time

Benefits offered by this job

Competitive medical, dental, vision

Health Savings Account

Dependent Care FSA

Company 401k with company match

Paid time off, sick time, and holidays

Employee Assistance Program (EAP)

Job summary

Brooksource is seeking a Data Analyst II to develop Power BI dashboards and trusted reporting solutions across portfolio, financial, resource, demand, and project management initiatives. You will translate business needs into executive-ready dashboards and reports, supporting modernization efforts and AI-enabled automation where applicable.

The role emphasizes data modeling, DAX, and performance optimization, with strong SQL and Snowflake experience to validate data and analyze relationships.

Qualifications

• 2+ years of relevant data analytics or business intelligence experience.
• Bachelor's degree required.
• Advanced hands-on Power BI experience including data modeling, DAX, dashboard/report development, and performance optimization.
• Strong SQL experience and experience with Snowflake or a comparable cloud data warehouse.
• Experience validating data, troubleshooting reporting issues, and working with enterprise reporting datasets.
• Ability to gather requirements, define KPIs, and develop reporting solutions that support business decisions.
• Strong communication skills with ability to work with technical teams and leadership.
• Healthcare industry experience is a plus, but not required.

Responsibilities

• Develop, enhance, and optimize Power BI dashboards and enterprise reporting solutions.
• Build and maintain data models, DAX logic, and reporting datasets.
• Use SQL and Snowflake to validate data, troubleshoot discrepancies, and analyze data relationships.
• Partner with business stakeholders and project managers to gather requirements and define KPIs.
• Translate business needs into executive-ready dashboards and reports.
• Support reporting modernization, Snowflake migration, certified dataset development, and reporting governance.
• Contribute to strategic analytics initiatives, including AI-enabled automation where applicable.
• Adapt to shifting priorities based on project and business needs.

Skills

Power BI development

Data modeling

DAX

Reporting & dashboards

SQL

Communication

Education

Bachelor's degree

Tools

Snowflake

Power BI

Job description

Job Type: Long term contract (12-24 months with possibility of conversion)

Job Pay: 34-38 hourly

About the Role

We are seeking a Data Analyst II to support enterprise reporting and analytics across portfolio, financial, resource, demand, and project management initiatives. This role will focus on developing Power BI dashboards and trusted reporting solutions for stakeholders ranging from project managers to executive leadership. The ideal candidate will combine strong Power BI development, SQL/data analysis, and business intelligence experience with the ability to translate business requirements into clear, executive-ready reporting. The team is currently focused on reporting modernization, Snowflake migration, certified dataset development, Power BI enhancements, reporting governance, and AI-enabled automation.

What You'll Do

• Develop, enhance, and optimize Power BI dashboards and enterprise reporting solutions.
• Build and maintain data models, DAX logic, and reporting datasets.
• Use SQL and Snowflake to validate data, troubleshoot discrepancies, and analyze data relationships.
• Partner with business stakeholders and project managers to gather requirements and define KPIs.
• Translate business needs into meaningful, executive-ready dashboards and reports.
• Support reporting modernization, Snowflake migration, certified dataset development, and reporting governance.
• Contribute to strategic analytics initiatives, including AI-enabled automation where applicable.
• Adapt to shifting priorities based on project and business needs.

What We’re Looking For

• 2+ years of relevant data analytics or business intelligence experience.
• Bachelor's degree required.
• Advanced hands-on experience with Power BI, including:
• Data modeling
• DAX
• Dashboard and report development
• Performance optimization
• Strong SQL experience and experience working with Snowflake or a comparable cloud data warehouse.
• Experience validating data, troubleshooting reporting issues, and working with enterprise reporting datasets.
• Ability to gather requirements, define KPIs, and develop reporting solutions that support business decisions.
• Strong communication skills with the ability to work with both technical teams and business stakeholders, including leadership.
• Experience with certified datasets, standardized metrics, reporting governance, or enterprise analytics environments is a plus.
• Healthcare industry experience is a plus, but not required.

EEO Statement

Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances.

Benefits & Perks

• Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs.
• We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays.
• We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.

Pay Disclaimer

The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.