[Remote] Gen AI - Data Automation Engineer
Note: The job is a remote job and is open to candidates in USA. Alpha Consulting Corp. is a Fortune 500 technology, engineering, and science solutions leader. They are seeking a Data Automation Engineer to design and implement AI-driven automation solutions across AWS and Azure environments, focusing on building scalable data pipelines and automations for analytics and reporting.
Responsibilities
- Design and maintain data pipelines in AWS using S3, RDS/SQL Server, Glue, Lambda, EMR, DynamoDB, and Step Functions
- Develop ETL/ELT processes to move data from multiple data systems including DynamoDB → SQL Server (AWS) and between AWS ↔ Azure SQL systems
- Integrate AWS Connect CRM data into the enterprise data pipeline for analytics and operational reporting
- Engineer, enhance ingestion pipelines with Apache Spark, Flume, Kafka for real-time and batch processing into Apache Solr, AWS Open Search platforms
- Leverage Generative AI services and Frameworks (AWS Bedrock, Amazon Q, Azure OpenAI, Hugging Face, LangChain) to:
- Create automated processes for vector generation and embeddings from unstructured data
- Automate data quality checks, metadata tagging, and lineage tracking
- Enhance ingestion/ETL with LLM-assisted transformation and anomaly detection
- Build conversational BI interfaces that allow natural language access to Solr and SQL data
- Develop AI-powered copilots for pipeline monitoring and automated troubleshooting
- Implement SQL Server stored procedures, indexing, query optimization, profiling, and execution plan tuning to maximize performance
- Apply CI/CD best practices using GitHub, Jenkins, or Azure DevOps for both data pipelines and GenAI model integration
- Ensure security and compliance through IAM, KMS encryption, VPC isolation, RBAC, and firewalls
- Support Agile DevOps processes with sprint-based delivery of pipeline and AI-enabled features
Skills
- BS in Computer Science or related field with 2+ years of data engineering, automation experiences
- Hands-on experience with SQL, SSIS, Python, Spark, Bash, Power shell, AWS/Azure CLIs
- Experience with AWS services like S3, RDS/SQL Server, Glue, Lambda, EMR, DynamoDB
- Familiarity with Apache Flume, Kafka, Solr for large-scale data ingestion and search
- Familiarity with LLM, Gen AI frameworks using AWS Bedrock, Azure OpenAI or open source platform, tools
- Experience with integrating REST API calls in data pipelines and workflows
- Familiarity with JIRA, GitHub / Azure DevOps / Jenkins for SDLC and CI/CD automation
- Strong troubleshooting and performance optimization skills in SQL, Spark or other data engineering solutions
- Experience operationalizing Generative AI (GenAI Ops) pipelines, including model deployment, monitoring, retraining, and lifecycle management for LLMs and AI-enabled data workflows
- Good communication and presentation skills
- Ability to obtain Federal government Public Trust clearance
- Certifications: AWS Data Engineer, AWS AI/ML Specialty, Azure AI Engineer, Databricks certified Data Engineer
- Experience implementing RAG pipelines, embeddings, and vector search with Solr, OpenSearch, FAISS, Pinecone, or Pgvector/SQL server vector types
- Experience with GenAI powered coding tools such as Claude Code, OpenAI Codex, VS Code
- Experience with multi-cloud data integration (AWS ↔ Azure SQL)
- Familiarity with Client BizTalk and SSIS for SQL Server ETL workflows
- Knowledge of data lineage/governance tools (Purview, Unity Catalog, AWS Glue Catalog)
- Familiarity with Infrastructure-as-Code (Terraform/CloudFormation, Bicep) for automated deployments
- Experience with compliance frameworks (FedRAMP, PCI-DSS, HIPAA)
Company Overview