Required Skills

ETL Data Analyst

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 8th Feb 2024

JOB DETAIL

MUST HAVE :
Non-Negotiables:
1) Experience with databases and SQL (Prefer DB2); ETL exposure (preferably AbInitio); Reporting system exposure (preferably Cognos)
2) Data Modeling, Data analysis, data profiling and data manipulation skills.
3) Experience with implementing ETL systems and reporting systems / data warehouses and data marts
4) Experience in exploring and writing functional requirements with business/tech teams. Example documents: Functional Requirements Specifications (FRS), Requirements Traceability Matrix (RTM), Source to Targets (S2Ts), Data Exchange Documents (DEDs), and Data Models.
5) Good communication skills - written and spoken.
 
Required Basic Qualifications:
 
- Bachelor’s Degree in Computer Science, Information Systems, Business Administration or equivalent work experience.
- Minimum 7 years of IT work experience including application system design and implementation.
- Experience with the following technology stack: Cognos, Tableau, XML, SQL, Ab-Initio, DB2, Oracle
- Knowledge of multiple development methodologies.
- Experience with the following: Data Warehousing, Business Intelligence, Data Marts, Data profiling, Data Quality analysis and Data Analytics.
- Advanced SQL query and experience in a data analyst role with strong data analysis and analytical skills
- Minimum 3 years of database modeling including one or more of the following: DB2, Oracle, SQL/Server or comparable
- Effective at gathering and analyzing business requirements and current system behavior and collaborating to create system design specification documents including functional specifications, system use cases, mock-ups, and design models.
- Demonstrated experience working within a complex team environment, working with multiple vendor teams, providing SME support across multiple programs
- Experience with reference data management / governance and end to end data lineage
- Proven ability to lead a team and collaborate with stakeholders
- Strong collaboration, facilitation, and listening skillset
 
Preferred Basic Qualifications:
 
- Master’s Degree.
- Strong technology project management skills.
- Healthcare data experience.
- Exceptional verbal and written communication
- Customer Internal and External consulting experience
- Knowledge about HEDIS, Care and Disease management programs, Stays, Groupers
- Preferred experience with Ab Initio products like MDH, Query>It, data profiler
- Exposure to job scheduling systems is a plus
- IBM Watson Health Advantage Suite experience is a bonus
- Contingent will be assigned to multiple projects within the FEP Program.
- Contingent will be responsible for completing all the System Analysis & Design work and deliverables for all assigned projects.

Company Information