SR Data Engineer

Alliance Technical Group; Atlanta (GA); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical, Dental, and Vision Insurance

Flexible Spending Accounts

401(K) Plan with Competitive Match

Continuing Education and Tuition Assistance

Employer-Sponsored Disability Benefits

Life Insurance

Employee Assistance Program

Paid Time Off (PTO)

Profit Sharing or Individual Bonus Programs

Employee Discount Hub

Referral Program

Per Diem Travel

Employee Discount

Job summary

A leading technology firm is seeking an experienced Senior Data Engineer to optimize databases and data systems for business intelligence. This role involves creating scalable pipelines and cloud-based architectures, implementing new databases, and ensuring data quality and compliance. The ideal candidate has over 10 years of experience with relational databases, particularly in PostgreSQL and Snowflake, and possesses strong troubleshooting skills. Remote work is an option for candidates within 60 miles of the office. Competitive benefits are offered.

Qualifications

• 10+ years of hands-on experience with relational databases.
• Experience in designing and implementing new database systems.

Responsibilities

• Architect and implement new databases and data platforms.
• Build and maintain scalable ELT/ETL pipelines.
• Manage and optimize database environments.
• Implement automation and workflow orchestrations.
• Ensure data quality and compliance.
• Collaborate with cross-functional teams.
• Troubleshoot complex issues.
• Mentor junior data engineers.

Skills

PostgreSQL

Snowflake

dbt

Cloud architecture

Workflow orchestration

Git-based version control

Python

Data visualization principles

Data quality

Cross-functional teamwork

Education

Bachelor's degree in Computer Science or related field

Tools

dbt

Git

Job description

Summary/Objective

Alliance Technical Group is seeking an experienced Senior Data Engineer to design, build, and optimize the databases and data systems that power our business intelligence and analytics platforms. In this role, you will lead the creation of scalable pipelines, data models, and cloud-based architecture that ensures reliable, high-quality data across the organization. You will architect and implement new database solutions, drive migration and optimization efforts in PostgreSQL and Snowflake, and advance data governance initiatives. Working in an agile, cross-functional environment, you will translate business needs into scalable solutions while ensuring security, integrity, and performance. This role is ideal for someone who thrives on building data platforms from the ground up and shaping enterprise data strategy.

This position is remote but may follow a hybrid schedule for candidates located within 60 miles of an Alliance office.

Essential Functions

• Architect and implement new databases and data platforms to meet business and technical requirements
• Build and maintain scalable ELT/ETL pipelines and data models for analytics and reporting
• Manage and optimize database environments, including provisioning, performance tuning, and access controls
• Implement and manage automation and workflow orchestrations for reliable, repeatable deployments
• Ensure data quality, consistency, and compliance through robust validation and monitoring practices
• Collaborate with cross‑functional teams to define technical requirements, estimate development efforts, and deliver business‑aligned solutions
• Troubleshoot complex issues, recommend improvements, and maintain clear documentation of data systems, processes, and solutions proposed/implemented
• Mentor junior data engineers, providing technical guidance, code reviews, and best practices

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience)
• 10+ years of hands‑on experience with relational databases, including designing and implementing new database systems

Knowledge, Skills, & Abilities

• Proven experience designing and building new databases and large‑scale data systems, particularly in PostgreSQL and Snowflake; hands‑on experience with dbt
• Demonstrated ability to develop and optimize ELT/ETL pipelines for complex data sets
• Experience with cloud architecture, workflow orchestration, and Git‑based version control
• Knowledge of data governance, data quality, and validation practices
• Strong troubleshooting and root‑cause analysis skills
• Excellent communication skills and experience working in agile, cross‑functional teams
• Working knowledge of Python preferred, familiarity with data visualization principles a plus

Work Environment

While performing the duties of this job, the employee regularly works in an office setting with constant sitting and occasional standing.

Physical Demands

Prolonged periods of sitting or standing at a desk while using a computer.

Travel

Not Applicable

Other Duties

Please note this job description is intended to describe the general nature and level of work performed by employees assigned to this position. It is not designed to contain or be interpreted as a comprehensive list of all duties, responsibilities, and qualifications. Additional job‑related duties may be assigned. Alliance reserves the right to amend and change responsibilities to meet business and organizational needs as necessary with or without notice.

Employee Benefits: Key Benefits Include

• Medical, Dental, and Vision Insurance
• Flexible Spending Accounts
• 401(K) Plan with Competitive Match
• Continuing Education and Tuition Assistance
• Employer‑Sponsored Disability Benefits
• Life Insurance
• Employee Assistance Program (EAP)
• Paid Time Off (PTO), Paid Holidays, & Bonus Floating Holiday (if hired before July 1st)
• Profit Sharing or Individual Bonus Programs
• Referral Program
• Per Diem & Paid Travel
• Employee Discount Hub

Salary based upon experience.

EEO Commitment

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, national origin, ethnicity, sex, pregnancy, sexual orientation, gender identity/expression, including transgender identity, religion, disability, age, genetics, active military or veteran status and any other characteristics protected under applicable federal or state law.