Position: Senior Data Engineer (Salesforce & Jira Integration)
Location: Remote from LATAM
Contract Type: Full-time (Vendor)
Time Zone Alignment: CT (Consistent overlap with US-Based Stakeholders)
About In All MediaWe are a Managed Nearshore Teams provider headquartered in Austin, Texas, specializing in building and embedding high-performing software development teams. From design to deployment, we deliver customized solutions by connecting global talent with innovative client projects. Our model allows you to work on international challenges, collaborate with diverse teams, and grow your career while being part of a company that values expertise, creativity, and impact.
Project OverviewIn this role, you will anchor a business-critical cloud data engineering initiative, partnering with enterprise IT and commercial stakeholders to integrate complex business operations workflows. You will design, build, and optimize robust ETL/ELT pipelines that stream data from core enterprise SaaS platforms—specifically Salesforce and Jira—into a centralized Snowflake data warehouse.
Built for collaborative, highly technical problem solvers, you will transform raw operational records into high-performance, reporting-ready layers. This project requires a strong understanding of data governance, security boundaries, and schema design, ensuring that downstream Power BI developers and executive audiences have reliable, secure, and lightning-fast access to commercial insights.
Key Responsibilities- Pipeline & ETL/ELT Engineering: Build, scale, and maintain high-performing data pipelines to ingest structured and semi-structured data from enterprise SaaS systems into Snowflake.
- Snowflake Architecture & Transformation: Develop Snowflake pipeline objects, staging environments, advanced transformation logic, and aggregations to build optimized, reporting-ready data structures.
- SaaS Ecosystem Integration: Lead the technical ingestion and modeling of Salesforce commercial data (opportunities, accounts, and custom A&A approval workflows) and Jira process data (custom fields, workflow configurations, and issue routing).
- Data Quality & Pipeline Monitoring: Implement rigorous data quality checks, automated error handling, reconciliation scripts, and proactive end-to-end pipeline monitoring.
- Governance & Enterprise Security: Work strictly within enterprise security architectures, access-control boundaries, and role-based permissions to protect sensitive commercial and operational data.
- Cross-Functional Collaboration: Partner with Power BI developers, Jira/Salesforce administrators, and business analysts to validate data availability, map transformation logic, and support executive dashboards.
- Agile Delivery & Documentation: Produce comprehensive technical designs, data flow documentation, and operational handoffs while actively participating in standard Agile/Scrum ceremonies.
- Experience Tenure: 5+ years of professional experience working as a Data Engineer, with a proven track record of architecting cloud-based pipelines.
- Snowflake Mastery: Deep, hands-on engineering experience within Snowflake, specifically focusing on ingestion, staging strategies, stream/task management, and query optimization.
- Advanced SQL: Expert-level SQL skills for complex data transformation, validation, performance tuning, and building clean analytics schemas.
- Salesforce Data Competency: Direct experience integrating with Salesforce, including a strong understanding of its data model, REST/Bulk APIs, permissions, and commercial objects (opportunities, sales operations, approvals).
- Workflow Data Modeling: Proven experience ingesting and modeling data from Jira or similar enterprise-level ticketing and workflow management platforms.
- Fluent English: Excellent verbal and written communication skills for seamless daily technical collaboration and documentation with US-based stakeholders.
- Modern Data Stack Toolkit: Familiarity with modern data orchestration and transformation tools such as dbt, Airflow, Fivetran, Matillion, Informatica, or Azure Data Factory.
- Downstream Visualization Layer: Experience with Power BI, including data modeling, native connector configurations, dashboard support, or writing DAX.
- DevOps & CI/CD: Experience utilizing version control (Git), automated testing frameworks for data pipelines, and CI/CD deployment workflows.
- Jira Mechanics: Advanced understanding of Jira Software or Jira Service Management, including custom automation rules, cloud migration nuances, or hybrid cloud/on-premise reporting configurations.
- Commercial Ops Domain Knowledge: Prior experience supporting analytics for sales operations, deal desk, quoting, bid authorization, or professional services workflows.
- Distributed Team Dynamics: Prior experience working effectively as part of a distributed nearshore team aligned with US corporations.
This role is 100% remote from LATAM and requires consistent overlap with teams (CT/ET). Flexibility is expected to accommodate key ceremonies, stand-ups, sprint planning, and collaborative sessions within standard US business hours.
LanguageAll interviews, documentation, and daily communication are in English.
Skills Required
- 5+ years of professional experience as a Data Engineer, architecting cloud-based pipelines
- Deep hands-on Snowflake experience (ingestion, staging strategies, streams/tasks, query optimization)
- Expert-level SQL for complex transformations, validation, and performance tuning
- Direct experience integrating with Salesforce including data model, REST/Bulk APIs, permissions, and commercial objects
- Proven experience ingesting and modeling Jira or similar ticketing/workflow platform data
- Experience building, scaling, and maintaining ETL/ELT pipelines for structured and semi-structured data
- Strong understanding of data governance, enterprise security architectures, and role-based permissions
- Fluent English for daily technical collaboration and documentation with US stakeholders
- Remote from LATAM with consistent overlap with CT/US business hours
- Familiarity with modern data orchestration/transformation tools (dbt, Airflow, Fivetran, Matillion, Informatica, ADF)
- Experience with Power BI, data modeling, connectors, dashboard support, or DAX
- DevOps experience: Git, CI/CD for data pipelines, and automated testing frameworks
- Advanced understanding of Jira mechanics, automation, and cloud/hybrid reporting configurations
- Commercial operations domain knowledge (sales ops, deal desk, quoting, approvals)
- Experience working on distributed/nearshore teams aligned with US corporations
What We Do
In All Media is a cutting-edge technology and innovation consulting organization, facilitating digital transformation in multiple industries. We have partnered with top-tier organizations such as NBCUniversal, Sony DADC, Aclara Technologies, and Dun & Bradstreet, among other leading companies worldwide. In All Media harnesses the collaborative synergy of all our international talent pool using Agile methodologies, to deliver excellence efficiently and with the utmost quality. At In All Media, we believe in diversity and autonomy. Our new model brings together a global managed community, with experts guiding and managing talented engineers; working to bring together the best talent in the world, regardless of where they are. We are not only evolving in terms of technology, but also in terms of In All Media as a re-imagined technology consultancy in step with the Fourth Industrial Revolution. Our community of 200+ experts and engineers are very motivated by different challenges in their field, and apply continuous learning to stay ahead of the curve in their expertise on new developments and innovative technologies. Our delivery model is based on Agile, On-site, and Near Shore capabilities to maximize team integration and provide the best value to our clients. We partner holistically with our clients in the co-creation of services and products, and follow streamlined Agile processes throughout. This makes In All Media a truly global company driven by a community of dedicated, talented individuals self-organizing into multi-disciplinary teams, producing the best possible output for our world-class clients. We're hiring! Email us your CV: [email protected] Contact Us: [email protected]
