Creates and maintains databases to track business performance
Analyzes data and summarizes performance using summary statistical procedures
Develops and analyzes business performance reports (e.g. for claims data, provider data, utilization data) and provides notations of performance deviations and anomalies
Serves as a subject matter expert in data analysis and reporting, formulating actionable recommendations and providing guidance to other data analysts
Creates and publishes periodic reports, as well as develops ad hoc reports to address emerging business questions and priorities
Translates complex business issues into diagnostic and/or tracking data solutions that convert business requirements into actionable decision support tools
Identifies trends, patterns, and outliers in large and complex datasets to inform strategic and operational decisions
Provides analytic consultation to business partners, leadership, and external customers to support performance improvement initiatives
Makes data-driven recommendations based on analysis and clearly communicates findings to technical and non-technical stakeholders
Ensures data integrity, consistency, and accuracy across reporting solutions and analytic outputs
Supports a higher level of complexity in data analysis and reporting, requiring advanced problem-solving, critical thinking, and independent judgment
Ensures proper data definitions, ownership, use and integrity of data
Analyzes more complex business user needs, documents information requirements, facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed
Collaborates with IT resources on the creation and maintenance of the content of the data warehouse
Establishes and maintains excellent knowledge of data warehouse data structure design, definitions, capabilities, programming languages, and data integrity issues
Completes metadata assessment and reviews feedback to determine changes needed
Ensures that data definitions are clear and current and communicates changes to data definitions to all users
Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule.

Requirements

Requires a BA/BS degree in related field
A minimum of 6 years’ experience in data analysis, data modeling, and working with automated data warehouse systems
Experience presenting technical subject matters to non-technical audiences highly preferred
Experience navigating new data models (both documented and undocumented) highly preferred
Ability to manipulate large sets of data highly preferred
Ability to learn new subject matter and document effectively for broader team knowledge/use highly preferred
Professionalism, positivity, and being solution-oriented in communications and collaborations inside and outside of the team highly preferred
Experience with relational databases
Knowledge of query tools and statistical software highly preferred
Ability to train and mentor junior team members in advanced SQL query-writing and team standard operating procedures preferred
Strong analytical, organizational, presentation, and problem-solving skills strongly preferred
Familiarity with Amazon RedShift, Snowflake, Postgres, Microsoft SQL Server, Oracle, or equivalent database software preferred
Familiarity with ETL coding via Python, or ETL software such as Microsoft SSIS, Informatica, or Talend preferred.

Benefits

Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development opportunities
Bonuses
Stock options
Equipment allowances
Wellness programs

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data analysisdata modelingautomated data warehouse systemsSQLETL codingstatistical proceduresdata integritymetadata assessmentdata definitionsdata visualization

Soft Skills

problem-solvingcritical thinkingcommunicationcollaborationpresentationorganizational skillsmentoringprofessionalismpositivitysolution-oriented