Data Engineer (ETL Developer

Cynosure Technologies LLC
Irving, TX, United States
21 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
6 years minimum
Working hours
Regular working hours
Job source

Tech stack

.NET Framework Adobe InDesign Artificial Intelligence Data Analysis Microsoft Azure C Sharp (Programming Language) Code Review Information Systems Data Cleansing Information Engineering Data Governance Data Integrity
+29 more
Extract Transform Load (ETL) Data Warehousing Relational Databases Database Development Dimensional Modeling Distributed Computing Environment Python (Programming Language) Machine Learning Microsoft SQL Server SQL Azure Performance Tuning Query Optimization Tensorflow Standard Sql Azure Machine Learning SQL Stored Procedures Transact-SQL Cloud Platform System .NET Core Database Optimization Apache Spark Database Performance AngularJS Pyspark Information Technology Optimization Algorithms Data Management Data Pipelines Databricks

Job description

In this role, you will design, develop, and support scalable data and database solutions that enable analytics and innovation across healthcare-focused client initiatives. You will collaborate with cross-functional teams to build modern data pipelines, optimize relational databases, and contribute to cloud-based data platforms. You will apply strong SQL and Python expertise to enhance performance, reliability, and data accessibility while supporting advanced analytics and Artificial Intelligence/Machine Learning (AI/ML) use cases., · Design, build, test, and optimize relational database solutions using SQL Server and Azure SQL, including T-SQL queries, stored procedures, and data models.

· Improve database performance, reliability, and scalability through indexing strategies, query tuning, and optimization techniques.

· Develop and maintain scalable Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes to integrate data across cloud-based platforms.

· Build and support data pipelines and workflows using Azure SQL, Databricks, Apache Spark, Python, and PySpark.

· Design and implement relational and dimensional data models, including Slowly Changing Dimension (SCD) patterns.

· Support AI/ML initiatives by developing and maintaining data pipelines and feature datasets used for model training and analytics.

· Utilize Python to enable data preparation, analytics workflows, and experimentation for machine learning use cases.

· Collaborate with data science teams to operationalize models using Spark, ML frameworks, or cloud-based ML services.

· Participate in design discussions, code reviews, and Agile ceremonies to ensure high-quality and maintainable solutions.

· Partner with application developers, data engineers, BI teams, and analytics partners to deliver integrated solutions.

· Troubleshoot production issues, conduct root cause analysis, and implement sustainable resolutions.

· Adhere to data governance, security, and quality standards to ensure compliance and data integrity.

Requirements

· Relevant degree preferred. Bachelor’s degree in Computer Science, Information Systems, or a related field preferred.

· 7+ years of relevant experience required.

· Experience developing and supporting database solutions using SQL Server or Azure SQL required.

· Strong proficiency in T-SQL, including query development, performance tuning, and optimization required.

· Hands-on experience using Python for data processing, analytics, or data engineering workflows required.

· Experience with Databricks, Apache Spark, or similar distributed data processing platforms required.

· Understanding of data warehousing concepts, dimensional modeling, and ETL/ELT pipelines required.

· Experience working in Azure cloud environments required.

· Experience with .Net, C#, .Net Core, Angular and AI/ML preferred.

· Strong analytical, problem-solving, and written and verbal communication skills.

· You must be authorized to work in the United States without sponsorship now and in the future.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

5:46 min

Evolution of the Angular framework from AngularJS

Valentine Awe · WWC 2023

4:32 min

Harnessing Spark with Python using PySpark and Py4J

Ayon Roy · LIVE

3:27 min

Preventing command injection during system process execution

Sebastian Leuer Sebastian Leuer · WWC 2024

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

1:52 min

Maintaining backward compatibility across major versions

Jessica Janiuk · JS Congress

Videos

See all

Related articles

See all