Vacancy expired!
Job Summary:
- A client of ours in Norfolk VA is looking for a Data Analyst Lead for a Contract opportunity.
- Data Warehousing and ETL
- Data Marts
- Data Profiling
- Data Modeling
- Data Quality Analysis
- Modeling Dimensional Databases and Data Marts (includes physical and logical models)
- Writing complex SQL and stored procedures (DB2 preferred); translating specifications and rules into SQL
- Working with data modeling tools (Erwin preferred)
- Interpreting and writing source to target mappings (ETL transformation rules)
- Working with string and data manipulation functions and macros with Microsoft Excel
- Metadata management and data governance
- Creating and maintaining data dictionaries
- Maintaining and interpreting data lineages
- Ability to speak to the various aspect of the SDLC
- Ability to draw out high-level and detailed designs and represent them as flow diagrams (preferably using Visio)
- Ability to translate business requirements into functional and technical specifications
- Ability to look at the given system/solution from a tool/technology-agnostic perspective and document deterministic rules / behavior in pseudo-code
- Ability to design end-to-end data warehousing / reporting solutions using components like databases, ETL tools and reporting frameworks
- Ability to provide time estimations for SA activities for a project based on the design
- Ability to work closely with Development, PV and UAT teams to provide them the required support
- Ability to perform and provide a detailed system impact analysis for a given change request and provide estimates
- Able to lead junior SA persons and possibly provide feedback on multiple projects
- Good analytical and problem-solving skills
- Exceptional communication skills (written and verbal)
- Good documentation skills
- Proficiency in English language (as a medium of communication)
- Frank and open communication with peers and higher-ups about realistic estimations and meeting timelines/expectations and proactive communication of issues and concerns thereof
- Assertiveness in communicating ideas, estimates, scope, and timelines
- Experience with working on DB2 and Postgres Databases
- Experience working with PHI & PII and sensitive data
- Knowledge about ETL tools (preferably Ab Initio)
- Knowledge about other Ab Initio tools like Query>IT, MDH, BRE etc.
- Knowledge about business intelligence / analytics / tool experience Cognos/Tableau
- Knowledge about medical and Rx claims processing, healthcare enrollments and providers
- Knowledge and understanding of security standards
- Experience level: Experienced
- Minimum 8+ years of Data Analyst Lead Experience.
Vacancy expired!