IT Data Analyst II

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

Job Summary:

Responsibilities:

• Translating the data requirements into specifications for development
• Profiling data sources to determine suitability for a solution
• Performing detailed analysis, identifying trends and patterns in data
• 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 best practices, guidelines and standards for Data Integration COE

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.

Education/Experience:

• High School Diploma/GED required
• Bachelor degree preferred or relevant experience 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 ( 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
• Query Tools such as AQT, TOAD, etc
• 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

Strongly Desired Technical Skills:

• Informatica Data Analyst or other similar data analysis and profiling tools
• Informatica Data Explorer or other similar tools
• Master Data Management processes and platforms such as Initiate, Informatica MDM, IBM MDM, etc
• Data Federation tools such as Teradata QueryGrid, Composite or Informatica DV
• Other DBMS platforms such as Sybase, SQL Server, MS Access
• Familiarity with reporting and analytics tools such as SAS, Tableau, Cognos, etc

Salary Range:

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

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.