Sr. Data Engineer (Databricks / SQL / ADF) at Eden Prairie, MN

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

Position Title: Sr. Data Engineer

Work Mode: Hybrid 3 days WFO (Tues, Wed and Thurs)

Location: Eden Prairie, MN need to work from office from day 1

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.