EngineerJobs.io
← Back to all jobs

Job Description

Donnelly & Moore Corporation is seeking a Sr. MDM Data Engineer to help design, implement, and support complex data engineering solutions for City agencies. This hybrid role in Brooklyn supports MDM initiatives across Person and Business domains, including integration of multiple data sources and accompanying web services and APIs.

In this position, you will build and coordinate data pipelines and integration services, contribute to analytics tooling, and help ensure security accreditation steps are followed. You will also work with ODS technical leadership and senior engineers to deliver reliable operations and support across downstream platforms.

Responsibilities

  • Support the ODS implementation of the MDM Person and MDM Business domains integrating multiple sources of data plus related web services and APIs
  • Develop and support architectural blueprints leveraging MDM as a foundational service, including unified profiles for use cases such as linking business transactions relevant to a business owner
  • Coordinate the work of senior-level data engineers building pipelines to the MDM and other data platforms, with guidance from ODS Technical Leads
  • Support development of analytics tools using the data pipeline to deliver actionable insights into customer engagement and experience, operational efficiency, and other business performance metrics
  • Review ETL strategies (Extraction, Transformation, Load) for data from a wide variety of sources using SQL, cloud, and big data technologies
  • Create, update, and maintain system documentation
  • Manage the development of APIs for data access or for landing data as output for downstream consumption in appropriate target stores
  • Coordinate appropriate security scan accreditations
  • Perform special projects and initiatives as assigned
  • Develop custom code and services to enable seamless integration between systems
  • Contribute to technology projects as assigned and provide operations and maintenance support for existing applications
  • Unit test newly developed code and support system testing efforts
  • Troubleshoot errors, defects, and other system issues
  • Create and maintain strong documentation including data dictionaries, source-to-target maps, and database policies and guidelines, plus maintain source code repositories
  • Work with the City’s Cyber Command unit to follow and complete the application security accreditation process

Requirements

  • At least 8 years of experience managing development and implementation of large technology projects, including 3+ years involving an MDM implementation
  • At least 8 years of experience writing SQL
  • At least 8 years of experience copying, transferring, manipulating, and automating data operations that were previously manual
  • Experience with tools and components of data architecture such as Informatica Power Center, IICS, SSIS, or similar ETL tools
  • Experience working with Amazon Web Services or Microsoft Azure cloud computing platforms and services
  • In-depth knowledge of SQL and other database solutions
  • Knowledge of modeling database schemas for large datasets
  • Experience developing cloud-ready applications
  • Experience with programming languages including Python, Java, and Perl

Technologies

  • MDM, SQL, Informatica Power Center, IICS, SSIS
  • Amazon Web Services, Microsoft Azure
  • Python, Java, Perl
  • Open Data, ETL, APIs, web services
  • SOAP, RESTful web services
  • Git, GitHub, Subversion
  • Oracle 10g/11g, SQL Server, Oracle, MySQL, RDS, PostgreSQL, Snowflake
  • Java Spring Boot Framework, B2B Data Transformation, 3-tier architecture

Desirable Skills/Experience

  • 5+ years hands-on experience with the suite of tools from 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
  • Experience with application development using Java Spring Boot Framework
  • Extensive knowledge of service-oriented architecture using SOAP and RESTful web services
  • Experience with 3-tier architecture
  • Experience with Oracle, Microsoft SQL Server, MySQL, RDS, PostgreSQL
  • Experience working hands-on in cloud-based platforms such as AWS, Microsoft Azure, and Snowflake is a plus
  • Experience with an agile, iterative development process and version control tools such as Git, GitHub, and Subversion

Work Location and Schedule

  • Location: Brooklyn, NY (hybrid)
  • Work mode: On Site; Hybrid: X; Remote: Monday through Friday
  • Hours: Monday through Friday, 9:00 a.m. to 6:00 p.m.

Assignment Details

  • Projected start date: December 7, 2026
  • Projected end date: December 5, 2027
  • Total estimated assignment hours: 2,080 Hours (1 Year)
  • Schedule notes: Normal business hours, Monday through Friday, 35 hours/week (not including mandatory unpaid meal break after 6 hours of work). If the consultant works more than 40 hours per week, overtime must be requested in the Agency’s timekeeping system and approved by the project manager.

Similar Jobs