Icon hamburger
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply Now

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.

ETL Developer - Contract - NYC

Jefferson Frank New York Contractor
$80.00 - $100.00 / hour
Apply Now

The successful ETL Developer will focus on ensuring the successful implementation of the client's data warehouse, Business Intelligence and PASSPort solutions. The ETL Developer will make sure strategy aligns with the enterprise data management and analytics architecture resources (including master data management, metadata management, data quality, data warehousing, data integration, enterprise data model, business intelligence, analysis, & reporting, diagnostic and predictive analytics, data virtualization, and change data capture). This role needs a detailed-oriented, hands-on person who will work closely with different teams on the analysis and design of database and system solutions.


  • Collaborate with the other members of the integration team in the design, implementation and documentation of solutions for daily issues/support, release management, and new projects
  • Assist in architecting, mapping, developing, and testing data movement to data warehouses (Redshift and others), with emphasis on the ETL process
  • Development of ETL source and target mapping design/specifications and other artifacts based on the business requirements and ETL standards and architecture
  • Develop, document, and execute SQL/stored procedures/server scripts as needed to support ETL code
  • Determine ETL requirements and assist with production, setup, and execution of migrations
  • Work closely with BI and PASSPort teams on ETL development efforts including analysis and design of integration solutions, data and reporting needs of internal and external stakeholders, and enhancements
  • Develop and document interfaces with external systems that exchange data with internal systems
  • Identify and resolve data, technical issues and mediate business impact
  • Track, analyze and resolve tickets entered through Remedy


The successful candidate should possess the following:

  • Excellent writing and communication skills
  • Ability to interact with all levels of management and public
  • Extensive experience with ETL methodology, procedures, development and testing
  • Strong knowledge and extensive experience with python (Pandas packages in particular)
  • Familiar with AWS ecosystem including S3, Redshift databases, Lambda, EC2 and necessary supporting activities
  • Expertise with integration technologies and processes, enterprise data warehouse implementations and integration tools (SSIS, Glue), integrating multiple legacy systems
  • Ability to write complex procedures using SQL / T-SQL
  • Knowledge of XML technologies (i.e. XML, XSL, XSD, SOAP, REST)
  • Experience in object-oriented languages (i.e. Java, C#, etc.)
  • Experience in scripting languages (i.e. VBA, PowerShell, etc.)
  • Knowledge of testing tools and techniques and executing test scripts to test performance of ETL procedures
  • Significant experience in development, maintenance, and enhancements of ETL Mappings, Work-flows, and processes
  • Knowledgeable in several multi-dimensional and data mining techniques such as EDW, ODS, DM, ROLAP and MOLAP
  • Excellent analytical, organization, presentation and facilitation skills; ability to handle multiple tasks under tight deadlines
  • Working knowledge of database back-end systems, including SQL Server 2008 R2 / 2012, Oracle, and AWS.
  • Strong written, verbal and interpersonal skills
  • Past utilization of code repositories including, GitHub, Bitbucket, or GitLab Knowledgeable in several multi-dimensional and data mining techniques such as EDW, ODS, DM, ROLAP and MOLAP


Recommended skills

Data Warehousing
Meta Data Management
Extract Transform Load (Etl)
Data Quality
Data Mining
Apply to this job.
Think you're the perfect candidate?
Apply Now

Help us improve CareerBuilder by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

Job ID: JFI030719PS1


For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.