Data Analyst, BI Architecture, Client Facing Experience

Responsibilities

• Partner with business stakeholders to gather, clarify, and document reporting and analytics requirements.

• Work closely with BI Developers, BI Architects, Data Architects, and Data Engineers to translate business needs into technical specifications.

• Understand where data resides across source systems, data warehouses, semantic layers, and BI tools.

• Analyze ETL/ELT processes, data flows, transformations, and dependencies to support BI solution design.

• Document source-to-target mappings, business rules, metric definitions, filter logic, report logic, and reporting assumptions.

• Create clear, development-ready user stories, tickets, acceptance criteria, and supporting documentation for technical teams.

• Support backlog refinement, sprint planning, testing, and release coordination for BI and analytics work.

• Validate reporting outputs against source data, business rules, requirements, and expected results.

• Investigate data discrepancies, reporting defects, and gaps between business expectations and technical implementation.

• Coordinate across BI, data architecture, data engineering, and business teams to resolve issues and drive delivery.

• Support standardization of BI requirements, documentation practices, reusable reporting patterns, and intake processes.

• Assist with user acceptance testing and production validation for new or enhanced dashboards, reports, datasets, and semantic models.

• Communicate technical concepts clearly to non-technical stakeholders and communicate business context clearly to technical teams.

• Identify opportunities to improve reporting processes, data usability, development handoffs, and operational efficiency.

Requirements

• bachelor's degree in information systems, Business Analytics, Computer Science, Data Analytics, Business Administration, or related field; equivalent experience may be considered.

• 3+ years of experience as a Data Analyst, BI Analyst, Business Analyst, Technical Business Analyst, Systems Analyst, or similar role supporting data, reporting, or analytics initiatives.

• Strong understanding of BI delivery processes, reporting requirements, data models, and analytics solution design.

• Experience working with BI tools such as Power BI, ThoughtSpot, Tableau, Looker, or similar platforms.

• Experience working with data warehouses, relational databases, or cloud data platforms such as Snowflake, SQL Server, Azure, or similar technologies.

• Ability to read and write SQL for data investigation, validation, requirements analysis, and troubleshooting.

• Understanding of ETL/ELT concepts, data pipelines, source-to-target mapping, transformation logic, and data dependencies.

• Experience creating user stories, acceptance criteria, process flows, data mappings, technical specifications, and supporting documentation.

• Strong communication skills with the ability to work effectively between business stakeholders and technical teams.

• Strong analytical, problem-solving, and organizational skills with attention to detail and accuracy.

• Experience with Agile delivery tools such as Jira, Azure DevOps, or similar platforms preferred.

• Preferred domain experience includes healthcare, pharmacy, patient services, specialty pharmacy, hub services, payer/insurance, life sciences, pharmaceutical, or other regulated operational reporting environments.

ATS Optimization Keywords

Hard Skills

• data analysis

• business intelligence (BI)

• ETL

• ELT

• SQL

• data modeling

• reporting requirements

• analytics solution design

• user stories

• acceptance criteria

Soft Skills

• communication skills

• analytical skills

• problem-solving skills

• organizational skills

• attention to detail

• collaboration

• stakeholder management

• documentation skills

• process improvement

• technical communication

Industry Keywords

• healthcare

• pharmacy

• patient services

• specialty pharmacy

• hub services

• payer/insurance

• life sciences

• pharmaceutical

• regulated operational reporting

• data governance

Tools & Technologies

• Power BI

• Tableau

• Looker

• ThoughtSpot

• Snowflake

• SQL Server

• Azure

• Jira

• Azure DevOps

• data warehouses