Search

Senior Data Engineer

PublishedPublished: 6/14/2022
Technology
|

Job Description

Job Description

Job Title: Senior Data Engineer

\n

Labor Category: Programmer 3

\n

Location: 100% Remote

\n

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

\n

Job Type: Contract

\n

Duration: 12 Months

\n

Pay Rate: $70 - $80 per hour

\n

SCOPE OF SERVICES

\n

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.

\n

TASKS:

\n

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

\n

? 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

\n

? 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

\n

? 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

\n

? Review Extraction, Transformation, Load strategies (ETL) for data from a wide variety of data sources using SQL, cloud, and ‘big data' technologies

\n

? Create, update, and maintain system documentation

\n

? Manage the development of APIs, for data access or landing data as output for further downstream consumption in the appropriate target data store

\n

? Coordinate appropriate security scan accreditations

\n

? Perform special projects and initiatives as assigned

\n

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

\n

? Contribute to new technology projects as assigned and provide operations and maintenance support for existing applications

\n

? Unit test newly developed code and support system testing efforts

\n

? Troubleshoot errors, defects, and other system issues

\n

? Create and maintain excellent documentation (including data dictionaries, source-to-target maps, and database policies and guidelines) and source code repositories

\n

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

\n

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

\n

    \n
  • At least 8 years of experience managing the development and implementation of large technology projects, with at least 3+ years involving an MDM implementation
  • \n

  • At least 8 years of experience in writing SQL
  • \n

  • At least 8 years of experience in copying, transferring, manipulating, and automating data operations that were manual processes
  • \n

  • Experience with tools and components of data architecture such as Informatica Power Center, IICS, SSIS, or similar ETL tools
  • \n

  • Experience working with Amazon Web Services or Microsoft Azure cloud computing platform and services
  • \n

  • In-depth knowledge of SQL and other database solutions
  • \n

  • Knowledge of modeling database schemas for large datasets
  • \n

  • Experience developing cloud-ready applications
  • \n

  • Experience working with programming languages like Python, Java, and Perl
  • \n

\n

DESIRABLE SKILLS/EXPERIENCE:

\n

    \n
  • 5+ years hands-on experience in development with the suite of tools from Informatica PowerCenter and B2B Data Transformation
  • \n

  • Experience using Oracle 10g/11g, SQL Server and/or a database appliance
  • \n

  • Knowledge of metadata-driven enterprise reporting platforms
  • \n

  • Experience with application development using Java Spring Boot Framework
  • \n

  • Extensive knowledge of service-oriented architecture using SOAP and RESTful web services
  • \n

  • Experience with 3-tier architecture
  • \n

  • Experience with Oracle, Microsoft SQL Server, MySQL, RDS, PostgreSQL
  • \n

  • Experience working hands-on in cloud-based platforms such as AWS, Microsoft Azure, and Snowflake is a plus
  • \n

  • Experience with an agile, iterative development process and version control tools such as Git, GitHub, and Subversion
  • \n

\n

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...