Senior Data Engineer

Posted 2 Days Ago
New York, NY, USA
In-Office
70-80 Hourly
Senior level
Agency • Information Technology • Professional Services • Consulting
The Role
Develop and support complex data engineering solutions, including MDM implementations, ETL pipelines, APIs, cloud-ready applications, database architectures, and analytics tools. Coordinate senior data engineers, integrate multiple data sources, maintain documentation, conduct testing, troubleshoot system issues, support security accreditation, and provide operations and maintenance for data platforms. The role requires extensive SQL, data automation, cloud, database, programming, and ETL experience.
Summary Generated by Built In

Job Title: Senior Data Engineer

Labor Category: Programmer 3

Location: 100% Remote

Scheduled Work Hours: Normal business hours, Monday through Friday, 35 hours/week (not including mandatory unpaid meal break after 6 hours of work)

Job Type: Contract

Duration: 12 Months

Pay Rate: $70 - $80 per hour

SCOPE OF SERVICES

We seeks a Senior Data Engineer role to ensure the efficient and successful implementation and support of complex data engineering solutions for City agencies. This resource should demonstrate a solid understanding of industry-standard implementation methodologies using data integration engineering technologies, tools, and processes.

TASKS:

? Support ODS implement MDM Person and Business domain that will integrate multiple sources of data and accompanying web services and APIs

? Develop and support architectural blueprints that leverage the MDM as a foundational service, among other things, support the creation of unified profiles that can be used for such activities as linking business transactions relevant to a business owner

? With guidance from ODS Technical Leads, coordinate the work of senior-level data engineers tasked with building pipelines to the MDM and other data platforms

? Support the development of analytics tools that utilize the data pipeline to provide actionable insights into customer engagement and experience, operational efficiency, and other key business performance metrics

? Review Extraction, Transformation, Load strategies (ETL) for data from a wide variety of data 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 as output for further downstream consumption in the appropriate target data store

? Coordinate appropriate security scan accreditations

? Perform special projects and initiatives as assigned

? Develop custom code and services that allow seamless integration between systems

? Contribute to new 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 excellent documentation (including data dictionaries, source-to-target maps, and database policies and guidelines) and source code repositories

  • Responsible for working with City’s Cyber Command unit to follow and complete the application security accreditation process

MANDATORY SKILLS/EXPERIENCE Note: Candidates who do not have the mandatory skills will not be considered

  • At least 8 years of experience managing the development and implementation of large technology projects, with at least 3+ years involving an MDM implementation
  • At least 8 years of experience in writing SQL
  • At least 8 years of experience in copying, transferring, manipulating, and automating data operations that were manual processes
  • 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 platform 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 working with programming languages like Python, Java, and Perl

DESIRABLE SKILLS/EXPERIENCE:

  • 5+ years hands-on experience in development 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 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

Skills Required

  • At least 8 years managing development and implementation of large technology projects, including at least 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
  • Experience with Informatica PowerCenter, IICS, SSIS, or similar ETL tools
  • Experience with AWS 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 Python, Java, and Perl
  • At least 5 years of hands-on development 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
  • Experience with Java Spring Boot Framework
  • Knowledge of service-oriented architecture using SOAP and RESTful web services
  • Experience with 3-tier architecture
  • Experience with Oracle, Microsoft SQL Server, MySQL, RDS, or PostgreSQL
  • Experience with AWS, Microsoft Azure, and Snowflake
  • Experience with agile development and version control tools such as Git, GitHub, and Subversion
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Red Bank, NJ
11 Employees
Year Founded: 2015

What We Do

Stratford Solutions Inc. is a minority- and woman-owned small business providing IT consulting, contract staffing, and talent solutions. It builds teams for local, state, and federal government agencies, military organizations, and commercial clients. Its services include temporary, temp-to-perm, direct-hire, staff-augmentation, retained-search, and contract partnership arrangements, supporting technology roles such as software development, architecture, cloud, data, cybersecurity, and quality assurance across diverse industries.

Similar Jobs

SoFi Logo SoFi

Senior Data Engineer

Fintech • Mobile • Software • Financial Services
Easy Apply
Remote or Hybrid
United States
4500 Employees
125K-234K Annually

Pontera Logo Pontera

Senior Data Engineer

Fintech • Software • Financial Services
Hybrid
New York, NY, USA
250 Employees
180K-220K Annually

Cloudflare Logo Cloudflare

Senior Software Engineer

Cloud • Information Technology • Security • Software • Cybersecurity
Hybrid
4 Locations
4400 Employees
185K-231K Annually

The Aerospace Corporation Logo The Aerospace Corporation

Senior Supplier Quality Engineer - Data Analytics

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Remote or Hybrid
2 Locations
4600 Employees
97K-146K Annually

Similar Companies Hiring

Cravath, Swaine & Moore LLP Thumbnail
Legal Tech • Other • Professional Services
New York, NY
1200 Employees
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account