Data Engineer

Esvee Technologies Inc

Chicago, IL, United States

12 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Big Data Cloud Computing Cloud Database Databases Information Engineering Data Infrastructure Data Integrity Extract Transform Load (ETL) Data Transformation Data Systems Data Warehousing Database Development

+14 more

Dimensional Modeling Apache Hive Microsoft SQL Server SQL Azure Performance Tuning Query Optimization SQL Stored Procedures SQL Databases Data Processing Cloud Platform System Database Optimization Apache Spark Pyspark Databricks

Job description

Database Development & Optimization:Design, develop, and maintain complex SQL Server and Azure SQL databases.
Write and optimize advancedT-SQLqueries, stored procedures, functions, and views.
Performquery tuning, indexing strategies, and performance optimizationfor large-scale datasets.
Implement best practices fordatabase security, data integrity, and reliability.
Cloud & Data Platform: Develop and manage data solutions inAzure SQL Database.
Work withDatabricks (Apache Spark)to support data transformations, analytics, and largescale data processing.
Integrate Azure SQL with Databricks usingDelta Lake, Spark SQL, and PySpark/SQLwhere applicable.
Support cloud-based data architectures and hybrid data environments.
Data Modelling & Warehousing:Design and maintain relational and dimensional data models.
ImplementSlowly Changing Dimensions (SCD)and other data warehousing patterns.
Support ETL/ELT processes and collaborate with data engineering teams.
Collaboration & Leadership:Partner with application developers, data engineers, BI teams, and stakeholders to understand data requirements.

Requirements

10+ yearsof experience as a Database Developer or similar role.
Strong expertise inSQL Server and Azure SQL.
Advanced proficiency inT-SQL, including performance tuning and query optimization.
Hands-on experience withDatabricksand Apache Spark.
Solid understanding ofdata warehousing concepts, dimensional modelling, and SCD.
Experience working inAzure cloud environments.
Strong analytical, problem-solving, and communication skills.