MVP Consulting Plus
MVP Consulting Plus

Specialist III (Data) (7+ yes (w-2+ yrs AS Spec lead); Data conversion/warehouse prjts; SDLC)

Albany, NY, US • Posted 3 hours ago • Updated 3 hours ago
Full Time
On-site
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Warehouse
  • Leadership
  • Performance Tuning
  • Software Development
  • Software Development Methodology
  • Requirements Elicitation
  • Development Testing
  • Data Integration
  • Writing
  • RDBMS
  • PostgreSQL
  • Informatica
  • Transact-SQL
  • PL/SQL
  • Profit And Loss
  • Public Sector
  • Migration
  • Dimensional Modeling
  • Business Cases
  • Python
  • Data Processing
  • Scripting
  • Acceptance Testing
  • Communication
  • Oracle Linux
  • System Migration
  • FOCUS
  • Test Estimation
  • Data Mapping
  • Extract
  • Transform
  • Load
  • Data Loading
  • As-is Process
  • Data Warehouse
  • Data Marts
  • Testing
  • Unix
  • Shell Scripting
  • Meta-data Management
  • Documentation
  • Data Cleansing
  • Data Profiling
  • Bridging
  • Data Quality
  • Data Conversion
  • Quality Assurance
  • SQL
  • Database
  • Oracle
  • Microsoft SQL Server
  • Telecommuting
  • Management

Summary

Mandatory Qualifications:
  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. More than seven (7) years working on data conversion/data warehouse projects, including: source system metadata analysis, documentation, and validation; source-to-target data mapping; data profiling and data cleansing rules; To-Be system data requirements gathering, analysis, documentation, and validation; data synchronization and bridging requirements; and data conversion quality assurance testing; experience with UNIX shell scripting with performance tuning of queries during data loads and transformations.
  3. More than seven(7) years of experience working across the full Software Development Life Cycle (SDLC) for data conversion/data warehouse projects, including requirements gathering, design, development, testing, and deployment phases as a Data Analyst and ETL developer in data warehousing or data integration projects; writing SQL statements and queries against RDBMS platforms such as Oracle, SQL Server, and PostgreSQL as part of development and validation; developing and executing ETL processes using any industry-standard ETL tool or scripting-based approach (e.g., Informatica, T-SQL, PL/SQL, PL/pgSQL).

Desirable Qualifications:
  1. Three or more years of experience in government or public sector data systems.
  2. Experience with data conversion/migration projects, especially legacy-to-modern system transitions .
  3. Strong understanding of data warehouse/DataMart concepts (staging, dimensional modeling, etc.)
  4. Five or more years of experience with Data Quality processes, approaches, measurement techniques, and business cases for data profiling, cleansing, standardization, and match and merge functionality.
  5. Working knowledge of Python for data processing or automation scripts, a plus.
  6. Experience supporting QA/UAT for data conversion testing.
  7. Strong written and verbal communication skills; ability to present data findings to technical and non-technical audiences.

Travel/Part-Time/Duties/Responsibilities: Job Description: Data Specialist (Level III)

Role Summary
We are looking for an experienced Data Specialist to own the data mapping, and data requirements work for our system migration. The primary focus of this role is to deliver complete, well-documented, and validated source-to-target data mapping requirements along with development and testing effort of the solution.

Key Responsibilities :
  • Work with Subject Matter Experts, Business Analysts, and Development Teams to gather, define, and document data requirements and attributes for the project.
  • Develop and maintain As-Is to To-Be source-to-target data mapping, including analysis and interpretation of complex data on both source and target systems.
  • Document To-Be target model data requirements based on business requirements and validate them with stakeholders.
  • 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 and data warehouse/DataMart.
  • Developing and testing UNIX Shell Scripting.
  • Perform source system metadata analysis, documentation, and validation.
  • Define and document data profiling, data cleansing, and data transformation rules.
  • Coordinate and facilitate data profiling and data cleansing activities with business users.
  • Interpret data profiling results and present findings and recommendations in a clear, concise manner.
  • Gather, analyze, and document data synchronization and bridging requirements.
  • Identify and resolve data quality and consistency issues, and support data conversion quality assurance testing.
  • Develop and test SQL queries against databases such as Oracle and SQL Server to analyze and validate data.
  • Other duties as assigned.

Consultants may be eligible to telecommute for more than 50% of their work hours, up to and including 100% remote work. Telecommuting arrangements require direct manager approval and are subject to change based on program needs. Consultants approved for 100% remote work must attend monthly in-person meetings at the Albany office and be available for major milestone meetings as needed.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10109907
  • Position Id: 8f29d79414e0cdc23aaa9728b46975f6
  • Posted 3 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Lead Data Conversion & ETL Specialist - Level III

Albany, New York

•

Today

Easy Apply

Third Party, Contract

Data Specialist

Hybrid in Albany, New York

•

Yesterday

Easy Apply

Full-time

Depends on Experience

Sr Analyst, Data Management (ROPS)

Remote or Colorado

•

17d ago

Full-time

USD 70,000.00 - 106,000.00 per year

Lead Data Migration - Archival - DR Engineer

Remote

•

Today

Full-time

USD 128,039.00 - 173,229.00 per year

Search all similar jobs
More jobs at MVP Consulting Plus in Albany, NY