Sr. Data Engineer with strong SQL and Databricks experience

TekShapers; Irving (TX); Hybrid; USD 96,000 - 152,000; Part time

Benefits offered by this job

Hybrid work schedule

Job summary

Tekshapers in Irving, TX is seeking a Senior Data Engineer with strong SQL Server, Azure SQL, and Databricks experience. You will design, optimize, and deliver scalable cloud-based data solutions supporting analytics and enterprise data platforms.

The role involves leading database development, tuning, data modeling, and integration with Databricks. Hybrid work (3 days in office) and contract terms provide a dynamic environment for seasoned data professionals.

Qualifications

• Senior data engineer with deep expertise in SQL Server and Azure SQL.
• Experience in Databricks (Apache Spark) for large-scale data processing.
• Proven ability to design scalable cloud-based data solutions.

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.
• Develop and manage data solutions in Azure SQL Database.
• Work with Databricks to support data transformations, analytics, and large-scale 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.
• 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.
• Partner with developers, BI teams, and stakeholders to understand data requirements; provide guidance and mentoring.
• Participate in code reviews and enforce database development standards.
• Troubleshoot production issues and provide root cause analysis.

Skills

SQL

Data modeling

Data warehousing

Tools

SQL Server

Azure SQL

Databricks

Delta Lake

Spark SQL

PySpark

Job description

Role : Sr. Data Engineer with strong SQL and Databricks experience
Location : Irving, TX (Hybrid -- 3 days' Work from Office)
Type : Contract

Client Interview -- in-person in Irving, TX.
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

1. Database Development & Optimization: Design, develop, and maintain complex SQL Server and Azure SQL databases.
2. Write and optimize advanced T-SQL queries, stored procedures, functions, and views.
3. Perform query tuning, indexing strategies, and performance optimization for large-scale datasets.
4. Implement best practices for database security, data integrity, and reliability.
5. Cloud & Data Platform: Develop and manage data solutions in Azure SQL Database.
6. Work with Databricks (Apache Spark) to support data transformations, analytics, and largescale data processing.
7. Integrate Azure SQL with Databricks using Delta Lake, Spark SQL, and PySpark/SQL where applicable.
8. Support cloud-based data architectures and hybrid data environments.
9. Data Modelling & Warehousing: Design and maintain relational and dimensional data models.
10. Implement Slowly Changing Dimensions (SCD) and other data warehousing patterns.
11. Support ETL/ELT processes and collaborate with data engineering teams.
12. Collaboration & Leadership: Partner with application developers, data engineers, BI teams, and stakeholders to understand data requirements.
13. Provide guidance and mentoring to junior developers.
14. Participate in code reviews and enforce database development standards.
15. Troubleshoot production issues and provide root cause analysis.

Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.