Data Engineer III

Northwell Health

New York, NY, United States

3 months ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Compensation

$124,800.0 - $145,600.0

Working hours

Regular working hours

Job source

dejobs.org

Tech stack

Microsoft Excel Application Programming Interfaces (APIs) ASC X12 Standards Data Architecture Data Transmissions Extract Transform Load (ETL) Data Visualization Database Design File Transfer Github JSON Python (Programming Language)

+13 more

Simple Data Format Tableau (Software) Transact-SQL Extensible Markup Language (XML) Parquet Data Import/Export Data Processing Scripting File Transfer Protocol (FTP) Software Troubleshooting Data Representation Information Technology Software Version Control

Job description

FlexStaff is actively seeking a Data Engineer III for our client on a temp to hire remote basis to design, develop, and maintain our organizational data architecture., This pivotal role focuses on T-SQL development, ETL processes, and Python scripting to ensure efficient data transfer, transformation, and integration. Key responsibilities include automating data workflows, supporting diverse file formats (such as flat file, XML, JSON, X12, Excel, and Parquet), and utilizing APIs for seamless data import and export., Job Purpose: Design, develop, and maintain data architecture using T-SQL, ETL, and Python scripting, focusing on automating data workflows, diverse file formats, and API integration., * Utilize advanced T-SQL for database design, optimization, and complex queries.

Design, implement, and optimize ETL processes with Python scripting.
Automate SFTP file transfers and handle various data formats (XML, JSON, X12, Excel, Parquet) using Python.
Integrate with APIs using Python for data import/export.
Collaborate with cross-functional teams, document processes, and use Git/Github for version control.
Integrate Tableau for data representation and reporting.

Requirements

Bachelor’s Degree in Computer Science, Information Technology, or a related field.
Minimum 5 years of hands-on experience in T-SQL development, ETL processes, and Python scripting for data manipulation and automation.
Strong expertise in database design, optimization, SFTP automation, diverse file formats, and API integration with Python.
Proficient in Git and Github.

Preferred Skills: Experience in data visualization using Tableau, strong problem-solving, ability to troubleshoot complex technical issues, and excellent communication skills.

Additional Salary Detail

The salary range and/or hourly rate listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of this job advertisement and may be modified in the future. When determining a team member’s base salary and/or rate, several factors may be considered as applicable (e.g., location, specialty, service line, years of relevant experience, education, credentials, negotiated contracts, budget and internal equity).