IT Data Analyst II - Data Governance

MedStar Health; Newark (NJ); On-site; USD 96,000 - 132,000; Full time

Job summary

A leading healthcare organization seeks a Data Analyst II, responsible for ensuring data quality, performing analysis, and directing junior staff. With a focus on healthcare data, the candidate will work on various data projects, ensuring accuracy and optimal reporting. The position requires substantial experience in data analysis and strong SQL skills.

Benefits

Comprehensive health benefits

Retirement Plans

Generous PTO

Incentive Plans

Wellness Programs

Paid Volunteer Time Off

Tuition Reimbursement

Qualifications

• Minimum of 8+ years of relevant work experience.
• 6+ years of experience in Data Analysis or data related roles.
• 4+ years of Healthcare experience.

Responsibilities

• Profiling data sources to determine suitability for a solution.
• Performing detailed analysis, identifying trends and patterns in data.
• Coaching and mentoring of junior analysts.

Skills

Excellent communication

Presentation skills

Facilitation skills

Strong SQL skills

Data profiling

Data Quality metrics

Education

Bachelor's in Computer Science

Tools

Informatica Data Analyst

Informatica Data Explorer

Alation Data Catalog

SQL Server

Job description

Horizon Blue Cross Blue Shield of New Jersey empowers our members to achieve their best health. For over 90 years, we have been New Jersey's health solutions leader driving innovations that improve health care quality, affordability, and member experience. Our members are our neighbors, our friends, and our families. It is this understanding that drives us to better serve and care for the 3.5 million people who place their trust in us. We pride ourselves on our best-in-class employees and strive to maintain an innovative and inclusive environment that allows them to thrive. When our employees bring their best and succeed, the Company succeeds.

Data analysts are experts with strong understanding of data structures and analysis. They are responsible for ensuring requirements around the accuracy, quality, completeness and timeliness of data are captured and understood. They work hand in hand with Data Modelers, Data Developers, Data Stewards and Business SMEs to ensure the customers data needs are accurately captured, understood and delivered. The Data Analyst II takes a lead role on projects to develop the plan for data analysis and design and ensure the quality of the data specifications delivered to developers.

Responsibilities:

• Profiling data sources to determine suitability for a solution.
• Performing detailed analysis, identifying trends and patterns in data.
• Prepares, develops, analyzes, shapes and delivers reports and presentations in an accurate and timely manner that 'tell a story' including but not limited to current state data assessments, gap analysis, and solution recommendations.
• Performing root cause analysis on data anomalies and working data stewards to resolve issues.
• Facilitating review sessions with business users and other team members.
• Directing and reviewing the work of other Data Analysts on projects.
• Coaching and mentoring of junior analysts.
• Providing estimates for work efforts on projects.
• Development of Data Governance best practices, guidelines and standards

Education/Experience:

• Bachelor's in Computer Science preferred, or relevant work experience required in lieu of degree.
• Minimum of 8+ years of relevant work experience.
• 6+ Years of experience in Data Analysis or data related roles.
• 4+ Years of Healthcare experience.

Knowledge:

• Excellent communication, presentation and facilitation skills.
• Experience with Healthcare data formats such as X12, HL7, NCPDP, etc.
• Experience with Industry Data Models such as ADRM, IBM IIW/HPDM or Teradata Healthcare Data Model.
• Experience with Metadata management processes and tools (Data Catalog, Glossary, Lineage, Mapping, etc.)
• Strong knowledge of structured data, such as entities, classes, hierarchies, relationships and metadata.
• Knowledge of, and experience, with database management system (DBMS) physical implementation, including tables, joins and views, specifically Teradata, Oracle, Greenplum, Vertica, etc.
• Knowledge of Big Data concepts and platforms such as Hadoop.
• Knowledge of NoSQL data stores such as MongoDB, Neo4J, Cassandra, Redis, etc.
• Experience with Data Warehouse and Data Marts.
• Extremely strong SQL skills are required.
• Ability to combine data from multiple sources when needed for the analysis.
• Experience with Data Quality & Data Profiling metrics and tools.
• Knowledge and experience with Data Governance processes.
• Writing functional/mapping specifications for extracts and reports.
• Familiarity with the use cases, business purposes and quality of the data.
• Excellent communication and interpersonal skills as well as critical thinking capabilities.

Skills & Abilities:

• Informatica Data Analyst or other similar data analysis and profiling tools.
• Informatica Data Explorer or other similar tools.
• Alation Data Catalog or other similar tools
• Master Data Management processes and platforms such as Initiate, Informatica MDM, IBM MDM, etc.
• Other DBMS platforms such as SQL Server, MS Access.
• Familiarity with reporting and analytics tools such as SAS, Snowflake, Tableau, Cognos, etc.

Horizon BCBSNJ employees must live in New Jersey, New York, Pennsylvania, Connecticut or Delaware

Salary Range:

$96,300 - $131,565

This compensation range is specific to the job level and takes into account the wide range of factors that are considered in making compensation decisions, including but not limited to: education, experience, licensure, certifications, geographic location, and internal equity. This range has been created in good faith based on information known to Horizon at the time of posting. Compensation decisions are dependent on the circumstances of each case. Horizon also provides a comprehensive compensation and benefits package which includes:

• Comprehensive health benefits (Medical/Dental/Vision)

• Retirement Plans

• Generous PTO

• Incentive Plans

• Wellness Programs

• Paid Volunteer Time Off

• Tuition Reimbursement

Disclaimer:
This job summary has been designed to indicate the general nature and level of work performed by colleagues within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of colleagues assigned to this job.

Horizon Blue Cross Blue Shield of New Jersey is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran status or status as an individual with a disability and any other protected class as required by federal, state or local law. Horizon will consider reasonable accommodation requests as part of the recruiting and hiring process.