Facilitates reporting efforts by utilizing SQL and other related data query tools to generate reports or retrieve data from Amazon Redshift, ensuring seamless integration with the company's data warehouse and other distributed databases.Extensive experience with AWS Amazon Redshift, including data modeling, database design, and query optimization.Proven ability to manage and extract large-scale data sets using Amazon Redshift in a cloud-based environment.

Responsible for leading and facilitating the analytics, decision support, and research functions of the assigned department.Creates, analyzes, and distributes monthly, quarterly and annual reports and analyses for required reporting activities.  Extracts, prepares, analyzes, validates and presents data for standard and ad hoc reporting.Interprets, analyzes, and makes recommendations regarding data accuracy and data collection needs and processes. Develops and implements plans, and proactively seeks ways to enhance overall unit reporting needs and abilities.Facilitates reporting efforts, by utilizing SQL or other related data query tools, in order to generate reports or retrieve data from the company's data warehouse and other distributed databases.Coordinates application enhancements and edits to promote data quality with the IT department.Mentors peers and co-workers as appropriate.Plays a lead role in prioritizing and coordinating projects and report development efforts. Provides direction and coordination for the tracking and analyses of audit findings and report generation.

Other Job Requirements

Responsibilities

7 or more years of experience performing statistical analysis and the use of statistical packages required.
Bachelor's degree required.
May consider an additional 3-4 years of relevant experience in lieu of bachelor's degree.
Experience in statistics, research, information systems or health services related field, such as Public Health, Health Science, Psychology, with reporting and analytical emphasis, research evaluation and/or experimental design.
Strong writing, verbal communication and presentation skills essential.
Strong leadership, process improvement, time management, and project management skills.
Must be able to manage multiple tasks.
Must be able to provide accurate estimates of work effort and deliver results within a committed time frame.
Must be able to work independently and with minimal supervision.
Requires strong expertise in MS Excel and relational database such as MS Access and other database management (MS SQL) and reporting tools. Ability to use reporting software such as Actuate, Cognos, Crystal reports, SAS, or other.
Ability to query the company's data warehouse and/or department systems in response to data requests.

General Job Information

Title

Lead Data & Reporting analyst

Grade

27

Work Experience - Required

Analytics/Informatics

Work Experience - Preferred

Managed Healthcare

Education - Required

Bachelor's

Education - Preferred

Master's

License and Certifications - Required

License and Certifications - Preferred

Salary Range

Salary Minimum:

$77,785

Salary Maximum:

$124,455

This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Actual pay will be adjusted based on an individual's skills, experience, education, and other job-related factors permitted by law.

This position may be eligible for short-term incentives as well as a comprehensive benefits package. Magellan offers a broad range of health, life, voluntary and other benefits and perks that enhance your physical, mental, emotional and financial wellbeing.

Magellan Health, Inc. is proud to be an Equal Opportunity Employer and a Tobacco-free workplace. EOE/M/F/Vet/Disabled.
Every employee must understand, comply with and attest to the security responsibilities and security controls unique to their position; and comply with all applicable legal, regulatory, and contractual requirements and internal policies and procedures.