BUSINESS DATA ANALYST JOB DESCRIPTION

Explore real-world Business Data Analyst job descriptions featuring responsibilities, qualifications, and specializations across multiple sectors.

Business Data Analyst Job Description Template

1. About the Role

Raw data doesn't drive decisions; interpreted, structured, and accountable data does. The Business Data Analyst translates operational and commercial data sets into reporting frameworks and visualizations that give stakeholders a reliable view of business performance. Working across functions such as Sales, Finance, and Product, this role governs the integrity of what gets measured, how dashboards are built, and whether KPI definitions hold up under executive scrutiny. Governance disciplines like data quality validation and requirements documentation separate this work from general analysis.

2. Position Summary

As the Business Data Analyst, you convert complex, multi-source data into structured reports, dashboards, and decision-ready insights that inform operational and commercial strategy across the organization. You collaborate with business unit leads, BI engineers, and functional stakeholders, translating their requirements into scalable analytics solutions that serve both day-to-day operations and executive-level reporting.

3. Why Join Us

Career Impact: Owning the requirements-to-dashboard pipeline in an enterprise environment builds cross-functional credibility and positions analysts for advancement into senior BI or data strategy roles.

Business Impact: The dashboards and KPI frameworks you design directly shape how Sales, Finance, and Operations leaders allocate resources and identify underperformance before it compounds.

Growth Opportunity: Hands-on exposure to data modeling, SQL optimization, and visualization governance expands your market value and opens paths toward Data Engineering or Analytics Engineering roles.

4. Key Responsibilities

  • Gather and translate business requirements from stakeholders across Sales, Finance, and Operations into documented functional and technical specifications.
  • Design and maintain dashboards, KPI scorecards, and ad hoc reports that provide actionable visibility into operational and commercial performance.
  • Develop and optimize SQL queries to extract, transform, and validate data across relational databases and enterprise data warehouses.
  • Audit data quality across reporting pipelines, identifying duplicate records, missing values, and schema inconsistencies that would distort analysis.
  • Partner with BI engineers and IT teams to ensure reporting infrastructure is scalable, documented, and aligned with evolving business requirements.
  • Conduct exploratory data analysis and competitive or trend-based forecasting to surface root causes of performance gaps and growth opportunities.
  • Build and maintain data documentation including data dictionaries, process flows, and requirements backlogs to support governance and onboarding.
  • Communicate analytical findings and recommendations to both technical and non-technical audiences through structured presentations and written reports.

5. Required Qualifications

  • Bachelor's degree in Business Analytics, Statistics, Computer Science, or a related quantitative field, or equivalent work experience.
  • 4 or more years of data or business analytics experience, with demonstrated ability to translate stakeholder requirements into reporting solutions.
  • Advanced SQL proficiency, including writing complex queries against multi-table relational databases and enterprise data warehouses.
  • Demonstrated experience designing and publishing dashboards and reports using data visualization platforms.
  • Ability to perform data quality audits including validation, reconciliation, and root-cause analysis of reporting discrepancies.
  • Strong written and verbal communication skills with the ability to present quantitative findings clearly to non-technical stakeholders.
  • Experience managing multiple analytics projects simultaneously, including requirements prioritization and timeline coordination with cross-functional partners.
  • Familiarity with agile or iterative project frameworks, including requirements backlog management and sprint-based delivery.

6. Preferred Qualifications

  • Experience with statistical modeling or forecasting methods, including customer lifetime value modeling or ROI analysis.
  • Exposure to data governance practices, including metadata management, data dictionaries, or enterprise data catalog tools.
  • Background in one or more enterprise business domains such as supply chain, financial planning, or commercial operations.
  • Experience mentoring junior analysts or facilitating requirements workshops with mixed technical and business audiences.

7. Success Metrics & Environment

  • Requirements-to-delivery cycle time, measuring how quickly validated stakeholder requests reach production reporting.
  • Dashboard adoption rate among business unit stakeholders, indicating whether reporting solutions are used or abandoned.
  • Data quality defect rate per reporting cycle, reflecting the accuracy of upstream validation and cleansing work.
  • Percentage of ad hoc requests converted to self-service reports, reducing recurring analyst workload over time.
  • Stakeholder requirements sign-off rate on first submission, measuring how precisely requirements are captured and documented.
  • Typical tools: SQL environments (commonly PostgreSQL or MS SQL Server); BI and visualization platforms (commonly Power BI or Tableau).

8. Compensation & Benefits (US Market Benchmark)

  • Base Salary Range: $75,000 to $105,000 annually, depending on experience and location
  • Bonus: Annual performance bonus of 5 to 10% of base salary
  • Equity: Uncommon at this level; occasionally offered at growth-stage companies
  • Health Benefits: Medical, dental, and vision coverage; employer contributes to premium costs
  • PTO: 15 to 20 days per year, plus federal holidays
  • Common Perks: Remote or hybrid schedule options, learning and development stipend, access to analytics tooling and certifications


Figures are estimates based on general US market benchmarks and may be outdated. Adjust based on location, company size, and seniority level.

9. EEO & Legal

Work authorization in the United States is required; candidates must be eligible to work without employer sponsorship unless otherwise stated. Employment is contingent on successful completion of a background screening appropriate to the role and access level. All qualified applicants will be considered for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other characteristic protected under applicable federal, state, or local law. Reasonable accommodations are available to individuals with disabilities throughout the application and employment process upon request.

Business Data Analyst Job Description Examples

1. Business Data Analyst (Systems & SQL Analytics)

The Business Data Analyst owns the translation of business requirements into architecture diagrams, process flows, and functional specifications, serving as the main point of contact between IT and operational departments. Delivering high-quality, on-schedule products, this role supports software engineers and cross-functional partners to improve application systems functionality and data-driven efficiency across manufacturing quality objectives.


Key Responsibilities

  • Gather and evaluate business requirements and translate to architecture diagrams, process flows, system design, and functional specifications.
  • Ensure on-schedule delivery of a high-quality product that meets business and technical requirements.
  • Participate in design, code, and test case review sessions to ensure the quality of work delivered by teammates meets development standards.
  • Provide technical expertise and recommendations in assessing new IT software projects to support and improve efficiency of business processes.
  • Investigate and resolve application functionality-related issues and assist with troubleshooting.
  • Work with data analysts on MFG quality analytical objectives and serve as main point of contact between IT and other departments.
  • Prioritize efforts and delegate activities appropriately, using analytical experience to consult end users on improving application systems functionality.


Required Qualifications

  • Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent work experience.
  • 6 or more years of related experience as a Developer and/or Systems Analyst, with 2 or more years translating business requirements in long-term roles.
  • Strong understanding of database design, development, and SQL querying skills.
  • Familiarity with standard Change Management procedures, with Jira experience preferred.
  • Proficient in SQL Server 2012 or greater, including SSIS, SSRS, and SSMS.
  • Excellent data analysis, technical analysis, and problem-solving skills with proven troubleshooting ability in varied technical environments.
  • Strong interpersonal skills with the ability to negotiate priorities and resolve conflicts among project partners.
  • Capable of multitasking in a fast-paced environment.

2. Business Data Analyst (Commercial Analytics)

Embedded within the commercial analytics function, the Business Data Analyst delivers a data-driven view of the customer journey by building and maintaining data models that span sales, marketing, and customer success functions. Working closely with infrastructure, engineering, and cross-functional teams, this role expands data infrastructure and generates business insights that improve customer-facing operations across all business segments.


Core Functions

  • Engage with cross-functional teams to understand departmental requirements and scope and prioritize them into analytics programs and projects.
  • Build and maintain data models to support commercial analytics.
  • Create analytics views based on disparate data sets across sales, marketing, and customer success functions.
  • Build partnerships with infrastructure and engineering teams to drive best practices and expand data infrastructure.
  • Manage and maintain reporting across commercial teams to generate business insights and actionable next steps.


Qualifications & Experience

  • 3 or more years of advanced analytics experience, preferably in a commercial or customer-facing environment.
  • Ability to develop and modify complex SQL queries and design, implement, and optimize data models based on business and performance requirements.
  • Knowledge of database design concepts and experience with large-scale data extraction using SQL, Python, and R.
  • Proficient in analytics and data infrastructure tools such as Looker, Segment, and Snowflake.
  • Advanced problem-solving skills with a collaborative mindset and proven track record of engaging multiple stakeholders across business areas.

3. Business Data Analyst (Data Governance & Reporting)

Reporting to the Data Governance Lead, the Business Data Analyst shapes the organization's data landscape by querying the Customer Information System and corresponding data warehouse to build dashboards and automated reports. Partnering with stakeholders across business units, this role translates requirements into data solutions that improve reporting quality and long-term efficiency.


Primary Duties

  • Take direction from the Data Governance Lead on long-term tasks and initiatives related to data governance and data dictionaries.
  • Query and extract data from the Customer Information System and corresponding data warehouse as needed.
  • Understand and document the data landscape currently existing within the data warehouse.
  • Build dashboards to provide visual representations of customer data.
  • Provide QA support to ensure data quality across reporting outputs.
  • Create automated reports to improve efficiency over time.
  • Work closely with stakeholders to gather and translate requirements into data solutions.


Skills & Qualifications

  • 4 or more years of relevant experience in a data or business analytics role.
  • Demonstrated techno-functional experience, including stakeholder interviews, requirements gathering, and translation into data tasks.
  • Proficient in SQL Server with the ability to develop scripts from scratch against large enterprise data sets.
  • Experienced with data visualization platforms, with Power BI strongly preferred.
  • Experience working with large enterprise data sets at scale, including multi-hundred-gigabyte databases with millions of rows.

4. Business Data Analyst (Product & Statistical Analysis)

Sitting at the intersection of business strategy and technical analysis, the Business Data Analyst functions as the main liaison between the Product Development Team and business users, designing workflows, charts, and statistical models to support strategic decision-making. Operating across data collection, requirements definition, and quality assurance, this role compiles findings into reports that help leadership increase efficiency and client experience.


Duties

  • Understand business needs, write requirement documents, and design mock-ups.
  • Meet with users, collect requirements, write specifications, design wireframes, and transmit information to programmers.
  • Communicate findings and updates to business stakeholders and leaders.
  • Write test cases, implement quality assurance processes, and design sprints.
  • Design processes and tools to make data more accurate and accessible.
  • Interpret data, analyze results using statistical techniques, and provide ongoing reports.


Requirements

  • Degree in Computer Science, Software Engineering, or a related field.
  • 1 or more years of experience with reporting packages, databases such as SQL, and programming frameworks, including XML, JavaScript, or ETL.
  • Strong quantitative and analytical skills.
  • Highly motivated with the ability to make judgemental decisions.
  • Fluent in English with strong written and verbal communication skills.

5. Business Data Analyst (Ventures & Impact Analytics)

A key member of the business intelligence function, the Business Data Analyst leads monitoring, forecasting, and visualization efforts across a portfolio of ventures and subsidiaries, collaborating directly with business units and portfolio CEOs to implement data-driven decision-making. Collaborating across financial, operational, and impact-related activities, this role delivers top-quality transparency to the investor base and supports cultural change toward data-centric ways of working.


Functions

  • Collaborate with business units and portfolio CEOs to understand needs and implement monitoring measures and data-driven decision-making.
  • Create and maintain visualization tools for internal and external use and help upskill team members on data and insight access.
  • Support financial administration including long-term modelling, budgeting, and valuation of ventures.
  • Ensure top-quality business intelligence and transparency to the investor base across financial, operational, and impact data.
  • Maintain data quality and work with IT to implement preventative measures for long-term improvement.


Experience & Qualifications

  • Experience in management consulting, strategy consulting, transaction services, or comparable data analytics roles with a track record of driving operational improvements.
  • Experience in healthtech, sustainable innovation, or Retail/Foodservice/FMCG is a plus.
  • Advanced proficiency in Excel and PowerPoint, with G Suite knowledge as a plus.
  • Strong quantitative profile with excellent communication skills, commercial judgment, and the ability to manage multiple projects simultaneously.
  • Able to work in a matrix organization across countries, influence stakeholders, and drive cultural change toward data-centric ways of working.

6. Business Data Analyst (Web & Customer Experience Analytics)

Clear visibility into the value of new initiatives depends on the Business Data Analyst, who synthesizes multiple data types, defines and standardizes metrics and dashboards, and champions data-driven decision-making across the team and organization. Based within the analytics function, this role serves as a thought partner to product strategists on hypothesis formulation, experimentation plans, and ad-hoc analytic questions for both internal and external stakeholders.


Accountabilities

  • Build recommendations by synthesizing multiple data types and using external sources to drive business learnings and strategy development.
  • Serve as a thought partner to product strategists, providing recommendations on hypothesis formulation, experimentation plans, and impact estimates.
  • Define, implement, and standardize metrics, reports, and dashboards for internal and external stakeholders.
  • Answer ad-hoc analytic questions and train users to self-serve standard reports.
  • Pursue data quality, troubleshoot data validation issues, and see problems through to resolution.
  • Optimize data collection and processing to provide clear visibility into the value of new initiatives and product releases.
  • Champion data-driven decision-making across the team and throughout the organization.


Technical Qualifications

  • 3 or more years of experience in web analytics or customer experience analytics.
  • Experience working with granular clickstream data or other behavior tracking tools.
  • Strong SQL proficiency and experience with data visualization platforms.
  • Ability to tell stories with data and motivate stakeholders to act on recommendations.
  • Excellent problem-solving, quantitative thinking, and project management skills.
  • Outstanding written and verbal communication for both technical and non-technical audiences.

7. Business Data Analyst (Healthcare Database Analytics)

As the Business Data Analyst, this role serves as the liaison between departmental analytical needs and technical data storage systems within a healthcare setting, analyzing and maintaining databases and software to support KPI evaluation, quality metrics, and population management studies. The analytics team relies on this work to identify and resolve data quality issues, apply visualization principles, and deliver findings that enable evidence-based operational decisions.


Activities

  • Identify strategies for evaluating KPIs, quality metrics, outcomes, and population management studies.
  • Develop technical and functional specifications based on business requirements and workflow analysis.
  • Manage all database processing functions including merge/purge, data hygiene, and data appends.
  • Identify and resolve data quality issues such as duplicate records and missing data that would impact reporting.
  • Apply data visualization and presentation principles to communicate project findings effectively to management.
  • Maintain and track various measures to maximize database capabilities.
  • Serve as liaison between departmental analytical needs and business partners.


Position Requirements

  • Progressive experience working with databases, reporting applications, and business intelligence platforms.
  • Demonstrated knowledge of hospital medical records, data abstraction, and healthcare analytics concepts.
  • Knowledge of logical and physical components of information storage infrastructure.
  • Expertise in EPIC (Clarity/Caboodle).
  • Experience with database tools including SQL, Excel PivotTables, and MS SQL Server.
  • Advanced experience with Microsoft Office and data extraction languages such as SAS, Tableau, and R.

8. Business Data Analyst (Financial Data & BI Reporting)

Business Data Analyst produces accessible, decision-ready analytical outputs for business controllers, management partners, and other stakeholders across a large financial organization, querying and processing billions of data records using database and business intelligence tools. Success in the position means building expert knowledge of the organization's financial data landscape while maintaining close stakeholder relationships that enable timely, on-the-spot analytical support.


Operational Focus

  • Deliver relevant data and analytical outputs to experts and managers across the organization.
  • Work closely with business controllers and management partners to understand priorities and translate them into data deliveries.
  • Query and process data using database and business intelligence tools.
  • Build expert knowledge of the organization's financial data landscape used for reporting and performance management.
  • Maintain close personal relationships with stakeholders to provide timely, on-the-spot analytical support.


Knowledge, Skills & Abilities

  • Several years of experience with database query tools such as SAS, Teradata, or SQL.
  • Proficient in business intelligence and reporting tools, with QlikView experience preferred.
  • Fluent in English at a professional level.
  • Self-driven with the ability to independently manage stakeholder relationships and prioritize tasks.
  • Outgoing and comfortable challenging peers, managers, and stakeholders with data-backed findings.

9. Business Data Analyst (Data Onboarding & Governance)

The Business Data Analyst produces well-structured documentation, reference data, and data management workflows to support onboarding activities across multiple teams and business units, proactively engaging with stakeholders, data owners, and technical teams. Delivering a current and prioritized data management backlog, this role enables the organization's data maturity to progress through coordinated requirements gathering and agile project support.


Key Deliverables

  • Map out and streamline processes for data onboarding.
  • Develop and maintain documentation of data requirements, workflows, processes, and applications.
  • Organize and drive requirements gathering for assigned projects.
  • Ensure the data management backlog is current, including identifying dependencies and priorities.
  • Create and update reference data, schemas, descriptors, entitlements, and other data entities to support onboarding activities.


Professional Experience

  • Experience using SQL and NoSQL to query databases, with the ability to understand and write XML documents.
  • Previous experience working in an agile environment with the ability to facilitate workshops and sprint meetings.
  • Numerate with advanced Excel skills.
  • Experience with data modeling, ETL, and API consumption.
  • Familiarity with tools such as Jira, Python, Tableau, Alteryx, and automated data collection systems.
  • Strong research, requirements gathering, and planning skills.

10. Business Data Analyst (Mobile Gaming Analytics)

Embedded within the Product team, the Business Data Analyst develops and maintains reports, dashboards, and metrics to monitor product performance across features, game economies, and live operations, translating large and complex user behavior data sets into product recommendations. Working closely with product stakeholders, this role devises A/B tests, balances flows across features, and shapes future roadmaps through actionable, data-driven conclusions.


Areas of Ownership

  • Analyze large, complex data sets representing user behavior and translate findings into business decisions and product recommendations.
  • Provide actionable conclusions from product data to shape features, game economies, and future roadmaps.
  • Devise and analyze A/B tests to improve content performance.
  • Balance and monitor flows across product features and measure performance of promotions and live operations by segment.
  • Build and maintain reports, dashboards, and metrics to monitor product performance in collaboration with the Product team.


Background & Experience

  • Bachelor's degree in Industrial Engineering, Economics, Statistics, or equivalent academic background.
  • 2 or more years of analytical work experience, preferably in a web, mobile, or online gaming environment.
  • Prior product analyst experience is an advantage.
  • Strong SQL skills with experience querying large, complex data sets.
  • Expert in data analysis and visualization using Excel, Tableau, or similar tools with the ability to turn complex concepts into actionable recommendations.
  • Strong Excel skills and outstanding analytical and technical problem-solving abilities.

11. Business Data Analyst (Forecasting & Predictive Modeling)

Reporting to business leadership, the Business Data Analyst refines competitive analysis, forecasting, and predictive modeling by building user-friendly reports, graphics, and a data catalog that serve both internal and external stakeholders. Partnering with cross-functional teams across planning and deployment, this role supports data-driven growth by conducting statistical analyses, data validation, and data mapping to identify trends and areas for improvement.


Role Responsibilities

  • Run competitive analysis and forecasting and make recommendations to increase sales orders and revenue.
  • Analyze data across business and functional areas to identify trends, patterns, and areas for growth or improvement.
  • Create reports and tools to simplify forecasting and predictive modeling.
  • Develop user-friendly reports and graphics that convey complex data and maintain a data catalog for internal and external stakeholders.
  • Aggregate and prepare data to test hypotheses using technical experience and sound judgment.
  • Conduct data validation, statistical analyses, and data mapping.
  • Assist in defining, developing, and deploying data, analytics, and reporting products and services.


Education & Experience

  • University degree in Business Administration or a related field, plus generally 5 years of related experience.
  • Strong ability to develop and implement efficient analytical solutions and manage programs from planning through execution.
  • Proficient in Microsoft Excel, Power BI, SQL, Python, and R.
  • Catalytic experience is a plus.
  • Demonstrated success in database and data management with strong troubleshooting skills.
  • Strong written and oral communication skills, with competency in presentation software and the ability to network across teams.

12. Business Data Analyst (Data Mining & Reporting)

A key member of the analytics team, the Business Data Analyst oversees exploratory data analysis, data cleansing, and visualization across multiple internal databases to identify root causes of trends, issues, and performance gaps. Collaborating across internal partner teams, this role develops scalable, automated processes for large-scale analysis and communicates business implications and actionable recommendations to key stakeholders.


Job Functions

  • Develop reports and presentations documenting analyses and communicate business implications to key stakeholders.
  • Identify, investigate, and document root causes of trends, issues, and performance gaps to determine improvements and recommendations.
  • Perform exploratory data analysis, data cleansing, and data visualization using data mining tools.
  • Collaborate with internal partners to document data and reporting needs and implement reporting using data from multiple internal databases.
  • Assist with developing scalable, efficient, and automated processes for large-scale data analysis and model development.


Qualifications & Experience

  • Bachelor's degree in a related field or equivalent work experience.
  • 4 or more years of relevant analytics experience.
  • Ability to manage multiple projects independently, take ownership of responsibilities, and consistently meet deadlines.
  • Strong analytical, problem-solving, and critical thinking skills with the ability to evaluate alternatives and present solutions aligned to business objectives.
  • Ability to communicate results and insights clearly to non-technical audiences through written, verbal, and visual formats.
  • Strong teamwork, collaboration, and process improvement skills with the ability to partner with senior team members and influence stakeholders to act on analytical insights.

13. Business Data Analyst (Process Analysis & Benchmarking)

Sitting at the intersection of organizational change and data-driven process improvement, the Business Data Analyst reviews databases and data schemas, facilitates cross-functional sessions, and makes data-based recommendations to benchmark and improve processes consistently across the organization. Operating across EY Technology teams, this role drives problem resolution, guides groups through complex decisions, and helps others weigh priorities when presented with new information.


What You'll Do

  • Review databases and data schemas and illustrate data process flows.
  • Analyze data and process changes, make data-based recommendations to improve processes, and review results of process improvements.
  • Facilitate sessions to guide groups through topics and promote active individual participation.
  • Drive problem resolution and compel teams to make key decisions.
  • Identify root causes of difficult problems, prioritize causes, and help others weigh priorities.
  • Assist in leading complex organizational change and reevaluate decisions when presented with new information.


Skills & Qualifications

  • Results-driven with solid attention to detail and the ability to complete large projects concurrently within agreed timescales.
  • Ability to develop a strong understanding of business drivers that determine success and tailor technical communication to varied audiences.
  • Skilled at gathering client feedback to produce credible, high-quality analytical solutions.
  • Ability to shift gears, make decisions, and act without requiring complete information.
  • Strong interpersonal skills with the ability to adapt to cultural differences and demonstrate executive presence, confidence, and credibility.

14. Business Data Analyst (Multi-Source Financial Analytics)

Actionable insight across Finance, Product, Sales, Operations, and IT depends on the Business Data Analyst, who masters internal and external data sources to design and manage reports, analyses, forecasts, and dashboards that translate abstract data into highly visual, comprehensible formats. Serving as the analytical resource for leadership and cross-functional teams, this role defends data-driven recommendations and develops multi-dimensional analyses that inform business decisions across the organization.


Day-to-Day Responsibilities

  • Guide quantitative and qualitative analysis and present findings to leadership.
  • Translate abstract data into highly visual and comprehensible formats for business use.
  • Design and manage reports, analyses, forecasts, and dashboards.
  • Master internal and external data sources to enable multi-dimensional analysis.
  • Develop relationships with Finance, Product, Sales, Operations, and IT teams across the organization.
  • Design, develop, and prepare regular and ad hoc reports, dashboards, and analytics, and defend actionable insights based on data-driven analysis.


Requirements

  • Bachelor's degree in Economics or a quantitative field, with an advanced or master's degree as a plus.
  • Solid analytical and communication skills with significant experience in spreadsheet and presentation applications.
  • Programming skills in SQL and Python for data manipulation, with experience in automation using Excel VBA macros.
  • Experience with data visualization tools such as Tableau and relational database or data warehousing systems such as Amazon Redshift, Oracle, or MySQL.
  • Strong initiative with the ability to manage multiple projects, excellent critical problem-solving skills, and a detail-oriented approach with a sense of personal accountability.

15. Business Data Analyst (Business Intelligence Systems)

As the Business Data Analyst, this role advances business intelligence systems by recognizing business problems, developing reporting solutions, and designing, analyzing, and helping build data pipelines for ingestion across relational, columnar, and NoSQL database technologies. The analytics function relies on this work to develop strategies for connecting to new data sources, optimize SQL queries, and deliver front-end visualizations that translate technical data into accessible business tools.


Scope of Work

  • Recognize business problems and develop reporting solutions to address them.
  • Work with business users to gather requirements, translate them into technical specifications, and build front-end visualizations.
  • Design, analyze, and help build data pipelines for data ingestion.
  • Develop, design, and optimize SQL queries.
  • Develop strategies for connecting to new data sources.


Technical Qualifications

  • 5 or more years of experience supporting business intelligence systems.
  • Experience with media data, including complex data preparation from ad servers, DSPs, and other sources.
  • Expert SQL skills with expertise in relational, columnar, and NoSQL database technologies such as MySQL, Oracle, MSSQL, Vertica, and MongoDB.
  • Strong understanding of data modeling including conceptual, logical, and physical model design, with experience handling large data sets.
  • Skilled in front-end dashboard and visualization development and user experience design.
  • Strong organizational and project management abilities with the ability to manage multiple client engagements independently.

16. Business Data Analyst (Financial Controls & Earned Value)

Business Data Analyst coordinates monthly and quarterly financial performance reporting, assembling project financials and preparing Balanced Scorecards that track progress against annual goals for executive management and client stakeholders. The work directly supports budget-versus-actual analysis, cost risk and trend assessments using earned value methodology, and forecasting procedures for cost adjustments and change order requests.


Work Activities

  • Assemble project financials each month, including budget, actual costs, and forecasts.
  • Prepare monthly and quarterly reports on financial performance including budget-versus-actual analysis and forecasts of all project costs.
  • Maintain financial databases and analyze data using earned value and cost-schedule analytic tools.
  • Provide financial performance reports to the client and recommend forecasting procedures for cost adjustments and change order requests.
  • Review monthly cost risk and trend assessments using earned value methodology.
  • Prepare Balanced Scorecards to track progress against annual goals and format dashboards for executive management.


Education & Experience

  • Bachelor's degree with major coursework in Finance or a related field.
  • Minimum 10 years of relevant accounting, budgeting, and financial controls experience in large organizations.
  • Working knowledge of accounting systems, financial control practices, and earned value methodology.
  • Understanding of accounting and financial industry practices.
  • Proficient in Microsoft Office, with working knowledge of database software, including Microsoft Access, Power BI, and MySQL.

17. Business Data Analyst (Transportation & Logistics Analytics)

The Business Data Analyst creates strategic approaches to carrier bids and transportation analysis by managing data gathering, developing customer presentations, and delivering scorecards and dashboards that identify cost-saving opportunities for customers. Serving customers, carriers, and internal employees, this role collaborates across data warehousing, reporting, and consulting support functions to recommend broad-based improvement initiatives and develop standard operating procedures.


Performance Expectations

  • Manage data gathering for customers' benchmark key performance metrics.
  • Create a strategic approach to carrier bids through lane, mode, and service balancing, including scorecard tracking and transportation dashboard development.
  • Determine the best mode, carrier, and service for the customer by providing analysis and metrics for transportation bids.
  • Analyze large amounts of data and recommend broad-based improvement initiatives for customers.
  • Develop customer presentations showing data trends and possible solutions, collaborating to identify the most effective and profitable outcomes.
  • Develop standard operating procedures based on direction from management.


Position Requirements

  • Bachelor's degree in Statistics, Engineering, Accounting, Finance, or a related field, or equivalent experience with 2 or more years of relevant work.
  • Experience or knowledge in transportation, logistics, parcel shipping, or freight pay preferred.
  • Proficient in Microsoft Office applications including Access and Excel, with SQL experience preferred.
  • Strong organizational skills with the ability to handle multiple tasks simultaneously and meet deadlines in a fast-paced environment.
  • Strong interpersonal and communication skills with the ability to work with internal and external customers.

18. Senior Business Data Analyst (BI & Forecasting)

Embedded within the BI and data analytics function, the Senior Business Data Analyst develops reports, analyses, and forecasting models for leadership and cross-functional partners by utilizing SQL across multiple databases and executing data modeling, cleansing, and master data management. Working closely with functional domain teams, this role produces actionable narratives from complex data and simplifies advanced analytical findings into clear recommendations that support product management and organizational decision-making.


Core Responsibilities

  • Utilize SQL to create and develop queries for data stored across multiple tables and databases.
  • Identify root causes of operational inefficiencies using data patterns and trends.
  • Collaborate with other functional domains to develop analytical solutions.
  • Interpret data, analyze results, and create narratives around insights derived from the data.
  • Manage master data including creation, updates, and deletion.
  • Develop reports and analysis for leadership and cross-functional partners.
  • Provide technical expertise in data storage structures, data mining, and data cleansing.


Required Qualifications

  • Bachelor's degree in Business Analytics, Information Technology, or a related field, with 5 or more years of experience in BI or data analytics roles.
  • Experience in forecasting, including modeling and forecasting ROI and customer lifetime value, as well as extracting user behavior patterns for product management.
  • Proficient in data modeling, SQL variants including Redshift, PostgreSQL, and MySQL, and BI tools such as Tableau and Looker.
  • Experience with statistical programming environments such as R, Python, SPSS, or MATLAB, and with querying structured and unstructured data using frameworks such as Spark or Impala.
  • Advanced expertise in MS Excel.
  • Strong written and verbal communication skills.
  • Ability to simplify complex problems into clear, actionable recommendations.

19. Business Data Analyst (Supply Data Governance)

Reporting to supply management leadership, the Business Data Analyst guides data management topics including governance, quality, operational reporting, data cleansing, and migration while championing data as a strategic asset within the Supply Department. Partnering with stakeholders across multiple countries and a matrix organization, this role spearheads cultural change toward data-centric continuous improvement and accelerates the development and implementation of data solutions.


Primary Duties

  • Own and manage data management topics within supply management, including processes, quality, governance, operational reporting, data cleansing, and data migration.
  • Offer effective data reporting, analysis, and insights by addressing current data limitations.
  • Champion data as a strategic asset and act as trustee of data management topics within the Supply Department.
  • Support the business in identifying and accelerating the development and implementation of data solutions.
  • Spearhead cultural change by instilling a data-centric culture of continuous improvement at country level.


Knowledge, Skills & Abilities

  • Master's degree in business, engineering, or a related field.
  • Experience in data management, governance, and processing with practical business impact.
  • Experience in supply management, Retail, Foodservice, or FMCG is a strong advantage.
  • Strong data modeling, data quality management, and project management skills with the ability to build and deliver a roadmap of initiatives.
  • Ability to work in a matrix organization across multiple countries, influence stakeholders, and drive cross-functional cultural change.
  • Team player with strong communication and influencing skills, commercial judgment, and learning agility.
  • Fluency in English plus French and/or Dutch.

20. Business Data Analyst (Regulatory & Compliance Reporting)

Sitting at the intersection of data analysis and regulatory compliance, the Business Data Analyst gathers, analyzes, and organizes information from multiple sources to produce accurate reports, summaries, and database-driven insights that support leadership and stakeholder decision-making. Operating across compliance, legal, and financial document review functions, this role maintains reporting schedules, manages follow-ups with leadership, and applies data modeling and statistical techniques to translate findings into actionable recommendations.


Scope of Work

  • Gather, analyze, and organize information from multiple sources while ensuring timeliness, completeness, and consistency.
  • Establish and maintain reporting schedules and case file tracking to ensure compliance with established deadlines.
  • Apply data modeling and statistical techniques to spot patterns and translate findings into actionable insights and reports.
  • Select and prepare documents, reports, summaries, and replies to inquiries, ensuring accuracy and proper format.
  • Acquire data from primary and secondary sources, maintain databases, and manage follow-ups with leadership and stakeholders on required information and actions.


Minimum Qualifications

  • Four-year degree or equivalent experience, with 5 or more years as a Business or Data Analyst working with teams and key stakeholders.
  • Ability to review, interpret, and evaluate complex legal and non-legal documents, including financial statements, corporate filings, and regulatory submissions.
  • Federal Acquisition Regulations knowledge is a plus.
  • Proficient in Microsoft Office Suite, including Excel with advanced functions, Power BI, PowerPoint, and Word, with intermediate database skills.
  • Strong organizational, analytical, and time management skills with the ability to maintain confidentiality and work independently.
  • Excellent written and verbal communication skills with meticulous data entry habits, a service-oriented mindset, and strong attention to detail.

21. Business Data Analyst (BI Reporting & Power BI)

A key member of the Business Intelligence team, the Business Data Analyst executes requirements documentation, visualization development, and testing procedures to maintain and enhance the BI reporting suite across Sales, Pricing, FP&A, Investments, and IT. Collaborating across business stakeholders and Reporting and Engineering team members under the direction of the Director of Business Intelligence, this role develops SQL, DAX, and Power BI solutions on large datasets and evangelizes data analytics best practices throughout the organization.


Accountabilities

  • Partner with business stakeholders across Sales, Pricing, FP&A, Investments, and IT to document requirements for the BI reporting suite, including customizations and enhancements.
  • Translate business requirements into functional and technical requirements for Reporting and Engineering team members.
  • Design report wireframes to ensure continuity and UI/UX integrity of the BI reporting suite.
  • Develop visualizations, dashboards, and KPI scorecards using Power BI and leading visualization techniques.
  • Develop SQL, DAX, and Power BI calculations that are accurate and performant on large datasets.
  • Implement and manage testing procedures for reporting changes, including creating, reviewing, and executing test plans.
  • Evangelize data analytics best practices among peers and stakeholders and assist with Power BI governance and deployment.


Skills & Qualifications

  • Bachelor's degree in Computer Science, Design, Statistics, or equivalent.
  • 3 or more years of experience documenting business requirements, processes, and workflows, with 1 to 2 years of Power BI development and UI/UX design experience.
  • Experience with the Microsoft BI stack including TSQL, Power BI, Power Query, MDX, DAX, SSAS, SSRS, and SSIS.
  • Proficient in SQL development and advanced MS Excel, including functions, macros, and VBA programming.
  • Detail-oriented and self-directed with excellent written, verbal, and facilitation skills.

22. Business Data Analyst (HR People Analytics)

Confident, self-service people decisions depend on the Business Data Analyst, who coordinates data visualization strategy, complex metric dashboards, and HR Analytics Data Warehouse improvements in collaboration with IT and the People Analytics team. Based within an HR analytics function serving Swiss Re, this role collects and prepares complex data sets, presents recommendations to middle and top management, and reduces manual reporting through scalable self-service capabilities.


Key Responsibilities

  • Participate in HR and enterprise projects to build a strong data visualization strategy and help business users become more analytical and self-sufficient.
  • Analyze and assess business challenges, evaluate solutions based on data analytics and visualizations, and present recommendations to middle and top management.
  • Support maintenance and improvements of the HR Analytics Data Warehouse in collaboration with IT.
  • Collect data across various sources and prepare complex data sets for analysis.
  • Develop and maintain complex metric dashboards to accelerate self-service capabilities and reduce manual reporting processes.
  • Collaborate with team members on workshops and projects, sharing business and technical knowledge.


Professional Experience

  • Graduate degree (BA or higher), with 5 or more years of experience in similar roles, preferably including the HR sector.
  • 3 or more years of Tableau Desktop and data visualization experience with dashboard design capabilities.
  • Experience in similar BI tools as a plus.
  • Proficient in SQL for data wrangling and synthesis, with Python, R, Hadoop, or JavaScript as a plus.
  • In-depth knowledge of business information systems.
  • A creative approach to data visualization and strong design aesthetic.
  • Strong analytical thinking and a solution-delivery orientation.
  • Ability to communicate effectively across levels and functions and fluency in English.

Editorial Process and Content Quality

This content is developed by the Lamwork Editorial Team using structured analysis of real-world job data, skill requirements, and hiring patterns.

Research framework by Lam Nguyen, Founder & Editorial Lead.

Reviewed by Thanh Huyen, Managing Editor.

Learn more about our editorial standards.