Data & AI Engineer

CGI is seeking a hands‑on Data & AI Engineer for its Houston, Texas office. The role follows a hybrid model, requiring an average of three days onsite at the client location and/or the CGI Houston office.

Responsibilities

• Design, develop, and maintain scalable data pipelines and data integration solutions using Databricks, Snowflake, Azure, and related cloud technologies.
• Develop data ingestion, transformation, and processing workflows with Python, SQL, PySpark, and Spark.
• Build and optimize solutions within Databricks, including notebooks, workflows/jobs, Delta Lake, Unity Catalog, and medallion‑style data architectures.
• Develop Snowflake solutions such as tables, views, stored procedures, data pipelines, security models, and performance optimization.
• Integrate data from structured and unstructured sources into modern cloud data platforms.
• Support data migration and modernization initiatives involving legacy databases, SQL Server, cloud storage, and modern lakehouse/data‑warehouse platforms.
• Develop Python‑based applications, reusable services, libraries, and data‑processing components.
• Build and integrate REST APIs using frameworks such as FastAPI.
• Develop AI and Generative AI solutions leveraging Azure AI Foundry, Azure OpenAI, Databricks AI capabilities, Snowflake Cortex, or similar platforms.
• Support Retrieval‑Augmented Generation (RAG), document intelligence, natural‑language‑to‑data, and other enterprise AI use cases.
• Collaborate with business and technical stakeholders to understand problems, define requirements, and translate them into technical solutions.
• Perform data analysis, validation, reconciliation, and data‑quality assessments.
• Create clear technical documentation covering architecture, development standards, deployment, and operational support.
• Participate in solution demonstrations, technical discussions, client workshops, and proof‑of‑concept development.
• Work within DevOps and CI/CD processes using tools such as Azure DevOps and Git.

Qualifications

• Experience in data engineering and software development.
• Proficiency with Databricks and Snowflake.
• Strong data integration/ETL/ELT skills.
• Experience developing Generative AI/LLM solutions.
• Python and SQL development expertise.
• Ability to communicate effectively with clients.
• Experience with Azure cloud services.
• Familiarity with #DICE (Data, Integration, Cloud, Engineering) concepts.

Benefits

• Competitive compensation
• Comprehensive insurance options
• Matching contributions through the 401(k) plan and a share purchase plan
• Paid time off for vacation, holidays, and sick time
• Paid parental leave
• Learning opportunities and tuition assistance
• Wellness and well‑being programs

Pay

Estimated compensation range for this role in the United States is $100,800.00 – $245,500.00.