Sr. Data Engineer (ADF / SQL / Databricks)

Talentola; Eden Prairie (MN); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Talentola in Eden Prairie, MN is seeking a Senior Data Engineer to design, optimize, and deliver scalable cloud-based data solutions supporting analytics and enterprise data platforms.

You will work with SQL Server, Azure SQL, and Databricks, implementing data warehousing patterns, SCD, and modern ETL/ELT processes in Azure cloud. The role requires strong collaboration and mentoring capabilities.

Qualifications

• 8+ years of experience in a Database Developer or related role.
• Strong expertise in SQL Server and Azure SQL.
• Advanced proficiency in T-SQL with performance tuning.
• Hands-on experience with Databricks and Apache Spark.
• Understanding of data warehousing concepts, dimensional modelling, and SCD.
• Experience in Azure cloud environments.

Responsibilities

• Design, develop, and maintain complex SQL Server and Azure SQL databases.
• Write and optimize advanced T-SQL queries, stored procedures, functions, and views.
• Perform query tuning, indexing strategies, and performance optimization for large-scale datasets.
• Implement best practices for database security, data integrity, and reliability.
• Develop and manage data solutions in Azure SQL Database.
• Work with Databricks to support data transformations, analytics, and large-scale processing.
• Integrate Azure SQL with Databricks using Delta Lake, Spark SQL, and PySpark/SQL.
• Support cloud-based data architectures and hybrid data environments.
• Design and maintain relational and dimensional data models.
• Implement Slowly Changing Dimensions and other warehousing patterns.
• Support ETL/ELT processes and collaborate with data teams.
• Collaborate with developers, BI teams, and stakeholders; provide mentoring and code reviews.
• Troubleshoot production issues and provide root cause analysis.

Skills

SQL Server

Azure SQL

T-SQL

Databricks

Apache Spark

Data warehousing

SCD

Azure Cloud

Analytical skills

Communication

Education

Engineering Degree BE/ME/BTech/MTech/BSc/MSc

Tools

Delta Lake

Spark SQL

PySpark/SQL

Job description

Seeking a Senior Data Engineer with deep expertise in SQL Server, Azure SQL, and Databricks to design, optimize, and deliver scalable cloud-based data solutions supporting analytics and enterprise data platforms

Roles and Responsibilities

Database Development & Optimization: Design, develop, and maintain complex SQL Server and Azure SQL databases.

Write and optimize advanced T-SQL queries, stored procedures, functions, and views.

Perform query tuning, indexing strategies, and performance optimization for large-scale datasets.

Implement best practices for database security, data integrity, and reliability.

Cloud & Data Platform: Develop and manage data solutions in Azure SQL Database.

Work with Databricks (Apache Spark) to support data transformations, analytics, and largescale data processing.

Integrate Azure SQL with Databricks using Delta Lake, Spark SQL, and PySpark/SQL where applicable.

Support cloud-based data architectures and hybrid data environments.

Data Modelling & Warehousing: Design and maintain relational and dimensional data models.

Implement Slowly 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.

Provide guidance and mentoring to junior developers.

Participate in code reviews and enforce database development standards.

Troubleshoot production issues and provide root cause analysis.

Experience: -

8+ Years

Location: -

Eden Prairie, MN (Hybrid 3 days' Work from Office)

Duration: -

Contract role with CitiusTech

Educational Qualifications: -

Engineering Degree BE/ME/BTech/MTech/BSc/MSc.

Technical certification in multiple technologies is desirable.

Skills: -

Mandatory skills

10+ years of experience as a Database Developer or similar role.

Strong expertise in SQL Server and Azure SQL.

Advanced proficiency in T-SQL, including performance tuning and query optimization.

Hands-on experience with Databricks and Apache Spark.

Solid understanding of data warehousing concepts, dimensional modelling, and SCD.

Experience working in Azure cloud environments.

Strong analytical, problem-solving, and communication skills.

Client Interview in-person in Eden Prairie, MN.