Data Scientist: Power BI & Automation

Stefanini North America and APAC; New York (NY); On-site; USD 100,000 - 140,000; Full time

Job summary

Stefanini Group in New York City is seeking a Data Scientist to collect, analyze, and interpret complex data to support business decisions. You will focus on reporting, dashboard development, and automation to deliver actionable insights.

You will build Power BI models, leverage Excel, and translate business requirements into analytical solutions, presenting findings clearly to stakeholders and collaborating with cross-functional teams.

Qualifications

• Bachelor's degree in Data Science, Statistics, Mathematics, Computer Science, Business Analytics, or a related field.
• Experience in data analysis, reporting, business intelligence, or a related role.
• Strong knowledge of Microsoft Power BI, including dashboard creation, data modeling, Power Query, and DAX.
• Advanced proficiency in Microsoft Excel, including pivot tables, lookup functions, conditional formulas, charts, and data validation.
• Experience developing recurring and ad hoc reports for business stakeholders.
• Demonstrated ability to automate repetitive reporting and data-processing tasks.
• Strong analytical, problem-solving, and attention-to-detail skills.
• Ability to communicate technical findings to non-technical audiences.

Responsibilities

• Collect, clean, validate, and analyze data from multiple sources.
• Develop and maintain recurring business and management reports.
• Design interactive dashboards and visualizations using MS Power BI.
• Build data models, measures, calculated columns, and reports in Power BI.
• Use MS Excel for data analysis, reporting, reconciliations, pivot tables, formulas, and ad hoc analysis.
• Identify opportunities to automate manual reporting and data processes.
• Develop automated workflows, templates, and reporting solutions to improve efficiency and accuracy.
• Monitor data quality and investigate discrepancies or unusual trends.
• Translate business requirements into analytical solutions and meaningful insights.
• Present findings to stakeholders in a clear and understandable manner.
• Collaborate with business, technology, and operations teams to support data-driven initiatives.
• Document reporting processes, dashboard definitions, and automation procedures.

Skills

Data analysis

Reporting

BI dashboards

Automation

Attention to detail

Communication

Education

Bachelor's degree in data science or related field

Tools

Power BI

Excel

Power Query

DAX

SQL

Python

Job description

Stefanini Group in New York City is seeking a Data Scientist to collect, analyze, and interpret complex data to support business decisions. You will focus on reporting, dashboard development, and automation to deliver actionable insights.

You will build Power BI models, leverage Excel, and translate business requirements into analytical solutions, presenting findings clearly to stakeholders and collaborating with cross-functional teams.