Data Analyst: Python, SQL & ETL to Drive Insights (Onsite)

DataJobs; Brentwood (TN); On-site; USD 60,000 - 80,000; Full time

Benefits offered by this job

Onsite work

Job summary

Altair Data Resources, Inc. is seeking a Data Analyst in Brentwood, TN for an on-site role focused on data extraction and analysis using Python, SQL, and ETL workflows. You will develop data pipelines, validate outputs, and ensure data security in a high-growth environment.

You will build dashboards and automate processes with AI-assisted tools, collaborating with management to meet deadlines and deliver accurate datasets for clients.

Qualifications

• 2+ years of professional experience in data analysis, data processing, ETL development, or related role.
• Practical experience using Python for data cleaning, transformation, and automation (pandas preferred).
• Strong working knowledge of SQL, including joins, filters, aggregations, and multi-table queries.
• Experience developing or maintaining ETL workflows and working with relational databases, structured data files, and data quality controls.
• Ability to troubleshoot processing failures, investigate data discrepancies, and implement dependable solutions.
• Familiarity with Excel and reporting/visualization tools such as Tableau or Power BI (Alteryx a plus).
• Interest in leveraging AI-assisted tools to support coding, data analysis, and process improvement, with ability to evaluate outputs.

Responsibilities

• Conduct data analysis and produce accurate datasets aligned to customer or management requirements.
• Develop and maintain data processing workflows.
• Use Python and SQL to automate recurring tasks and support analysis and reporting.
• Troubleshoot data issues, including processing failures and data discrepancies.
• Monitor data quality and process performance, identifying opportunities for improvement.
• Build, maintain, and troubleshoot Python scripts and SQL queries for data extraction, transformation, analysis, and delivery.
• Create and maintain ETL workflows that combine data from multiple sources and prepare datasets for analysis or client delivery.
• Acquire data from primary and secondary sources and maintain databases and data processing systems.
• Interpret data using statistical techniques, identifying trends in complex datasets.
• Document workflows, business rules, and quality control procedures for reliable processing.
• Partner with management and internal teams to understand requirements and deliver within timelines.
• Identify ways to automate manual processes and improve data quality and efficiency.
• Use company-approved AI tools for coding, troubleshooting, documentation, and process improvement, validating outputs and following data security requirements.

Skills

Python

SQL

ETL

pandas

Alteryx

Tableau

Power BI

Excel

Education

Bachelor's degree

Tools

pandas

Alteryx

Tableau

Power BI

Excel

Python

SQL

ETL

Job description

Altair Data Resources, Inc. is seeking a Data Analyst in Brentwood, TN for an on-site role focused on data extraction and analysis using Python, SQL, and ETL workflows. You will develop data pipelines, validate outputs, and ensure data security in a high-growth environment.

You will build dashboards and automate processes with AI-assisted tools, collaborating with management to meet deadlines and deliver accurate datasets for clients.