- Participate in identification, inventory, and classification of NYCERS critical data.
- Work with data SME's to document data quality rules and definitions.
- Actively participate in optimization and performance tuning of existing ETL and SQL processes
- Extract business rules from the existing Legacy code and create Source-to-Target mappings.
- Transform business rules and data quality rules into ETL and/or SQL technical specifications.
- Provide technical and analytical support to NYCERS data integrity and quality initiatives.
- Collaborate with SME's and technical leads in identifying and addressing data quality gaps.
- Work with IT partners to remediate identified gaps using both manual and automated solutions.
- Support processes that proactively detect, correct, and prevent invalid data values.
- Defect handling and problem resolution.
- Minimum 5 years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.
- Hands-on IBM DataStage ETL administration experience in Windows environment.
- Hands-on experience with SQL Server Reporting Services (SSRS) platform.
- Hands-on experience with IBM RAA (Rational Asset Analyzer).
- Experience creating data dictionary documentation with business terms, valid values, and definitions.
- Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases.
- Minimum 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, Build and CICD pipeline automation.
- Minimum 3 years of recent experience with Pension Administration systems
- Excellent analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.
- Strong SQL knowledge working with complex queries and stored procedures.
- Proficiency in LINUX/UNIX Shell scripting, C#, and VB.NET
- Proficiency in SSRS reports' development and administration.
- 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 and CICS.
- Proficiency creating Control-M Jobs, Smart Folders, Schedules with complex interdependencies.
- Understanding of data structures and their relationship to ETL applications
- 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 Integration Services (SSIS)
- Prior experience working in a pension system, preferably New York State or New York City pension system
-
Billing & Energy Analyst (Hybrid)
1 week ago
Metergy Solutions LLC Long Island City, United StatesJob Title: Billing & Energy Analyst · FLSA Status: Non-Exempt · Department: Billing · Hybrid: ~2 days in office a week · **Summary**: Create and deliver a high volume of accurate and on-time monthly invoices to our submetering clients. · Duties and Responsibilities: · - Maintain ...
-
Citi Jersey City, United StatesThe Cash & Trade Processing Associate Analyst is an entry level role responsible for assisting the function with any projects and initiatives related to cash management in coordination with the Transaction Services team. The overall objective is to facilitate multiple complex tra ...
-
Citi Jersey City, United StatesThe Cash & Trade Proc Assoc Analyst 2 is an entry level role responsible for assisting the function with any projects and initiatives related to cash management in coordination with the Transaction Services team. The overall objective is to facilitate multiple complex transaction ...
-
Hybrid Business Analyst
3 days ago
The Jacobson Group New York, United StatesJob Description · Job DescriptionJoin a financial services industry leader · **6 month contract role** · Hybrid schedule: 3 days onsite, 2 days WFH · Job Summary: · Maintains information technology strategies by managing staff; researching and implementing technological strategi ...
-
Hybrid IT Security Operations Analyst
5 days ago
Crossfire Consulting New York, United StatesJob Description: *PLEASE NOTE THIS POSITION WILL ALLOW CONSULTANT TO WORK REMOTELY. HOWEVER, DUTIES WILL REQUIRE CONSULTANT TO WORK ONSITE 3 DAYS PER WEEK. THEREFORE, WILL BE CRITICAL FOR THE CONSULTANT TO BE LOCAL TO NYC AND ABLE TO TRAVEL TO OUR OFFICE WITHOUT ISSUE, AS NEEDED ...
-
Hybrid MicroStrategy Solutions Analyst
21 hours ago
JVT Advisors New York, United StatesFull-time role with excellent benefits. 3 days a week on-site in NYC. · JOB SUMMARY: · The MicroStrategy Solutions Analyst will join a team of developers responsible for the firm's enterprise data warehouse, management reporting, and business intelligence solutions. Key initiati ...
-
BUSINESS OPERATIONS ANALYST, Hybrid
1 week ago
1836 Total Commerce New York, United States PermanentAbout Us · Founded in 2016, 1836 Total Commerce is more than just a consumer goods e-commerce company. Leveraging strategic manufacturing processes, we deliver top-tier, comfortable, and essential apparel to millions of consumers worldwide. · Our journey began seven years ago wi ...
-
Hybrid Temp Workday Reporting Analyst
1 week ago
Phaxis New York, United StatesHYBRID TEMP WORKDAY REPORTING ANALYST AT TOP NYC HEALTHCARE FIRM · Hourly Pay Rate is $59.50 to $64.50 | Temporary Assignment | MUST be Fully Vaccinated · Position Hybrid with Mixture of Home and In Office | Near Grand Central · Top NYC Healthcare firm is looking for an experie ...
-
Temp Hybrid Senior Cyber Analyst
1 week ago
Pyramid Consulting Group New York, United StatesOur client, a wellness brand, is hiring a temp Senior Cyber Analyst to join their team in NYC on a hybrid schedule. This is a temp position that will begin in early May and continue for approximately 1 year. · Job Duties Include: · Conduct research and strategic analysis of intel ...
-
Temp Hybrid Senior Cyber Analyst
1 week ago
Pyramid Consulting Group New York, United StatesOur client, a wellness brand, is hiring a temp Senior Cyber Analyst to join their team in NYC on a hybrid schedule. This is a temp position that will begin in early May and continue for approximately 1 year. · Job Duties Include: · Conduct research and strategic analysis of int ...
-
Temp Hybrid Senior Cyber Analyst
2 weeks ago
Pyramid Consulting Group, LLC New York, United StatesOur client, a wellness brand, is hiring a temp Senior Cyber Analyst to join their team in NYC on a hybrid schedule. This is a temp position that will begin in early May and continue for approximately 1 year. · Job Duties Include: · Conduct research and strategic analysis of intel ...
-
Business Systems Analyst-Hybrid Schedule
1 week ago
Columbia University New York, United StatesJob Type: Officer of Administration · Regular/Temporary: Regular · Hours Per Week: Full-time · Salary Range: $90,000-$100,000 · The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qual ...
-
Human Capital Management Analyst-Hybrid/NYC
1 week ago
Phaxis New York, United StatesOur direct client, a major hospital, is seeking a Human Capital Analyst for a immediate consulting engagement. This position is hybrid requiring 2-3 days onsite in midtown NYC, 2-3 days remote . The duration is 3 months plus extensions. · Compensation-$ $ 65.00 per hour W2. W2 on ...
-
Report Developer/Data Analyst-Hybrid/NYC
3 hours ago
Phaxis New York, United StatesOur direct client, a global banking organization is seeking a Data Analyst/Report Developer for a long-term consulting engagement. This position is hybrid, 3-4 days per week onsite in NYC, 1-2 days remote. · Pay Rate: $55.00- $60.00 per hour W2., W2 only, no third parties please ...
-
SV-FX Mid Office Analyst III-Hybrid
1 day ago
First Citizens Bank New York, NY, United StatesOverview · Together, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. · First Citizens Bank helps personal, business ...
-
SV-FX Mid Office Analyst III-Hybrid
6 days ago
First Citizens Bancshares, Inc. New York, United StatesTogether, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. First Citizens Bank helps p Office, Analyst, Client Suppo ...
-
SV-FX Mid Office Analyst III-Hybrid
15 hours ago
First Citizens Bank New York, NY, United StatesOverview · Together, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. · First Citizens Bank helps personal, business ...
-
SV-FX Mid Office Analyst III-Hybrid
6 days ago
First Citizens Bank New York, United StatesOverview: · Together, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. · First Citizens Bank helps personal, busin ...
-
SV-FX Mid Office Analyst III-Hybrid
3 days ago
First Citizens Bank New York, United StatesOverview: · Together, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. · First Citizens Bank helps personal, busin ...
-
Masis Professional Group New York, United StatesMASIS Professional Group's Insurance Staffing Team has partnered with a Global Reinsurance organization to conduct a search for a Sr. Reinsurance Contract Analyst based in NYC. · Sr. Reinsurance Contract Analyst - Hybrid NYC · Since 1977 our client has delivered first class solut ...
Senior Data Analyst Hybrid - New York, United States - CyberTec
Description
Job Title : Senior Data Analyst - Hybrid ( Only Local )
Location: Suite 2300 Brooklyn, NY,11201
Job Type : Hybrid
Duration : 72 months
Opening : 1 Opening
The Senior Data Analyst will primarily be responsible for detailed field level analysis, profiling, metadata analysis and mapping of the current IBM Mainframe VSAM files into relational/dimensional SQL tables, create and maintain the master data dictionary, assist in database design and mapping to NYCERS mission critical applications and inventory of its components.
The Senior Data Analyst shall provide NYCERS' Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing efforts part of Legacy Replacement initiative, as well as NYCERS' ongoing process improvement programs.
RESPONSIBILITIES
Note: Candidates who do not have the mandatory skills will not be considered