BUSINESS ANALYST

The Helmsman Group LLC; Chicago (IL); Remote; USD 70,000 - 110,000; Full time

Job summary

The Helmsman Group LLC is seeking a Business Analyst – Data & BI to analyze business data, build dashboards, and translate requirements into data solutions. You will collaborate with stakeholders, data engineers, IT, and management to improve decision-making through reliable BI reports.

Responsibilities include gathering requirements, producing Power BI/Tableau dashboards, writing SQL, validating data, and supporting data models and data quality initiatives across the organization.

Qualifications

• Bachelor's degree and 2–5 years of experience in business analysis, data analysis, BI, or related field.
• Strong analytical and problem-solving skills.
• Working knowledge of SQL and relational databases.
• Experience with Power BI, Tableau, or similar BI platforms.
• Strong Excel skills with pivot tables, lookups, formulas, and data analysis.
• Experience gathering and documenting business requirements.
• Understanding of data analysis, reporting, KPIs, and BI concepts.
• Excellent written and verbal communication skills.
• Ability to translate business needs into clear data and reporting requirements.

Responsibilities

• Gather, analyze, and document business requirements for data, reporting, analytics, and BI initiatives.
• Work with stakeholders to understand objectives, performance challenges, reporting needs, and KPIs.
• Analyze data to identify trends, opportunities, and improvements.
• Develop and maintain BI reports, dashboards, and performance metrics.
• Create clear data visualizations using Power BI, Tableau, or similar tools.
• Write SQL queries to extract, validate, and analyze data from databases and sources.
• Translate business requirements into data requirements and reporting specifications.
• Define and document KPIs, metrics, calculations, and data definitions.
• Validate data and reconcile reports and dashboards.
• Collaborate with data engineers and IT to improve data availability and quality.
• Perform data profiling, quality analysis, and root-cause analysis for discrepancies.
• Support data models and reporting datasets.
• Analyze historical and current performance to provide insights to management.
• Develop ad-hoc reports and analyses for business decisions.
• Assist management in interpreting dashboards and results.
• Monitor performance against KPIs and targets.
• Identify opportunities to automate recurring reports and improve efficiency.
• Support data-driven process improvement and transformation initiatives.
• Participate in UAT for BI reports and data solutions.
• Document reporting processes, data sources, and business rules.

Skills

Data & BI

Business Analysis

Data Analysis

SQL

Power BI

Tableau

Dashboard Development

Data Visualization

Business Requirements

KPI Development

Data Quality & Validation

Data Modeling

Reporting & Analytics

Requirements Gathering

Root-Cause Analysis

Data Governance

Excel

Stakeholder Management

UAT Testing

Process Improvement

Agile / Scrum

Education

Bachelor's degree in Business Analytics, Business Administration, Information Systems, Data Analytics, Computer Science, Finance, Economics, or a related field

Tools

Power BI

Tableau

Excel

SQL

Azure DevOps

Job description

Job Title: Business Analyst

Job Type: (Remote)

Job Summary

The Business Analyst — Data & Business Intelligence is responsible for analyzing business data, developing actionable insights, supporting reporting and dashboard initiatives, and translating business requirements into data-driven solutions. This position works closely with business stakeholders, data analysts, data engineers, IT teams, and management to improve decision-making through accurate and meaningful business intelligence.

Key Responsibilities

• Gather, analyze, and document business requirements for data, reporting, analytics, and business intelligence initiatives.




• Work with stakeholders to understand business objectives, performance challenges, reporting needs, and key performance indicators (KPIs).




• Analyze business and operational data to identify trends, patterns, opportunities, and areas requiring improvement.




• Develop and maintain business intelligence reports, dashboards, and performance metrics.




• Create clear and actionable data visualizations using tools such as Power BI, Tableau, or similar platforms.




• Write SQL queries to extract, validate, and analyze data from databases and other data sources.




• Translate business requirements into data requirements, reporting specifications, and analytical solutions.




• Define and document KPIs, business metrics, calculations, and data definitions.




• Perform data validation and reconciliation to ensure the accuracy and consistency of reports and dashboards.




• Collaborate with data engineers and IT teams to identify data sources and improve data availability and quality.




• Conduct data profiling, data quality analysis, and root-cause analysis when reporting discrepancies occur.




• Support the development and maintenance of data models and reporting datasets.




• Analyze historical and current business performance to identify trends and provide insights to management.




• Develop ad-hoc reports and analyses to support business decisions.




• Assist management in interpreting dashboards, reports, and analytical results.




• Monitor business performance against established KPIs, targets, and objectives.




• Identify opportunities to automate recurring reports and improve reporting efficiency.




• Support data-driven process improvement and business transformation initiatives.




• Participate in user acceptance testing (UAT) for BI reports, dashboards, and data solutions.




• Document reporting processes, data sources, business rules, calculations, and requirements.




• Ensure business intelligence solutions align with data governance, security, and organizational standards.




• Present analytical findings and recommendations to business stakeholders and management.

Qualifications

• Bachelor's degree in Business Analytics, Business Administration, Information Systems, Data Analytics, Computer Science, Finance, Economics, or a related field.




• 2–5 years of experience in business analysis, data analysis, business intelligence, or a related field.




• Strong analytical and problem-solving skills.




• Working knowledge of SQL and relational databases.




• Experience with Power BI, Tableau, or another business intelligence platform.




• Strong Microsoft Excel skills, including pivot tables, lookups, formulas, and data analysis.




• Experience gathering and documenting business requirements.




• Understanding of data analysis, reporting, KPIs, and business intelligence concepts.




• Excellent written and verbal communication skills.




• Ability to translate business needs into clear data and reporting requirements.

Preferred Qualifications

• Experience with data warehouses, data lakes, and ETL/ELT processes.




• Knowledge of data modeling and dimensional modeling concepts.




• Experience with cloud data platforms such as Snowflake, Azure, AWS, or Google Cloud.




• Experience with Agile/Scrum development environments.




• Knowledge of business process analysis and process improvement.




• Experience with Jira, Confluence, Azure DevOps, or similar tools.




• Experience with Python or R for data analysis.




• Knowledge of data governance, data quality, and master data management.




• Experience supporting enterprise reporting or BI implementations.

Key Skills

• Data & Business Intelligence




• Business Analysis




• Data Analysis




• SQL




• Power BI / Tableau




• Dashboard Development




• Data Visualization




• Business Requirements




• KPI Development




• Data Quality & Validation




• Data Modeling




• Reporting & Analytics




• Requirements Gathering




• Root-Cause Analysis




• Data Governance




• Excel




• Stakeholder Management




• UAT Testing




• Process Improvement




• Agile / Scrum

Core Competencies

• Data Analysis: Ability to analyze business data and convert information into meaningful insights.




• Business Intelligence: Ability to develop and support reports, dashboards, KPIs, and analytical solutions.




• Requirements Analysis: Ability to understand business needs and translate them into clear data and reporting requirements.




• Data Quality: Ability to identify inconsistencies and validate data to ensure accurate reporting.




• Business Communication: Ability to explain analytical findings and technical concepts to non-technical stakeholders.




• Problem Solving: Ability to investigate data and business issues and develop practical solutions.




• Stakeholder Management: Ability to work effectively with business users, technical teams, and management.




• Analytical Thinking: Ability to identify trends, relationships, and opportunities through quantitative analysis.