Data Analyst - ETL, Python & AI-Driven Insights

DataAnalystJobs; Northern (KY); Hybrid; USD 60,000 - 80,000; Full time

Job summary

Altair Data Resources is seeking a Data Analyst with experience in data processing, analysis, and automation. You will develop Python scripts and SQL workflows to extract, transform, and deliver data, while leveraging AI-assisted tools to increase productivity and automation.

The role emphasizes building ETL processes, validating data quality, and delivering reliable results for clients. A Bachelor's degree or equivalent experience is required, with 2+ years in a related data role in a

Qualifications

• At least two years of professional experience in data analysis, data processing, ETL development, or a related role.
• Practical experience using Python for data cleaning, transformation, and automation; familiarity with pandas preferred.
• Strong working knowledge of SQL including joins, filters, aggregations, and queries involving multiple tables.
• 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 reliable solutions.
• Familiarity with Excel and reporting or visualization tools such as Tableau or Power BI; Alteryx experience a plus but not required.
• Interest in leveraging AI-assisted tools to support coding, data analysis, and process improvement with responsible output evaluation.
• Strong analytical and organizational skills, basic statistics, and attention to detail with large datasets.
• Ability to manage assigned work independently, document processes, explain findings and collaborate with technical and business teams.
• Bachelor’s degree in Mathematics, Computer Science, Data Science, Information Management, Statistics or related field or equivalent relevant professional experience.

Responsibilities

• Develop and maintain Python scripts and SQL queries to extract, transform, analyze, and deliver data.
• Build, maintain, and troubleshoot ETL workflows that combine data from multiple sources, apply business rules, and prepare datasets for analysis or client delivery.
• Acquire data from primary and secondary sources and maintain databases and data processing systems.
• Interpret data, analyze results using statistical techniques, and identify trends or patterns in complex datasets.
• Clean, validate, and reconcile data to identify errors, resolve inconsistencies, and ensure accuracy and completeness.
• Use company-approved AI tools to assist with coding, troubleshooting, documentation, and process improvement while validating outputs and following data security and confidentiality requirements.
• Document workflows, business rules, and quality control procedures to support reliable and repeatable processing.
• Work with management and internal teams to understand requirements, prioritize business needs, and deliver accurate results within established timelines.
• Identify opportunities to automate manual processes, improve data quality, and increase processing efficiency.

Skills

Python

SQL

ETL

Data analysis

AI tools

Education

Bachelor's degree or equivalent

Tools

Alteryx

Tableau

Power BI

Job description

Altair Data Resources is seeking a Data Analyst with experience in data processing, analysis, and automation. You will develop Python scripts and SQL workflows to extract, transform, and deliver data, while leveraging AI-assisted tools to increase productivity and automation.

The role emphasizes building ETL processes, validating data quality, and delivering reliable results for clients. A Bachelor's degree or equivalent experience is required, with 2+ years in a related data role in a