IT Data Analyst II

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

Job Summary: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:

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:$94,900 - $129,570

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.

2019-7330