IT Data Analyst II - Data Governance

100 Horizon Healthcare Services, Inc • Newark, NJ

389d • $94,900 - $129,570

About The Position

The Data Analyst II at Horizon BCBSNJ plays a crucial role in ensuring the accuracy, quality, completeness, and timeliness of data. This position involves collaborating with various stakeholders, including Data Modelers, Data Developers, and Business SMEs, to capture and deliver customer data needs effectively. The Data Analyst II leads projects focused on data analysis and design, ensuring high-quality data specifications are provided to developers.

Requirements

• 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.
• 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, including entities, classes, hierarchies, relationships, and metadata.
• Knowledge of 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 for 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.

Nice To Haves

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

Responsibilities

• Profiling data sources to determine suitability for a solution.
• Performing detailed analysis, identifying trends and patterns in data.
• Preparing, developing, analyzing, shaping, and delivering reports and presentations that tell a story, including current state data assessments, gap analysis, and solution recommendations.
• Performing root cause analysis on data anomalies and collaborating with data stewards to resolve issues.
• Facilitating review sessions with business users and team members.
• Directing and reviewing the work of other Data Analysts on projects.
• Coaching and mentoring junior analysts.
• Providing estimates for work efforts on projects.
• Developing Data Governance best practices, guidelines, and standards.

Benefits

• Comprehensive health benefits (Medical/Dental/Vision)
• Retirement Plans
• Generous PTO
• Incentive Plans
• Wellness Programs
• Paid Volunteer Time Off
• Tuition Reimbursement

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree