Data Engineer - Python, SQL & BI

Phaxis; Nashville (TN); On-site; USD 110,000 - 120,000; Full time

Job summary

Phaxis, based near Nashville, seeks a Data Engineer to design, build, and maintain reliable data pipelines and analytics solutions. The candidate will collaborate with data analysts and business teams to turn raw data into actionable insights and support BI dashboards using Power BI, Tableau, or Looker.

Key expertise includes Python, SQL, data warehousing, ETL/ELT, and data modeling. The role requires strong problem solving and a drive to ensure data quality, security, and performance across

Qualifications

• Proficiency in Python programming.
• Advanced SQL with joins, window functions, and optimization.
• Experience building ETL/ELT pipelines.
• Knowledge of data warehousing concepts.
• Experience with BI platforms like Power BI, Tableau, or Looker.
• Strong data modeling and data quality focus.

Responsibilities

• Develop and maintain scalable data pipelines using Python and SQL.
• Build ETL/ELT processes to collect, transform, and load data from multiple sources.
• Design and optimize data warehouses, databases, and data models.
• Write complex SQL queries for data transformation, analysis, and reporting.
• Ensure data quality, accuracy, security, and reliability.
• Support BI dashboards and reporting using Power BI, Tableau, or Looker.
• Partner with analysts and business stakeholders to understand data requirements.
• Troubleshoot data pipeline and performance issues.
• Automate repetitive data-processing and reporting tasks.
• Document data pipelines, processes, and data models.

Skills

Python

SQL

Data warehousing

ETL/ELT

BI tools

Data modeling

Data quality

Analytical skills

Tools

Power BI

Tableau

Looker

Spark

Airflow

dbt

Snowflake

Databricks

Git

CI/CD

Job description

We are looking for a skilled Data Engineer to design, build, and maintain reliable data pipelines and analytics solutions. The ideal candidate has strong experience with Python, SQL, data warehousing, ETL/ELT processes, and Business Intelligence (BI).

You will work closely with data analysts, business teams, and engineering teams to transform raw data into accurate, actionable insights.

Salary is 110k to 120k

We are looking for a skilled Data Engineer to design, build, and maintain reliable data pipelines and analytics solutions. The ideal candidate has strong experience with Python, SQL, data warehousing, ETL/ELT processes, and Business Intelligence (BI).

You will work closely with data analysts, business teams, and engineering teams to transform raw data into accurate, actionable insights.

Responsibilities

• Develop and maintain scalable data pipelines using Python and SQL.
• Build ETL/ELT processes to collect, transform, and load data from multiple sources.
• Design and optimize data warehouses, databases, and data models.
• Write complex SQL queries for data transformation, analysis, and reporting.
• Ensure data quality, accuracy, security, and reliability.
• Support BI dashboards and reporting using tools such as Power BI, Tableau, or Looker.
• Partner with analysts and business stakeholders to understand data requirements.
• Troubleshoot data pipeline and performance issues.
• Automate repetitive data-processing and reporting tasks.
• Document data pipelines, processes, and data models.

Required Skills

• Strong programming experience with Python.
• Advanced SQL skills, including joins, CTEs, window functions, and query optimization.
• Experience building ETL/ELT pipelines.
• Knowledge of relational databases and data warehousing concepts.
• Experience with at least one BI platform such as Power BI, Tableau, or Looker.
• Understanding of data modeling, data quality, and database performance.
• Strong analytical and problem-solving skills.

Preferred Skills

• Experience with AWS, Azure, or Google Cloud.
• Experience with Spark, Airflow, dbt, Snowflake, Databricks, or similar technologies.
• Familiarity with Git and CI/CD.
• Experience working with APIs and cloud-based data sources.
• Knowledge of dimensional modeling and modern data platforms.