IT Data Analyst II - Data Governance

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 liv