Senior Data Engineer – Hybrid (Azure SQL, Databricks)

PSRTEK; Eden Prairie (MN); Hybrid; USD 120,000 - 160,000; Full time

Job summary

PSRTEK in Eden Prairie, MN seeks a Senior Data Engineer to design and optimize cloud-based data solutions using SQL Server, Azure SQL and Databricks. You will build scalable data platforms to support analytics and enterprise reporting.

You will collaborate with data engineers and BI teams, mentor juniors, and implement best practices for data integrity, security, and performance in hybrid work environment.

Qualifications

• Extensive experience with SQL Server and Azure SQL databases.
• Hands-on with Databricks and Spark SQL for large-scale data processing.
• Strong data modeling and warehousing background, including SCD principles.

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 (Apache Spark) to support data transformations and analytics.
• Integrate Azure SQL with Databricks using Delta Lake, Spark SQL, and PySpark/SQL where applicable.
• Design and maintain relational and dimensional data models; implement SCD and other warehousing patterns.
• Support ETL/ELT processes and collaborate with data engineering teams.
• Collaborate with developers, BI teams, and stakeholders; provide mentoring to junior staff.
• Participate in code reviews and root cause analysis for production issues.

Skills

SQL Server

Azure SQL

Databricks

T-SQL

Data modeling

Data warehousing

Performance tuning

Mentoring

Tools

Databricks

Spark SQL

PySpark

Delta Lake

SQL Server Management Studio

Azure SQL Database

Job description

PSRTEK in Eden Prairie, MN seeks a Senior Data Engineer to design and optimize cloud-based data solutions using SQL Server, Azure SQL and Databricks. You will build scalable data platforms to support analytics and enterprise reporting.

You will collaborate with data engineers and BI teams, mentor juniors, and implement best practices for data integrity, security, and performance in hybrid work environment.