Data Engineer
Job ID: 110377
Location: Tulsa, OK [Remote]
Salary: $60.00 - $70.00
Category: App/Dev
Employment Type: Contract
Our client is seeking a highly skilled Data Engineer to join their Enterprise Data Services Team for a 6-month contract, with the possibility of extension or conversion to permanent status. This role is pivotal in supporting their dynamic ETL processes and data integration projects. While this position allows for remote work, priority will be given to candidates who are local to Tulsa. The successful candidate will bring a robust background in data engineering, with a strong preference for those experienced in Azure DevOps, SSIS, and SQL Server environments.
Responsibilities:
- Develop, maintain, and optimize ETL processes using SSIS and ensure their alignment with business requirements.
- Utilize Azure DevOps and Git for version control and collaboration in a team setting.
- Advanced scripting and query optimization in SQL for SQL Server 2019 platforms to manage and analyze data effectively.
- Maintain and debug existing codebases in Visual Studio with C#, focusing on enhancing functionality and performance.
- Design and implement solutions for data ingestion from diverse sources including fixed width files, sub-record type files, CSV files, and databases like Oracle.
- Engage with Kafka for data streaming processes, where applicable, to enhance real-time data processing capabilities.
- Support the maintenance of an on-premises type2 historical database environment, utilizing change-data-capture technology.
Qualifications:
- Minimum of 8 years’ experience in data engineering or a related field.
- Proven expertise in Azure DevOps and Git is essential.
- Strong proficiency in SQL, with extensive experience using SQL Server 2019.
- Experience in Visual Studio and C# for software development and maintenance.
- Demonstrable knowledge of SSIS for ETL development and data integration tasks.
- Familiarity with various data file types and databases (Oracle, Kafka experience is a plus but not required).
- Ability to work remotely or on-site in Tulsa, with a preference for local candidates.
- Excellent problem-solving skills and the ability to work independently or as part of a team.
- Strong communication skills and the ability to collaborate effectively with cross-functional teams.