Own and optimize data infrastructure and ETL/ELT pipelines using SSIS and Microsoft Fabric. Build and maintain SQL Server data warehouse staging, transformations, and lakehouse ingestion. Implement CI/CD, version control with GitHub, monitor pipeline health, troubleshoot data issues, document data flows, and translate stakeholder requirements into data engineering solutions that support BI reporting.
This position is based remotely in Mexico.
About the job
Olé Mexican Foods is one of the largest tortilla manufacturers in America, with products sold coast to coast. Our Business Intelligence team supports data-driven decision-making across all departments, from production and operations to sales and distribution.
We’re looking for a Senior Data Engineering Consultant who can own the data infrastructure that powers our analytics environment. You’ll build and maintain ETL pipelines, develop and optimize our SQL Server data warehouse, design Fabric lakehouse ingestion workflows, and establish CI/CD practices for our data assets, all while working remotely with our USA-based team. The ideal candidate is self-sufficient, understands how data flows from source to consumption, and can navigate a complex data environment with minimal guidance.
Responsibilities
- Develop, maintain, and optimize ETL/ELT pipelines using SSIS and Microsoft Fabric
- Build and maintain data warehouse staging, transformation, and loading processes in SQL Server
- Design and implement data ingestion workflows from multiple source systems into SQL Server and Fabric lakehouses
- Write and optimize complex SQL queries, stored procedures, and indexing strategies
- Design and maintain star schemas, dimensional models, and data warehouse architecture
- Monitor pipeline health, troubleshoot data issues, and implement error handling and logging
- Implement and maintain CI/CD pipelines for automated testing and deployment of data assets
- Manage version control for data pipelines, SQL objects, and BI assets using GitHub
- Document data flows, transformation logic, pipeline architecture, and business rules thoroughly
- Gather requirements from stakeholders and translate them into data engineering solutions
- Collaborate with the BI team to ensure data models support downstream reporting needs
Minimum qualifications
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field
- 3+ years of experience in data engineering or data warehouse development
- Strong SQL Server skills (complex queries, stored procedures, performance tuning, indexing)
- Hands-on ETL/ELT pipeline development experience with SSIS
- Experience with Microsoft Fabric (lakehouses, data pipelines, analytics workloads)
- Solid understanding of data warehouse architecture, star schemas, and dimensional modeling
- Experience with Git/GitHub for version control
- Familiarity with CI/CD concepts and deployment automation
- Strong documentation skills
- Excellent written and verbal communication in English and Spanish
- Ability to work independently with minimal supervision
Preferred qualifications
- Microsoft DP-600 (Fabric Analytics Engineer) or DP-203 (Data Engineer) certification
- Experience implementing CI/CD pipelines for data engineering or BI workflows (e.g., Azure DevOps, GitHub Actions)
- Experience leveraging AI tools (e.g., Claude, Copilot, ChatGPT) to accelerate development and analysis
- Power BI experience (report development, DAX, Power Query, semantic models)
- Experience in manufacturing, production, or retail environments
- Background in operations or supply chain data
- Knowledge of data governance and security best practices
Similar Jobs
Healthtech • Software
Designs retrieval architectures, develops and evaluates AI agents, and owns production deployments for healthcare applications. Responsibilities include hands-on coding, release management, on-call support, cross-functional collaboration, and ensuring HIPAA-compliant security. The role requires software development experience, cloud and CI/CD knowledge, AI architecture expertise, and experience with agent frameworks, language models, RAG, multi-agent systems, and evaluation frameworks.
Top Skills:
Ai ArchitecturesCi/CdCloud PlatformsCohere Ai AgentsEvaluation FrameworksGraph-Based Data RetrievalHipaaInfrastructure As Code (Iac)Language ModelsMulti-Agent SystemsMultimodal Data RetrievalRetrieval-Augmented Generation (Rag)
.png)
Logistics • Marketing Tech • Software
Provide technical customer support for Lob’s direct mail API and dashboard. Troubleshoot API errors, webhooks, HTML templates, address verification, and delivery tracking using logs and diagnostic tools. Resolve Zendesk tickets within SLA, explain technical issues clearly, escalate complex cases, identify security and fraud concerns, track recurring product friction, and create help center resources and response macros. The role requires strong communication, prioritization, technical curiosity, and the ability to support both technical and nontechnical customers.
Top Skills:
Ai ToolsBrowser Developer ToolsCSSCurlHTMLHTTPJSONLob ApiPostmanSQLWebhooksZendesk
Cloud • Fintech • Food • Information Technology • Software • Hospitality
Serve as the technical lead for complex mid-market retail sales opportunities. Conduct discovery, deliver tailored demonstrations, design integrations and data flows, lead pilots and proofs of concept, complete technical RFPs and security reviews, and ensure effective implementation handoffs. Partner with Sales, Product, Partnerships, and Implementation while communicating customer needs, product gaps, and roadmap priorities. The role requires POS and retail operations knowledge, API fluency, strong communication, and willingness to travel up to 25%.
Top Skills:
Accounting IntegrationsAPIsData MigrationE-Commerce IntegrationsErp IntegrationsHardware ConfigurationInventory IntegrationsLoyalty IntegrationsNetwork ArchitecturePos
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
