Sr. MDM Data Engineer
Job Description
Donnelly & Moore Corporation is seeking a senior data engineering professional to support the efficient implementation and ongoing support of complex data engineering solutions for City agencies, including MDM Person and Business domains. The role focuses on building and coordinating data pipelines, APIs, analytics tooling, documentation, testing, troubleshooting, and security accreditation coordination.
Key Responsibilities
- Support the ODS implementation of MDM Person and MDM Business domains that integrate multiple data sources along with supporting web services and APIs.
- Develop and support architectural blueprints that position MDM as a foundational service, including the creation of unified profiles used for activities such as linking business transactions relevant to a business owner.
- Under the guidance of ODS Technical Leads, coordinate the work of senior-level data engineers building pipelines to the MDM and other data platforms.
- Support development of analytics tools that use the data pipeline to deliver actionable insights related to customer engagement and experience, operational efficiency, and other key business performance metrics.
- Review ETL strategies for data ingestion from a wide variety of sources using SQL, cloud, and other big data technologies.
- Create, update, and maintain system documentation.
- Manage API development for data access or for producing landing data for downstream consumption in the appropriate target data store.
- Coordinate security scan-related accreditations.
- Perform special projects and initiatives as assigned.
- Develop custom code and services to enable seamless integration between systems.
- Contribute to new technology projects as assigned, including operations and maintenance support for existing applications.
- Unit test newly developed code and support system testing efforts.
- Troubleshoot errors, defects, and other system issues.
- Maintain strong documentation, including data dictionaries, source-to-target maps, and database policies and guidelines, along with source code repositories.
- Work with the City’s Cyber Command unit to follow and complete the application security accreditation process.
Required Qualifications
- At least 8 years of experience managing the 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 processes.
- Experience with data architecture tools such as Informatica Power Center, IICS, SSIS, or similar ETL tools.
- Experience working with Amazon Web Services or Microsoft Azure.
- In-depth knowledge of SQL and other database solutions.
- Knowledge of modeling database schemas for large datasets.
- Experience developing cloud-ready applications.
- Experience using programming languages such as 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 and Experience
- 5+ years hands-on experience developing with the suite of tools from Informatica PowerCenter and B2B Data Transformation.
- Experience using Oracle 10g/11g, SQL Server and/or a database appliance.
- Knowledge of metadata-driven enterprise reporting platforms.
- Experience with application development using the 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.
- Hands-on experience with cloud-based platforms such as AWS, Microsoft Azure, and Snowflake.
- Experience with agile, iterative development processes and version control tools such as Git, GitHub, and Subversion.
Work Location and Schedule
- Location: Brooklyn, NY (Hybrid)
- Work location options listed: On Site; Hybrid: X; Remote (Monday through Friday; 9:00 a.m. to 6:00 p.m.)
- Work hours: Normal business hours, Monday through Friday, 35 hours/week (not including mandatory unpaid meal break after 6 hours of work).
Assignment Details
- Projected start date: December 7, 2026
- Projected end date: December 5, 2027
- Total estimated assignment hours: 2,080 Hours (1 Year)
Notes on Business Hours and Overtime
- Normal business hours are Monday through Friday (not including a mandatory unpaid meal break after 6 hours of work), with 40 work hours per week.
- 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.