- 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.
