Senior Data Analyst with ETL expertise

UNIVERSAL Technologies is seeking a Senior Data Analyst with ETL expertise and experience in mainframe/relational database management systems for a hybrid position in Brooklyn, NY. The applicant is expected to work onsite.

Position: The Senior Data Analyst with ETL Expertise shall provide the client’s Data Management team with technical expertise for the completion of Data Profiling/Cleansing, Conversion/Migration and Validation efforts as part of the Legacy Replacement initiative as well as the client’s ongoing process improvement programs.

WHO WE ARE:

UNIVERSAL Technologies, LLC is a Women-Owned (M/WBE) IT solutions and consulting company focused at delivering enterprise systems that significantly improve our clients IT performance. We work across the IT spectrum including Development, Business/Systems/Data Analysis, Project Management, Cyber Security, Network Engineering, and High-Level System Architecture.

The pride in the services we provide and the accessibility and flexibility we provide to employees are what make Universal Technologies stand out from the rest! We hope to propel your IT career to the next level and excite our employees with new and challenging projects.

WHAT WE OFFER:

Our W2 employees can expect the following benefits:

Competitive pay
Health/Dental Insurance
Group Life Insurance
401K
HSA/FSA
Pre-Tax Transportation Program
Generous Paid Time Off/Holiday Policy

MANDATORY SKILLS/EXPERIENCE:

• Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.
• Experience creating data dictionary documentation with business terms, valid values, and definitions.
• Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases.
• Minimum of three (3) years of recent experience developing applications using IBM DataStage ETL.
• Experience extracting field references and calculated data from COBOL programs.
• Experience with BMC Control-M workload automation software.
• Experience with GIT version control software.
• Minimum of three (3) years of recent experience with Pension Administration systems.

Technical Ability Mandatory:

• Strong SQL knowledge working with complex queries and stored procedures.
• Proficiency in SSRS reports’ development.
• Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team’s methodology.
• Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.
• Proficiency in mainframe applications encompassing COBOL, CICS and DB2.
• Understanding of data structures and their relationship to ETL applications.
• Ability to develop complex SQL data validations based on STTMs and target data Models.
• Excellent analytical, problem-solving, and information gathering skills along with fundamental technical troubleshooting abilities.

DESIRABLE SKILLS/EXPERIENCE:

• Experience extracting business rules from the existing legacy code.
• Experience with Data Quality/Profiling tools.
• Experience with Data Warehouses/Data Marts.
• Experience with SQL Server Reporting Services (SSRS).
• Prior experience working in a pension system, preferably New York State or New York City pension system.

SCOPE OF SERVICES:

The client seeks one (1) Senior Data Analyst with ETL expertise to work with the Information Technology (IT) Division. The Senior Data Analyst with ETL Expertise will primarily be responsible for detailed field level analysis, metadata analysis, profiling, and mapping of VSAM files into relational/dimensional SQL tables as well as conversion/validation efforts as part of an enterprise-wide Legacy Replacement program. The Senior Data Analyst will create and maintain the master data dictionary, and assist in database design of the client’s mission-critical applications and inventory of its components.

UNIVERSAL Technologies is an Equal Opportunity Employer