Job Location: Greater Harrisburg Area
Member of the team responsible for identifying and driving implementation of initiatives to ensure the quality of new features and releases of software. Works with both development and quality engineers and influences design changes to improve quality and features testability. This role requires hands-on experience in current data warehouse, business intelligence, report writing, and ETL technologies, techniques and architecture. Analyze business data requirements to create relevant reporting and ETL deliverables, including technical specifications, source schema maps, transformation rules and ETL flows.
- 40% – Delivers, tests and maintains data in the database using best in class tools such as Informatica, Talend, DataStage, SSIS etc.
- 15% – Advanced DDL and DML SQL coding capabilities including complex joins, functions, grouping, unions, conditions, nesting and correlating etc.
- 10% – Technically proficient with UNIX at the command line and with scripting using all shells.
- 15% – Analyzes requirements and existing resources to create efficient, high quality ETL designs that meet agreed upon standards.
- 10% – Ability to work closely with customers to bridge gaps in requirements understanding while delivering iterative data samples that congeal to a final deliverable.
- 5% – Proficient with scheduling tools (successors and predecessors) and demonstrates a detailed understanding of technical process flows.
- 5% – Owns and effectively maintains data lineage from a business level to the very technical
Leadership
- Ability to lead projects and teams relevant to assignments.
- Experience mentoring junior and senior level team members 50on best ETL architecture practices
Skills
- Ability to evaluate current data content across the organization and recommend necessary change if required for information asset management needs.
- Strong ability to troubleshoot technical challenges.
- Requires technical aptitude to recognize issues. Strong communication skills shown through experience in translating specific functional content to both IT and Business audiences so that all aspects are fully understood by each side.
Knowledge
- Knowledge of managed care/health insurance business processes, data variations, current Plan system infrastructure, and products offered by Capital BlueCross and its competitors, e.g. PPO, POS, HMO, Rx, Dental, Vision.
- Knowledge of Plan systems, applications and databases and their underlying data structures, including but not limited to: claims, eligibility, premium, clinical, sales.
- Must have practical knowledge of designing, building and maintaining corporate enterprise ETL processes.
- Design, develop and maintain data warehouse schema
- Engineer ETL routines and data access interfaces
- Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)
- Ability to translate business requirements into technical specifications, develop code and test cases, and deploy the approved solution.
Experience
- 7+ years experience with ETL processing in SQL environment is preferred.
- 7+ years of data and information management experience including data modeling, warehousing, processing and management.
- 7+ years of health care solutions development experience, or equivalent combination of experience and education.
- Demonstrated ability to drive results to completion, while managing multiple projects and priorities.
- 7+ years experience with Informatica accessing large volumes of data in databases such as Netezza, Oracle, and SQL Server.
Education, Certification, And Licenses
Bachelor’s Degree in one of the following: Business Information Management, Computer Science, Business Administration, Mathematics/Statistics, or Health Administration
Capital Blue Cross is an independent licensee of the Blue Cross Blue Shield Association. We are an equal opportunity/affirmative action employer and do not discriminate on the basis of race, color, religion, national origin, gender, sexual orientation, gender identity, age, genetic information, physical or mental disability, veteran status, or marital status, or any other status protected by applicable law.
Submit CV To All Data Science Job Consultants Across United States For Free
