Assistant Applications Specialist (Data & AI Analyst)

Creative Solutions Services, LLC; Kansas City (MO); On-site; USD 44,000 - 52,000; Full time

Benefits offered by this job

Medical Insurance

401k Retirement Fund

Job summary

Creative Solutions Services, LLC is seeking an Assistant Applications Specialist (Data & AI Analyst) in Kansas City, MO. The role focuses on developing software tools, leveraging AI (Claude Code, Codex), and translating data needs into automated solutions.

You will write SQL, perform light data modeling, and collaborate with developers to scale prototypes into production. The position involves working with internal teams to deliver reports and dashboards, using Power Apps and Power BI, and

Qualifications

• 1–5 years of relevant experience in a data analyst, automation, or similar hands-on technical role.
• Bachelor's degree in Engineering Technology, Computer Science, or related field.
• Strong SQL and data modeling skills with basic Python scripting.
• Excellent written and verbal communication; strong attention to detail and problem-solving.
• Onsite at the Kansas City office with US work authorization

Responsibilities

• Understand data, automation, and reporting needs and translate them into working solutions.
• Prompt with AI tools to build automations and AI agents that solve business problems.
• Write and optimize SQL for data analysis and reporting.
• Collaborate with software developers to scale, harden, and operationalize prototypes.
• Work within GitHub and VS Code in the standard development workflow.
• Operate across Azure, GCP, and AWS as engagements require.
• Develop applications, reports, and dashboards for internal and external clients.
• Configure security and automation flows within applications.

Skills

SQL

Data modeling

Python

Communication

Team leadership

Education

Bachelor's Degree

Tools

GitHub

VS Code

Azure

GCP

AWS

Power BI

Job description

Assistant Applications Specialist (Data & AI Analyst)

Location: Kansas City, MO

Onsite Flexibility: Onsite

Contract Details

• Position Type: Contract
• Contract Duration: 6 months
• Pay Rate: $32.00–$38.00 / Hour (USD)
• Work Authorization: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Job Summary

The Assistant Applications Specialist will assist in developing and advancing software technology and tools throughout the organization. This position will work throughout the development and implementation process according to organization budget constraints and internal and external client needs. The role involves partnering with internal business customers to understand data, automation, and reporting needs, and translating them into working solutions. The successful candidate will use AI tools (Claude Code, Codex, and similar) to prompt effectively, build automations, and stand up AI agents that solve real business problems. This role also involves writing and optimizing SQL for data analysis, reporting, and light data modeling work, as well as collaborating with software developers to help scale, harden, and operationalize applications that started as rapid prototypes or vibe coded apps.

Key Responsibilities

• Partner with internal business customers to understand data, automation, and reporting needs, and translate them into working solutions.
• Use AI tools (Claude Code, Codex, and similar) to prompt effectively, build automations, and stand up AI agents that solve real business problems.
• Write and optimize SQL for data analysis, reporting, and light data modeling work.
• Apply basic Python scripting with the support of AI tools to build automation and analysis tasks.
• Collaborate with software developers to help scale, harden, and operationalize applications that started as rapid prototypes or vibe coded apps.
• Work within GitHub and VS Code as part of the standard development workflow.
• Operate comfortably across cloud environments, including Azure, GCP, and AWS, as engagements require.
• Act as a go-to resource for internal teams with a customer-first mindset looking to apply AI tooling to everyday data and automation challenges.
• Assist in developing applications, reports, and dashboards for internal and external clients.
• Assist in developing solutions specific to reporting platforms offered throughout the organization, including Microsoft Power Apps and Power BI.
• Assist in configuring security and automation flow routines within applications.
• Assist project staff in producing deliverables for project needs and requirements set forth by the project managers.
• Assist with new software applications to support project delivery and data management initiatives.
• Assist in technology and software applications to support all markets within the company.
• Assist with research and compile project-related data as required by the project managers.
• Assist disciplines and different business units in developing software and technology to optimize business processes and deliverables, provide seamless integration, and improve data management.
• Apply basic knowledge of Safety and Quality Control programs; elevate risk related to compliance with company and customer policies.
• Perform other duties as assigned.
• Comply with all policies and standards.

Required Skills

• Strong working knowledge of SQL and basic data modeling concepts.
• Working proficiency in Python (analyst-level need, not full data engineering depth).
• Basic knowledge of software development and programming experience.
• Basic knowledge of software and hardware system architecture.
• Basic knowledge of standard engineering techniques, principles, and procedures.
• Excellent written and verbal communication skills.
• Ability to work methodically and analytically in a quantitative problem-solving environment and demonstrated critical thinking skills.
• Proficient computer skills (e.g., Microsoft Office Suite).
• Strong attention to detail, facilitation, team building, collaboration, organization, and problem-solving skills.
• Demonstrated leadership skills.

Preferred Skills

• Demonstrated experience using AI coding/agent tools such as Claude Code and Codex — including prompt engineering skills.
• Prior internship and/or related consulting experience.
• Basic knowledge of software development and programming experience.
• Minimum of a 3.0 GPA strongly preferred.
• Involvement on campus or in the community preferred.

Education Requirements

• Bachelor's Degree in Engineering Technology, Computer Science, or a related degree from an accredited program — Required.

Required Experience

• 1–5 years of relevant experience in a data analyst, automation, or similar hands-on technical role.

Work Environment / Physical Requirements

• Driving may be required (MVR check applicable).
• Position is onsite at the Kansas City office.

Benefits

• Medical, Vision, and Dental Insurance Plans
• 401k Retirement Fund

About the Client

This infrastructure engineering firm has been designing and building essential city infrastructure since 1898, making it one of the longest-standing engineering, architecture, and construction organizations in the country. Headquartered in Kansas City, Missouri, and operating from 75 offices across the U.S. and internationally, the firm employs more than 14,500 employee-owners and generates over $7.4 billion in annual revenue. Its project portfolio spans energy, aviation, water, telecommunications, transportation, and healthcare — sectors that form the backbone of modern society. The organization is 100% employee-owned through an Employee Stock Ownership Plan (ESOP), a model that has earned it a 4.2-star Glassdoor rating across more than 1,800 reviews, with 87% of employees recommending it as a workplace. Teams here include civil and structural engineers, architects, environmental scientists, construction managers, program management professionals, and technology specialists who collaborate on complex, consequential projects ranging from major airport expansions to large-scale energy infrastructure.

Job Number: 26-13456

#LI-Onsite #gttic