Senior Data Engineer: Databricks, SQL, & Cloud Pipelines

Groundswell Corporation; Virginia (IL); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical benefits (health)

Dental benefits

Vision benefits

FSA 4%

401K Match

Paid Time Off

Tuition reimbursement

Professional development

Flexible schedule

On-site gym

Childcare option

Job summary

Groundswell Corporation seeks an experienced Data Engineer to design scalable Databricks pipelines and manage enterprise databases. You will implement ETL/ELT processes, optimize SQL, and ensure security and recovery across SQL Server and MariaDB environments.

You will collaborate with stakeholders, translate requirements into robust data solutions, and drive best practices in data modeling, governance, and performance tuning.

Qualifications

• Bachelor's degree in Computer Science, Computer Engineering, Mathematics, Statistics, or a related technical field.
• 5+ years of experience in data engineering, database administration, or database development.
• Demonstrated hands-on Databricks experience.
• Experience administering SQL Server and/or MariaDB enterprise databases.
• Advanced SQL skills, including developing and optimizing queries, stored procedures, functions, triggers, tables, and views.
• Proficiency in Python, Java, or Scala.
• Experience developing ETL/ELT pipelines using tools such as Apache Airflow, AWS Glue, or similar technologies.
• Experience with database performance tuning, backup and restoration, disaster recovery, security, and access management.
• Strong stakeholder engagement, communication, collaboration, and problem-solving skills.
• Demonstrated experience leading or providing technical direction to engineering teams.
• U.S. citizenship and the ability to obtain and maintain a federal Public Trust per contract requirements.

Responsibilities

• Design and implement scalable Databricks solutions and ETL/ELT pipelines.
• Apply Databricks development standards and data engineering best practices.
• Administer and monitor enterprise MariaDB and SQL Server environments.
• Design databases, schemas, tables, views, stored procedures, functions, and triggers.
• Perform database configuration, backup, restoration, performance tuning, and disaster recovery.
• Optimize SQL queries, indexes, database objects, pipelines, and server performance.
• Configure and support availability groups, mirroring, clusters, encryption, and reporting servers.
• Apply best practices for data modeling, relational database design, data warehousing, data quality, and lineage.
• Implement database security, auditing, user access, roles, permissions, and domain-level accounts.
• Troubleshoot complex database, application, and data pipeline issues.
• Collaborate with business stakeholders, infrastructure, network, application, development, and vendor teams.
• Translate business and technical requirements into secure, scalable data solutions.
• Deliver technical demonstrations and training and support proposal efforts.

Skills

Databricks

SQL

Python/Java/Scala

ETL/ELT pipelines

Data modeling

Data warehousing

Security & access management

Stakeholder communication

Education

Bachelor's degree in Computer Science/Engineering/Math/Stats

Tools

Databricks

SQL Server

MariaDB

Airflow

AWS Glue

Tableau

Job description

Groundswell Corporation seeks an experienced Data Engineer to design scalable Databricks pipelines and manage enterprise databases. You will implement ETL/ELT processes, optimize SQL, and ensure security and recovery across SQL Server and MariaDB environments.

You will collaborate with stakeholders, translate requirements into robust data solutions, and drive best practices in data modeling, governance, and performance tuning.