Note: The job is a remote job and is open to candidates in USA. Dice is seeking a senior data analyst to support the New York State Integrated Eligibility System (IES) modernization program. The role will analyze, transform, map, profile, cleanse, and validate data; support ETL and migration activities; develop database queries and scripts; and ensure data quality and integrity.
Responsibilities
- Working with Subject Matter Experts, Business Analysts, and Development Teams to understand the data requirements and attributes set for project
- Performing As-Is system and data analysis and data documentation
- Performing system and data analysis to perform Extract Transform & Load (ETL) and related activities including developing strategies for extracting, transforming, and loading data from the As-Is system into To-Be system
- Developing As-Is system to To-Be system data mapping including analyzing and interpreting all complex data on the source and target systems and providing resolutions to all data issues to validate all requirements
- Developing and testing query solutions on databases like Oracle, SQL Server Developing and testing UNIX Shell Scripting
- Performance tuning and optimization of queries and solving migration issues, and identifying errors during data loads and transformations
- Documenting IES To-Be Target Model data requirements for IES system based on business requirements
- Defining and documenting data requirements, data profiling, data cleansing, and data transformation rules
- Coordinating and facilitating As-Is data profiling and data cleansing activities with business users
- Interpreting data profiling results and summarizing, analyzing, and preparing reports and findings in a clear and concise manner
- Identifying optimal approaches for resolving data quality or consistency issues to achieve goals
Skills
- We are looking for a Sr. Data Analyst with at least 7 years of experience
- *Must have strong experience with Integrated Eligibility System (IES)
- Only EST based candidates that can drive in as needed
- 1. Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Specialist
- 2. Minimum of seven years of experience supporting data conversion projects, including source system metadata analysis, source-to-target data mapping, data profiling and cleansing, To-Be data requirements, data synchronization/bridging, and data conversion quality assurance testing
- 3. Minimum of two years of experience working in an Integrated Eligibility System (IES) program within the Fair Hearings and/or Data Management domain in a Health and Human Services setting
- 4. More than five years of experience with data quality, data profiling, data cleansing, standardization, and SQL development using RDBMS tools (i.e., Oracle) and data quality tools (i.e., Informatica Data Quality)
- 5. Three or more years' experience analyzing data and business processes to identify data quality issues and support data cleansing, transformation, and migration activities
Benefits
- Remote work arrangement
- 30 months + potential for extension
Company Overview
Company H1B Sponsorship