BI Developer II - Home Office

Are you a forward-thinking BI Developer II ready to architect the future of data? Join our dynamic, US-based company and play a pivotal role in our evolution towards modern, real-time data pipelines in the cloud using cutting-edge technologies like Microsoft Fabric. From your home in Mexico, you'll collaborate with international teams, transforming ideas from prototype to launch and directly impacting our strategic decisions.

What Excites Us (and Should Excite You):

• Shape Our Cloud Data Future: Be at the forefront of our transition to a modern, event-based data pipeline in Microsoft Fabric. Your expertise will be critical in designing and implementing these next-generation solutions.
• Global Collaboration, Local Impact: Work alongside talented international teams, bringing your unique perspective to solve complex data challenges and drive significant business value.
• Product-Minded Innovation: Contribute your ideas and technical expertise to the entire development lifecycle, from initial concept to successful deployment.
• Solve Complex Challenges: Dive into intricate data integration scenarios, tackling issues around data quality, unstructured datasets, and system performance.
• Amazing Travel Benefits: Unlock opportunities to explore new destinations as part of our team (details provided during the interview process).
• Remote Flexibility & US Stability: Enjoy the best of both worlds – the autonomy of a fully remote role based in Mexico, backed by the stability and growth potential of a successful US company.

Responsibilities:

• Spearhead the design and development of data integrations, strategically guiding our transition towards a real-time, event-based data pipeline in Microsoft Fabric.
• Develop and maintain essential database objects within our data warehouse.
• Proactively identify and resolve complex issues related to data integration, data quality, and data management incidents.
• Research and champion opportunities for new data acquisition and innovative uses of existing data assets.
• Integrate and optimize new data management technologies and software engineering tools within our existing infrastructure.
• Create and maintain comprehensive data management documentation, including a robust data dictionary.
• Recommend and implement strategies for continuous improvement in data reliability, efficiency, and overall quality.
• Collaborate closely with data architects, modelers, and IT team members to align on project requirements and objectives.
• Lead the revitalization of legacy services and architectures through strategic refactoring, migration, and the implementation of cloud-enabled distributed designs.
• Contribute significantly to enhancing the development and operations of our increasingly distributed architecture.
• Establish and help achieve critical backend and system SLOs to ensure scalability and resilience for future growth.

Requirements:

• Bachelor’s degree in Computer Science, Computer Engineering, or equivalent practical experience.
• 5+ years of proven experience in designing, building, and efficiently ingesting data into data warehouse systems.
• 5 years of hands-on experience working with diverse data pipelines, seamlessly integrating data from various sources into a data warehouse environment.
• 3+ years of deep expertise with Microsoft Integration Services (SSIS).
• 1+ years of practical experience with Python.

Knowledge, Skills, and Abilities You'll Bring:

• Mastery of Data Integration: Ability to build new integrations from a wide array of data sources, including SQL, NoSQL, Files, and APIs.
• SQL and ETL/ELT Expertise: Proficient in SQL and relational database concepts, with a strong understanding of advanced ETL/ELT processes and data transformation techniques.
• Data Format Versatility: Experienced in handling structured and semi-structured data formats such as JSON, XML, CSV, and TXT, and skilled in managing data pipelines using SSIS or similar tools.
• Batch Processing Power: Solid knowledge of batch data processing and executing batch transactions for DML operations in production settings.
• Query Optimization Prowess: Skilled in query optimization, with the ability to interpret and leverage execution plans to significantly improve database performance.
• Advanced SQL Acumen: Expertise in advanced SQL techniques, including window functions, CTEs, and performance tuning for both analytical and operational use cases.
• Data Quality Champion: Proven ability to proactively identify and resolve data quality issues, including thorough troubleshooting, de-duplication, and ensuring consistency across multiple systems.
• Independent and Collaborative: Comfortable working autonomously to tackle complex data engineering challenges while also collaborating effectively within cross-functional teams.
• Agile Adaptability: Experience thriving in a fast-paced Agile development environment, effectively balancing priorities and delivering impactful results.
• Continuous Learning Mindset: A proactive learner with a strong passion for leveraging modern data engineering tools and techniques to drive continuous improvement.
• Bonus Points: Experience with programming languages such as C# or Python for scripting and data processing tasks.

Who We Are: The arrivia Story

Welcome to arrivia, where we empower brands through the transformative power of travel. With over 55 years of collective expertise, we've united three industry leaders – ICE, SOR Technology, and WMPH Vacations – to create something truly exceptional. Our global team, with offices spanning the US coasts and beyond, embraces diversity and shares a deep passion for travel.

At arrivia, we're building a customer-first culture, dedicated to crafting unparalleled travel experiences for our members at every touchpoint. Join us on our exciting journey of growth and innovation as we continue to shape the future of travel. We're on a mission to help people around the world travel better and experience more, and our talented team brings world-class skills to create extraordinary memories for our partners and members.

Our Core Values: The arrivia Way

Here at arrivia, we live by these principles:

• Stay Curious: Embrace new challenges and cultivate a space for continuous learning, growth, and improvement.
• Keep it Real: Build trust through open, honest, and transparent communication.
• Own it: Seek opportunities to make a significant impact and take decisive action.
• Win Together: Foster a culture of connection and inclusion where every individual can thrive and bring their best.