Principal Consultant, Data Engineer

Jobtailor; Dallas (TX); On-site; USD 110,000 - 170,000; Full time

Job summary

Jobtailor in Dallas, TX is seeking an experienced Data Engineer to design and maintain scalable data pipelines and analytics platforms. You’ll transform raw data with ETL/ELT processes and partner with clients to ensure high data quality and actionable insights.

You'll work with cloud-native tools such as Azure Data Factory, AWS Glue, Snowflake, and Databricks, building data models and dashboards using Power BI or Tableau.

Qualifications

• 5+ years in data engineering, analytics, or related technical role.
• Proficiency in SQL and scripting (Python or similar).
• Hands-on ETL/ELT with Azure Data Factory, AWS Glue, Snowflake, or Databricks.
• Experience with cloud environments (AWS, Azure, Palantir Foundry).
• Knowledge of data modeling concepts and data quality.
• Understanding of data integration, performance tuning, and data reliability.
• Ability to collaborate on fast-paced projects with stakeholders.
• Strong problem-solving and communication skills.
• Bachelor's degree in a related field; eligible to work in the US without sponsorship.
• Experience with Power BI or Tableau is a bonus; certifications are a plus.

Responsibilities

• Build and maintain scalable data pipelines using cloud data platforms.
• Develop ETL/ELT processes to prepare data for reporting and analytics.
• Collaborate with team and clients to gather requirements and ensure data quality.
• Assist in developing data models and cloud-based data platforms (Snowflake, Databricks, Redshift).
• Support dashboards and visualizations using Power BI or Tableau.
• Participate in testing, documentation, and deployment of data solutions.
• Engage with project workstreams and client delivery best practices.
• Learn and apply modern data engineering practices across industries.

Skills

SQL Proficiency

Python Scripting

ETL/ELT Processes

Data Modeling

Data Integration

Performance Tuning

Cloud Environments

Data Quality

Stakeholder Collaboration

Problem Solving

Education

Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field

Tools

Azure Data Factory

AWS Glue

Snowflake

Databricks

Power BI

Tableau

Apache Airflow

dbt

Palantir Foundry

Redshift

Job description

• Build and maintain scalable, reliable data pipelines using Azure Data Factory, AWS Glue, or Palantir Foundry
• Develop ETL/ELT processes to transform and prepare raw data for reporting, analytics, and downstream applications
• Collaborate with team members and clients to gather requirements, integrate data sources, and ensure high data quality
• Assist in developing and optimizing data models and cloud-based data platforms such as Snowflake, Databricks, and Redshift
• Support creation of dashboards and data visualizations using Power BI or Tableau
• Participate in testing, documentation, and deployment of data solutions to ensure performance and reliability
• Engage in project workstreams alongside senior team members, gaining exposure to client interaction and delivery best practices
• Learn and apply modern data engineering and cloud practices across industries and use cases
• Work with cross-functional teams and clients to solve complex business problems and unlock data insights

Requirements

• 5+ years of experience in data engineering, analytics, or a related technical role
• Proficiency in SQL and working knowledge of Python or another scripting language
• Hands-on experience with ETL/ELT processes and modern data tools such as Azure Data Factory, AWS Glue, Snowflake, or Databricks
• Familiarity with cloud environments including AWS, Azure, Palantir Foundry, or similar
• Knowledge of data modeling concepts
• Understanding of data integration, data quality, and performance tuning principles
• Ability to work collaboratively on fast-paced projects with technical and non-technical stakeholders
• Strong problem-solving and communication skills
• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field
• Ability to legally work for any employer in the US without sponsorship
• Experience with Apache Airflow, dbt, Palantir Foundry, Spark, Redshift, Power BI, or Tableau is a bonus
• Cloud platform or data engineering certifications are a bonus
• Previous consulting firm experience is a bonus

Core Competencies

Demonstrates expertise in building and maintaining scalable data pipelines using Azure Data Factory, AWS Glue, and Palantir Foundry, along with proficiency in SQL and Python for ETL/ELT processes. Strong ability to collaborate with cross-functional teams to ensure data quality and deliver actionable insights through data modeling and visualization tools like Power BI and Tableau.

Highest-signal resume keywords

• Data Engineering
• ETL/ELT Processes
• SQL Proficiency
• Azure Data Factory
• Data Modeling

ATS Optimization Keywords

Hard Skills

• Data Engineering
• ETL/ELT Processes
• SQL Proficiency
• Python Scripting
• Data Modeling
• Data Integration
• Performance Tuning
• Cloud Environments
• Data Quality
• Data Visualization

Soft Skills

• Problem-Solving
• Communication
• Collaboration

Certifications & Qualifications

• Cloud Platform Certifications
• Data Engineering Certifications

Industry Keywords

• Data Pipelines
• Data Analytics
• Cloud-Based Data Platforms
• Data Solutions
• Consulting Experience

Tools & Technologies

• Azure Data Factory
• AWS Glue
• Snowflake
• Databricks
• Power BI
• Tableau
• Apache Airflow
• Dbt
• Palantir Foundry
• Redshift