Job Title: Consulting Data & AI Engineer
Department: Professional Services- Systems
Reports To: Director of Professional Services Systems
Job Summary:
The Consulting Data & AI Engineer is a key position on our Professional Services team that designs, develops, implements, and maintains data and artificial intelligence (AI) solutions for clients. While working in fast-paced environments, the position’s primary focus is to deliver data engineering, integration, analytics, and AI-enabled application projects, and interface with clients to help them address business needs through practical, secure, and maintainable technology solutions.
Essential Functions:
- Implement best-in-class data and AI technology projects that address client business needs.
- Consult with clients to understand business objectives, existing data environments, and technical requirements; translate those needs into effective solution designs.
- Design, develop, and maintain data pipelines, integrations, data models, and ETL/ELT processes that make client data reliable, accessible, and useful.
- Develop and optimize SQL queries, database structures, and data solutions that support reporting, analytics, and AI-enabled applications.
- Connect AI capabilities to client data sources, APIs, applications, and business systems while considering security, privacy, and access controls.
- Evaluate AI use cases, build prototypes or proofs of concept, and test solutions for accuracy, reliability, performance, and business value.
- Communicate both big-picture business drivers and technical details throughout projects.
- Estimate project effort, identify risks and dependencies, communicate project status, and help ensure solutions are delivered within agreed scope and timelines.
- Provide client assistance by troubleshooting technical issues and collaborating with internal and vendor technical resources until a solution is reached.
- Document solution designs, data flows, configurations, and implementation procedures to support ongoing maintenance and knowledge transfer.
- Attend vendor training, conferences, webinars, and continuing education to maintain current knowledge of relevant technology and research industry best practices.
- Gain and maintain certifications in areas of expertise.
- Advocate positive culture and collaborate with team members to share knowledge, reusable tools, and best practices.
- Provide feedback to executive and technical teams to participate in functionality roadmap planning and the continued development of CAIT’s data and AI services.
- Benchmark, analyze, report on, and make recommendations for the improvement and growth of professional and managed services technology offerings.
- Identify opportunities to improve client outcomes and support revenue growth through additional data, analytics, automation, and AI solutions.
- Meet established project delivery, client service, and billable-hour expectations.
- Perform other tasks as needed or requested.
Education and Experience:
- 7+ years of related experience in data engineering, software engineering, analytics engineering, business intelligence, or a related technology discipline required.
- Demonstrated experience designing, developing, and supporting data pipelines, data integrations, data models, or data-intensive applications.
- Strong SQL skills and experience with relational databases, data warehousing, and ETL/ELT processes.
- Experience developing and deploying technical solutions in cloud or enterprise environments.
- Programming experience in one or more languages used for data engineering such as Python, SQL, Rust, or similar.
- Experience with Microsoft cloud and data technologies, such as Azure, Microsoft Fabric, Azure Data Factory, Snowflake, Databricks, or related services, preferred.
- Experience with large language models (LLMs), generative AI, AI agents, retrieval-augmented generation (RAG), embeddings, or vector search preferred.
- Associate’s or Bachelor’s degree in a related field preferred; equivalent practical experience may be considered.
- Certifications are highly encouraged, especially in data, cloud, software development, and AI technologies.
Desired Qualifications/Skills:
- Client-facing communication and soft skills to work with management, client technology teams, end users, and technical vendors on technical issues as they relate to projects or client needs.
- Excellent communication skills, including the ability to explain technical concepts and business implications to technical and nontechnical audiences.
- The ability to create lasting relationships with client technology teams.
- An entrepreneurial mindset with an understanding of revenue growth as a business driver.
- Excellent analytical, problem-solving, troubleshooting, and attention-to-detail skills.
- High level of self-motivation and accountability.
- Ability to manage multiple priorities and add value under the pressure of time constraints in a fast-paced, collaborative environment.
- Ability to learn new technologies, research industry best practices, and recommend practical solutions.
- Ability to travel in various capacities, including but not limited to client sites, training seminars, trade shows, and corporate events.
- Ability to work in an environment that may require sitting for extended periods of time and dexterity of hands and fingers to operate a computer keyboard and mouse.
Benefits & Perks:
We offer a comprehensive benefits package designed to support our team members both personally and professionally, including:
- 401(k) retirement plan with employer match
- Opportunities for quarterly bonuses (variable pay)
- Paid time off and volunteer time off
- Medical, dental, and vision coverage for employees and eligible dependents
- 100% company-paid life insurance and short-term and long-term disability insurance
- Flexible spending accounts and health savings accounts
- Career development and advancement opportunities
- Professional development and training opportunities
- Company-paid vendor certifications and training
- Mentorship and opportunities to work on diverse projects
- Hybrid and flexible work arrangements, depending on the position and business needs
- Wellness and financial resources
- A culture-rich organization with a family-valued atmosphere.
A full summary of available benefits is provided during the interview and onboarding process.