IT Data Analyst II SQL
Job Description
Position Overview
You could be the one who changes everything for our 28 million members by using technology to improve health outcomes around the world. As a diversified, national organization, Centene's technology professionals have access to competitive benefits including a fresh perspective on workplace flexibility.
Position Purpose: Integrates, conforms, profiles and maps data, and provides quality assurance oversight (data error detection and correction) on business processes where data is collected, stored, transformed, or used. Examines moderately complex data to optimize the efficiency and quality of the data being collected, resolves data quality problems, and collaborates with the business and ETL database developers to improve systems and database designs.
Centene is an equal opportunity employer committed to diversity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other protected characteristics. Qualified applicants with arrest or conviction records will be considered in accordance with applicable ordinances and the California Fair Chance Act.
Key Responsibilities
- Interprets and analyzes data from multiple sources including claims, provider, member, and encounters data. Identifies and assesses the business impact of trends.
- Develops, executes, maintains, and troubleshoots moderately complex scripts and reports developed using SQL, Microsoft Excel, or other analytics tools.
- Identifies and performs root-cause analysis of data irregularities and presents findings and proposed solutions to leadership and/or customers.
- Manages multiple intermediate, variable tasks and data review processes with limited supervision within targeted timelines and thrives in a demanding, quickly changing environment.
- Provides business solution architecture and implementation validation.
- Engages in data profiling and source to target mapping.
- Works on moderately complex data integration from disparate sources.
- Applies expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand how customers interact with analytic products.
- Supports multiple functions and levels of the organization and effectively, both verbally and visually, communicates findings and insights to non-technical business partners.
- Engages with customers and business partners to gather requirements and validate results.
- Presents data-driven insights and recommendations to both internal and external stakeholders, soliciting and incorporating feedback when required.
- Performs other duties as assigned.
- Complies with all policies and standards.
Required Qualifications
- Requirements: Must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Sponsorship is not available for this opportunity.
- Education: A Bachelor’s degree in a quantitative or business field (e.g., statistics, mathematics, engineering, computer science) or equivalent experience acquired through applicable accomplishments.
- Experience Required: 2 – 4 years of related experience.
Preferred Qualifications
- Qualifications: Technical Skills – Experience with Big Data; Data Processing; Data Manipulation; Data Mining; and proficiency in one or more of the following: C#, Java, programming concepts, programming tools, Python, SQL; as well as Agile Software Development.
- Qualifications: Soft Skills – Intermediate level ability to acquire knowledge in the area of specialty, identify basic problems and procedural irregularities, and work independently.
Benefits & Perks
- Salary: $63,600.00 - $114,600.00 per year
- Benefits: Comprehensive benefits package including competitive pay, health insurance, 401K and stock purchase plans, tuition reimbursement, paid time off plus holidays, and flexible work arrangements (remote, hybrid, field, or office schedules).
- Compensation: Actual pay will be adjusted based on an individual's skills, experience, education, and other job-related factors; total compensation may also include additional incentives.