Data Integrator with exp in ETL, Automation, data sourcing, integration, modeling at NYC

Job Id : 2391 L3

Duration : 12+ months

Location : Jersey City NJ

Title: Data Integrator with exp in ETL, Automation, data sourcing, integration, modeling at NYC 12+ months cont

Description:

We are a global technology department responsible for the design, development, delivery, and support of the technical solutions behind the products and services used by Our business.

The department is comprised of 10 organizations: Sales, Banking & Corporate-Client Technology, Investment Products & Markets Technology, Client Reporting, Core Processing, Private and International Wealth Management Technology, Technology Integration Office, Enterprise Infrastructure & Production Management, Capital Markets Application & Data Services, Deployment Planning & Release Management, and the Chief Operating Office.

Position Description

ROT Middle office Platforms team is looking for a Data Integrator to help in the upcoming important strategic initiatives for the firm.

Below is the job description. Any additional qualifications beyond below will be considered a plus.

Job Functions/Duties and Responsibilities:

• Any data modeling tool experience is required with a minimum of 4+ years in handling Enterprise level data model.
• Works and thinks independently and is self-motivated, driven and works independently with little guidance.
• Expect to have a very good data sourcing, integration, and modeling skills.
• Programming knowledge is a must to be able to model and integrate data sources.
• Grow and develop diverse engineering team by providing technical and professional guidance.
• Solve complex engineering problems and lead system design and development activities.
• Understand business processes, a bigger picture and core ideas behind the developed software.
• Define engineering guidelines and quality control pipeline; perform code reviews.
• Advocate and advance toward cutting edge engineering practices.
• Apply Agile development best practices and ceremonies.
• Working in the Agile development methodologies, collaborating with business and technology teams located globally.
• Actively contribute and participate in sprint grooming and planning discussions, daily stand-ups, and Agile ceremonies
• Work with various teams and stakeholders across geography and time zone
• Understand and translate business needs into data models supporting strategic solutions.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical, and physical data models along with corresponding metadata.
• Develop ETL solutions and automate systems
• Assist in the stand-up of infrastructure as per the project needs.

Desired Skills:

• Business domain knowledge is a must (Finance/Trading/Margin systems is a plus).
• Working knowledge of RDBMS, Hadoop and Snowflake table design is a plus.