We are looking for AI Data Engineer for our client in San Antonio, TX
Job Title: AI Data Engineer
Job Location: San Antonio, TX
Job Type: Contract
Pay Range: $50.00hr - $55.00hr
Job Overview:
There is a strategic opportunity within EDAO to build and implement AI-assisted engineering capabilities across 31 production dbt projects in the Marketing Analytics portfolio. The initiative will integrate GitHub Copilot with dbt, Snowflake, GitLab, Jira, Confluence, dbt Cloud, and CTM workflows to accelerate delivery while maintaining governance and human oversight.
Key Responsibilities:
- Design and build reusable AI skills, prompts, agents, and instruction files for dbt and data engineering workflows.
- Develop AI capabilities for Jira story intake, impact analysis, technical design, dbt model generation, testing, and code review.
- Build automation for CTM configuration validation, dependency sequencing, scheduling alignment, and deployment-readiness checks.
- Develop deployment skills covering GitLab merge requests, CI/CD pipelines, dbt Cloud execution, release runbooks, and change evidence.
- Build automated regression-testing and data-reconciliation capabilities across development, pre-production, and production environments.
- Apply strong hands-on knowledge of dbt models, macros, materializations, incremental strategies, tests, documentation, lineage, and dbt Fusion.
- Use Snowflake metadata, dbt manifests, GitLab repositories, and lineage information to identify upstream and downstream change impacts.
- Develop Python-based automation for API integration, metadata processing, validation, structured outputs, and workflow orchestration.
- Create reusable engineering standards for SQL, dbt, testing, data modeling, error handling, observability, and repository structure.
- Build AI-assisted support for pipeline monitoring, data freshness, anomaly analysis, defect investigation, and production reconciliation.
- Integrate AI-assisted workflows with GitHub Copilot, Jira, Confluence, GitLab, Snowflake, dbt Cloud, CTM, and approved MCP servers.
- Create golden datasets and evaluation scenarios to measure AI-draft acceptance, accuracy, rework, test coverage, and edge-case handling.
- Review AI-generated artifacts for business-logic accuracy, maintainability, security, performance, and compliance with project standards.
- Support pilot implementation, developer enablement, troubleshooting, and scaled adoption across the dbt project estate.
- Collaborate with developers, technical leads, architects, QA teams, platform teams, and deployment stakeholders throughout the lifecycle.
Skill Requirements:
- Skill set: DBT, Snowflake, Python, and AI.
Other Requirements:
- The selected candidate will contribute to AI-driven engineering solutions covering requirements analysis, impact assessment, development, automated testing, deployment orchestration, reconciliation, and production support.
====
Benefits
Our Benefits Include:
- Medical, Dental, and Vision Insurance
- 401(k) Retirement Plan
- Health Savings Account (HSA)
- Disability Insurance (Short-Term and Long-Term)
- Life and AD&D Insurance
- Paid Sick Leave (where required by applicable state or local law)
- Supplemental Insurance Plans
- Identity Theft Protection
- Pet Insurance
- Employee Wellness Programs
- Employee Assistance Program (EAP)
- Career Growth and Professional Development Opportunities
Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location. Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws.
About Cynet Systems
Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia.
As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers. Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.
