Data and Analytics AI Engineer

AAON, Inc.; Tulsa (OK); On-site; USD 140,000 - 180,000; Full time

Job summary

AAON, Inc. seeks an experienced Data and Analytics AI Engineer to design and build enterprise data pipelines, BI dashboards, and AI-enabled automation.

You will bridge business requirements with modern data platforms using SQL Server, Azure, and Power BI to drive growth and operational excellence. Responsibilities include ETL/ELT development, data migrations, policy governance, and collaboration with stakeholders to define KPIs and deliver scalable analytics solutions across ERP, CRM, and

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• 10+ years of experience in data development, BI, or enterprise integration.
• Expert-level proficiency in SQL Server and T-SQL; Oracle or other relational databases are a plus.
• Proven experience developing and supporting large portfolios of enterprise data integrations.
• Hands-on experience with BI and reporting platforms (SSRS, Power BI, Tableau).
• Experience with ERP/CRM integrations and cloud data platforms (Azure).

Responsibilities

• Design, build, and maintain enterprise data pipelines, data models, and integrations across ERP, CRM, HR, finance, and manufacturing systems.
• Develop, monitor, and optimize ETL/ELT processes for data ingestion, transformation, and storage.
• Create and support integrations between internal systems and external providers.
• Lead data migration and consolidation efforts to modernize legacy applications.
• Administer SQL Server environments and ensure performance, security, and availability.
• Develop enterprise reporting and dashboards using Power BI and SSRS; define KPIs with business units.

Skills

SQL Server

Data modeling

ETL/ELT

Power BI

T-SQL

Python

Azure

Data governance

Education

Bachelor's degree or related experience

Tools

SSRS

Azure Data Factory

Microsoft Fabric

Job description

Job Description: The Data and Analytics AI Engineer is responsible for designing, building, and supporting enterprise data, analytics, automation, and artificial intelligence solutions that enable business growth and operational excellence. This role serves as the technical bridge between business requirements and modern data platforms, delivering scalable data pipelines, database and reporting solutions, enterprise application integrations, and intelligent automation capabilities. The individual will work closely with business stakeholders, analysts, and application teams to develop integrated solutions leveraging SQL Server, cloud technologies, data engineering best practices, and modern analytics and AI platforms. The ideal candidate combines deep expertise in databases, integration, and business intelligence with a strong understanding of data modeling, ETL processes, reporting, and data governance.

Essential Job Duties and Responsibilities

• Data Engineering & Integration Design, develop, and maintain enterprise data pipelines, data models, and integrations across ERP, CRM, HR, finance, and manufacturing systems.
• Build and optimize ETL/ELT processes for efficient data ingestion, transformation, and storage.
• Develop, monitor, and support a portfolio of integrations between internal systems and external providers.
• Lead data migration and consolidation efforts to modernize or retire legacy applications.
• Database Architecture & Administration Architect, administer, and optimize SQL Server and other relational database environments supporting enterprise applications.
• Ensure database performance, reliability, security, and availability across platforms.
• Support audit and compliance activities, including evidence gathering and controls documentation (e.g., SOX).
• Analytics & Business Intelligence Develop enterprise reporting and dashboards using Power BI, SSRS, and related tools.
• Partner with business units to define KPIs, gather requirements, and translate them into technical specifications.
• Build self-service BI capabilities and optimize datasets, semantic models, and reporting performance.
• AI & Intelligent Automation Identify opportunities to eliminate manual processes through automation using Power Automate and related technologies.
• Support development and deployment of AI, machine learning, and generative AI solutions as the enterprise platform matures.
• Evaluate emerging AI and automation technologies and recommend adoption opportunities.
• Platform Engineering & Operations Support the Azure Data Platform, Microsoft Fabric, and related cloud data services.
• Implement security, identity and access management, and compliance requirements.
• Develop technical documentation, data lineage, and operational runbooks.
• Collaboration & Leadership Collaborate with business leaders to understand strategic objectives and translate them into technical solutions.
• Mentor analysts and junior engineers and participate in architecture and governance reviews.

Education and Experience Requirements

Bachelor's degree in Computer Science, Mathematics, Information Systems, Data Science, or related field, or relevant experience.

10+ years of experience in data development, database administration, business intelligence, or enterprise integration roles.

Expert-level proficiency in SQL Server and T-SQL; experience with Oracle or other relational database platforms.

Proven experience developing and supporting large portfolios of enterprise application integrations, both internal and with third-party providers.

Hands-on experience with BI and reporting platforms (e.g., SSRS, Power BI, Tableau).

Experience supporting ERP and CRM platforms (e.g., Microsoft Dynamics), including migration and consolidation projects.

Proficiency in one or more programming languages (e.g., C#, Python).

Experience with data governance, security, and audit compliance practices.

Working knowledge of cloud platforms (Azure preferred) and modern data architectures.

Strong analytical thinking, problem-solving, and communication skills.

Preferred Skills

• Experience with Microsoft Fabric, Azure Data Factory, or data lake/lakehouse architectures.
• Experience with Python and Spark/PySpark for large-scale data processing.
• Exposure to generative AI technologies (e.g., Azure OpenAI, Copilot Studio, retrieval-augmented generation, AI agents).
• Experience with Power Platform and Power Automate workflow development.
• Experience with CI/CD pipelines and version control tools (e.g., Git, Azure DevOps).
• Microsoft Azure, Fabric, or Power Platform certifications.
• Experience supporting manufacturing or industrial operations.
• Experience leading, managing, or mentoring technical teams.

Knowledge, Skills, and Abilities

• Attention to detail and data accuracy
• Systems thinking and technical leadership
• Effective communication with technical and non-technical stakeholders
• Business partnership and customer focus
• Time management and project coordination
• Continuous learning and adaptability

Work Environment

While performing the duties of this job the employee will work in a climate-controlled office environment. May occasionally meet in the manufacturing facility and be exposed to: Humidity, loud noises, dirt Varying temperatures Sheet Metal Forklift traffic.

Physical Demands

Lift up to 10 lbs. Occasional climbing Occasional stooping Sitting for prolonged periods

Disclaimer

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

This job description is not an exhaustive list of all functions that the employee may be required to perform, and the employee may be required to perform additional functions.

The company reserves the right to revise this job description at any time.

The employee must be able to perform the essential functions of the position satisfactorily.

If requested, reasonable accommodation may be made to enable employees with disabilities to perform the essential functions of the job, absent undue hardship.

At AAON and BASX, we’re driven by a shared commitment to innovation, performance, and sustainability. Since 1988, AAON has been at the forefront of the HVAC industry, delivering cutting-edge solutions for commercial and industrial indoor environments. Since joining forces with AAON in 2021, BASX has built on that foundation with highly engineered, custom solutions for critical environments - where precision and reliability matter most - cleanrooms, data centers, and laboratories - ensuring our customers achieve exceptional efficiency, performance, and long-term value. Join us in shaping smarter, more sustainable environments for the future.