Senior Data Solution and Delivery Engineer -SDSDE24-02258

Position Title: Senior Data Solution and Delivery Engineer Location: 2 MTC Brooklyn Duration: 1 Year Job Description: As a Senior Data Solution and Delivery Engineer with our client, you will be instrumental in ensuring the efficient and successful implementation and support of complex data engineering solutions for City agencies.
This role involves analyzing data to enhance City agency operations, making Open Data more accessible, and advancing citywide data infrastructure, integration, and sharing.
Tasks: Support ODA in implementing a new MDM Business Domain integrating multiple data sources and associated web services and APIs.
Develop architectural blueprints leveraging MDM as a foundational service for MyCity, facilitating the creation of unified profiles for linking relevant business transactions.
Coordinate the work of senior-level data engineers in building pipelines to MDM and selected ODA data platforms.
Aid in developing analytics tools utilizing data pipelines to provide actionable insights into customer engagement, operational efficiency, and key business performance metrics.
Review Extraction, Transformation, Load strategies (ETL) for data from various sources using SQL, cloud, and 'big data' technologies.
Create, update, and maintain system documentation.
Manage the development of APIs for data access or landing data for further downstream consumption.
Coordinate appropriate security scan accreditations.
Perform special projects and initiatives as assigned.
Mandatory Skills/Experience: Minimum 8 years managing large technology projects, with at least 3 years involving MDM implementation.
8+ years of SQL experience.
8+ years of experience automating data operations and manipulating data.
Experience with data architecture tools like Informatica Power Center, IICS, SSIS, or similar ETL tools.
Familiarity with Amazon Web Services or Microsoft Azure.
In-depth knowledge of SQL and other database solutions.
Experience developing cloud-ready applications.
Proficiency in programming languages like Python, Java, and Perl.
Desirable Skills/Experience: 5+ years hands-on experience with Informatica PowerCenter and B2B Data Transformation.
Experience with Oracle 10g/11g, SQL Server, and/or a database appliance.
Knowledge of metadata-driven enterprise reporting platforms.
Special Requirements: Strong hands-on experience with MDM implementation serving a large enterprise.
Prior experience working on complex data integration projects for the City of New York.