DATA ANALYST

The Helmsman Group LLC; Maryland; Remote; USD 75,000 - 110,000; Full time

Job summary

The Helmsman Group LLC is seeking a Data Analyst focused on Business Intelligence to transform complex data into actionable insights. Responsibilities include building dashboards, KPIs, and reports, and partnering with stakeholders to identify opportunities and risks.

The role emphasizes collaboration with data engineers and IT to improve data pipelines and data quality. The ideal candidate will have strong SQL skills, experience with Power BI/Tableau, and a proven track record in data

Qualifications

• Bachelor’s degree in data analytics, BI, statistics, CS, information systems, or related field.
• 2–5 years of experience in data analytics, BI, reporting, or related role.
• Strong SQL skills and experience with relational databases.
• Experience with Power BI, Tableau, Looker, or similar BI platforms.
• Advanced Microsoft Excel skills.
• Strong data analysis, visualization, and KPI development skills.
• Experience with data cleaning, transformation, validation, and reporting.
• Excellent communication and presentation skills.

Responsibilities

• Collect, analyze, and interpret data from multiple systems.
• Translate business requirements into data analysis and BI solutions.
• Develop and maintain dashboards, reports, and visualizations.
• Design and monitor KPIs and performance metrics.
• Write SQL queries to extract and analyze data.
• Perform data cleansing, transformation, validation, and quality checks.
• Combine data from multiple sources to create analytical datasets.
• Analyze business performance and identify trends and opportunities.
• Develop recurring and ad hoc reports for users and management.
• Automate manual reporting and data processes where possible.
• Collaborate with stakeholders to define analytical requirements.
• Improve data pipelines, models, and data availability with IT teams.
• Maintain data definitions, rules, and reporting documentation.

Skills

SQL

Power BI

Tableau

Data Visualization

KPI Development

Data Modeling

Data Warehousing

Excel

Education

Bachelor's degree in Data Analytics or related field

Tools

Power BI

Tableau

Looker

Qlik

Snowflake

Databricks

BigQuery

Azure Synapse

Python

R

Job description

Job Title: Data Analyst

Job Type: (Remote)

Job Summary

The Data Analyst — Business Intelligence is responsible for transforming business data into meaningful insights, reports, dashboards, and actionable information that support organizational decision-making. This position analyzes data from multiple sources, develops business intelligence solutions, monitors key performance indicators (KPIs), and partners with business stakeholders to identify trends, opportunities, risks, and areas for improvement.

Key Responsibilities

• Collect, analyze, and interpret data from multiple business and operational systems.
• Translate business requirements into data analysis, reporting, and business intelligence solutions.
• Develop and maintain interactive dashboards, reports, scorecards, and data visualizations.
• Design and monitor KPIs and performance metrics aligned with business objectives.
• Write SQL queries to extract, transform, validate, and analyze data from databases.
• Perform data cleansing, transformation, validation, and quality checks.
• Combine data from multiple sources to create reliable analytical datasets.
• Analyze business performance, operational trends, customer behavior, financial results, and other key business metrics.
• Identify trends, patterns, anomalies, and opportunities through quantitative analysis.
• Develop recurring and ad hoc reports for business users and management.
• Automate manual reporting and data processes where possible.
• Partner with business stakeholders to understand reporting needs and define analytical requirements.
• Work with data engineers and IT teams to improve data pipelines, data models, and data availability.
• Maintain data definitions, business rules, calculation methodologies, and reporting documentation.
• Ensure dashboards and reports provide consistent, accurate, and timely information.
• Conduct root-cause analysis to identify drivers behind business performance changes.
• Perform variance analysis against budgets, forecasts, targets, historical performance, or benchmarks.
• Support forecasting, trend analysis, and scenario analysis when required.
• Present analytical findings and business insights to technical and non-technical stakeholders.
• Develop executive-level reporting and visualizations that communicate complex information clearly.
• Monitor data quality and investigate inconsistencies, missing information, and data integrity issues.
• Support data governance, security, privacy, and access-control requirements.
• Assist with the development and maintenance of data warehouses, semantic models, and analytical datasets.
• Support business intelligence projects, system implementations, and reporting enhancements.
• Train business users on dashboards, reports, and self-service analytics tools.
• Identify opportunities to improve reporting efficiency, data accessibility, and decision-making.
• Stay current with business intelligence technologies, analytics techniques, and industry best practices.

Qualifications

• Bachelor's degree in Data Analytics, Business Intelligence, Statistics, Computer Science, Information Systems, Business Administration, or a related field.
• 2-5 years of experience in data analytics, business intelligence, reporting, or a related analytical role.
• Strong SQL skills and experience working with relational databases.
• Experience with Power BI, Tableau, Looker, or similar business intelligence platforms.
• Advanced Microsoft Excel skills.
• Strong understanding of data analysis, data visualization, and KPI development.
• Experience with data cleaning, transformation, validation, and reporting.
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills.
• Ability to translate business questions into analytical requirements and actionable insights.

Preferred Qualifications

• Experience with Power BI, including DAX and Power Query.
• Experience with Tableau, Looker, Qlik, or similar BI platforms.
• Knowledge of data warehousing, ETL/ELT processes, and dimensional data modeling.
• Experience with cloud data platforms such as Snowflake, Databricks, BigQuery, or Azure Synapse.
• Working knowledge of Python or R for data analysis.
• Experience with financial, sales, customer, operational, or supply-chain analytics.
• Knowledge of data governance, data quality, and master data management.
• Experience developing executive dashboards and management reporting.
• Experience with Agile methodologies and BI development projects.
• Microsoft Power BI or other relevant BI certification is a plus.

Key Skills

• Business Intelligence
• Data Analytics
• SQL
• Power BI
• Tableau
• Data Visualization
• Dashboard Development
• KPI Development
• Reporting & Analytics
• Data Modeling
• Data Warehousing
• ETL / ELT
• Data Quality
• Data Validation
• Trend Analysis
• Variance Analysis
• Root-Cause Analysis
• Forecasting
• Microsoft Excel
• Python / R
• Business Requirements Analysis
• Stakeholder Management
• Executive Reporting

Core Competencies

• Business Intelligence: Ability to transform business data into dashboards, reports, and insights that support informed decision-making.
• Analytical Thinking: Ability to identify meaningful trends, relationships, anomalies, and performance drivers within complex datasets.
• Data Visualization: Ability to communicate complex information through clear, effective, and user-friendly dashboards and visualizations.
• Business Understanding: Ability to understand business objectives and connect analytical findings to operational and strategic priorities.
• Data Quality: Ability to validate data accuracy, completeness, consistency, and reliability.
• Problem Solving: Ability to investigate business performance issues and identify the underlying drivers using data.
• Communication: Ability to explain analytical findings and recommendations clearly to technical and non-technical stakeholders.
• Stakeholder Management: Ability to work effectively with business leaders, managers, IT teams, data engineers, and other stakeholders.
• Continuous Improvement: Ability to identify opportunities to automate reporting, improve data accessibility, and enhance analytical processes.