Data Engineer

TechDigital Group; Nashville (TN); On-site; USD 90,000 - 120,000; Full time

Job summary

A tech consultancy in Nashville is seeking an experienced Senior Data Engineering Consultant to design and optimize enterprise data solutions. The role requires strong expertise in PostgreSQL, SQL Server, and ETL/ELT frameworks, alongside Master Data Management tools. Responsibilities include developing data pipelines, ensuring data quality, and collaborating with cross-functional teams. If you have excellent troubleshooting skills and a passion for reliable data systems, this opportunity may be for you.

Qualifications

• Proficiency in PostgreSQL and SQL Server.
• Strong experience in ETL/ELT frameworks.
• Hands-on experience with Ataccama or other MDM tools.

Responsibilities

• Design and implement robust data pipelines using ETL/ELT frameworks.
• Develop and optimize queries for PostgreSQL and SQL Server databases.
• Integrate and manage Master Data Management solutions.
• Perform data profiling and ensure data quality management.
• Implement testing, monitoring, and alerting for data integrity checks.
• Collaborate with cross-functional teams to define data architecture.
• Troubleshoot and resolve performance issues related to data.

Skills

PostgreSQL

SQL Server

ETL/ELT Frameworks

Ataccama or other MDM

Job description

Mandatory Skills: PostgreSQL, SQL Server, ETL/ELT Frameworks, Ataccama or other MDM

Senior Data Engineering Consultant

Role Overview: We are seeking an experienced Senior Data Engineering Consultant to design, develop, and optimize enterprise data solutions. The ideal candidate will have strong expertise in database technologies, ETL/ELT frameworks, and Master Data Management (MDM) tools, with a focus on delivering high-quality, reliable, and scalable data systems.

Key Responsibilities:

• Design and implement robust data pipelines using ETL/ELT frameworks.
• Develop and optimize queries for PostgreSQL and SQL Server databases.
• Integrate and manage Master Data Management solutions (preferably Ataccama or similar).
• Perform data profiling and ensure data quality management across systems.
• Implement automated testing, monitoring, and alerting for data comparisons and integrity checks.
• Collaborate with cross-functional teams to define data architecture and governance standards.
• Troubleshoot and resolve performance issues related to data processing and storage.

Primary Skills:

• Proficiency in PostgreSQL and SQL Server
• Strong experience in ETL/ELT frameworks
• Hands-on experience with Ataccama or other MDM tools

Preferred Skills:

• Data Profiling and Data Quality Management
• Query Optimization techniques