AI Engineer

Job Title : AI Engineer
Job Type : W2 Contract 
Bill Rate : $73/Hr on w2
Location :Plano, IL, USA
Duration :12 months 
Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Experience:
Extensive hands-on experience in an AI Engineering, Data/AI Engineering, or closely related technical role utilizing Databricks within enterprise environments.
 
Technical Skills:
Deep expertise in writing and debugging complex SQL queries (CTEs, window functions, and joins), hands-on experience with Python and PySpark, and proficiency in building declarative pipelines (Delta Live Tables or Lakeflow). Strong knowledge of Delta Lake, data quality management, and version control processes is required.
 
Required:
PowerBI needs dedicated workspace, connection setups, all dashboards are now on Databricks (some on PowerBI but will be migrated to Databricks from other teams), not looking for heavy dashboards experience; looking for experience more around the engineering side, monitoring the pipelines, ensure data flows, client facing engagement
• AI parsing/agents, genie function within Databricks but core skillset is in engineering
• Core Python and PySpark
• Data Engineer but also strong analytics, advanced SQL, support production incidents
• Key deliverables:
o Declarative pipeline techniques
o Perform advanced SQL analysis
o Structured and semi-structured data
o Support production incidents and troubleshoot issues across AI solutions
• How to build new pipelines, monitor and ensure they do not break, what to do if they break, source from another data source if needed but doubt will be situation (had 1 instance in past 11 months where data reports not working)
• Experience coming from the same industry not needed, makes them more inquisitive
 
Role Overview:
We are seeking a highly skilled AI Engineer to design, build, and support advanced AI-enabled data solutions on the Databricks platform. This role requires deep Databricks engineering capability and expert SQL skills to perform complex query analysis, optimization, and debugging. The successful candidate will collaborate closely with data engineers, analysts, and business stakeholders to deliver reliable, scalable, and production-ready pipelines and AI solutions.
 
Key Responsibilities:

• Design, develop, and productionize AI and machine learning solutions using the Databricks platform and its native AI capabilities.
• Build and maintain robust Databricks data engineering workflows using declarative pipeline techniques, including Lakeflow and Delta Live Tables.
• Develop scalable data pipelines to support AI, analytics, and downstream reporting use cases.
• Perform advanced SQL analysis across complex datasets, including query development, debugging, reconciliation, and root-cause analysis.
• Investigate poorly performing SQL queries and implement improvements to execution patterns, logic, joins, and filters.
• Optimize SQL workloads for performance, reliability, and maintainability within Databricks.
• Analyze data quality issues and trace defects through source data, pipelines, and SQL logic.
• Collaborate with cross-functional engineering teams and business SMEs to translate requirements into technical solutions.
• Apply modern software engineering practices, including modular design, version control, testing, code review, and deployment discipline.
• Support production incidents and troubleshoot issues across AI solutions, Databricks pipelines, and SQL workloads.
  
  Equal Opportunity Employer : We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.