Analyzes and QA's data management system, data feeds, data processes and databases. Responsible for reviewing all incoming requirements, completed technical tasks and reported issues. Communicates with internal and external stakeholders in regards to requirements and data knowledge
Essential Duties & Functions
* Monitors all production databases including data sources, data structures, data organization, and data optimization
* Performs data analysis and corrections as required
* Performs research and provides recommendations for data definition, requirements and structure
* Reviews and analyzes specific data elements for accuracy and quality assurance
* Identifies, verifies and analyzes data defects/issues and communicates with team to determining the root cause for issue resolution
* Creates SQL queries for reporting and support troubleshooting
* Provides analytical support and conducts data mining/complex multiple variable analysis
* Oversees data QA functions to ensure accuracy of business rules defined and data integrity
* Proactively identifies issues and trends through data analysis and manipulation
* Supports initiatives for data integrity and normalization
* Owns and monitors ETL regression test database
* Defines ETL requirements and tests the ETL tools
* Administers Data Mart and Data Warehouse via administration tools
* Maintains Confluence page on data projects
* Communicates effectively with cross functional teams
* Responsible for initiating ad-hoc data process jobs
* Responsible for daily monitoring of alerts and client reports for data accuracy
* Interpret and analyze data from multiple sources including claims, member, and benefits data.
* Bachelor's degree (B. A. / B. S.) from four-year college or university; 2+ years related experience and/or training; or equivalent combination of education and experience.
* 2+ years of experience as a data analyst or in related field.
* Experience with query languages (SQL) preferred.
* Ability to work with stakeholders to assess potential risks.
* Ability to analyze existing tools and databases and provide data solution recommendations.
* Ability to translate business requirements into non-technical, lay terms.
* High-level experience in methodologies and processes for managing large scale databases.
* Demonstrated experience in analyzing large data sets and relational databases.
* Ability to manage time and priorities of multiple projects/tasks
* Displays professionalism and ability to learn quickly
* Conscientious of work quality and deadlines
* Extremely detail oriented
* Strong oral and written communication skills.
* Ability to collaborate closely with multiple teams across with a wide range of technical backgrounds.
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.