Data Engineer – Remote ETL/ELT Specialist for Business Intelligence & Analytics at arenaflex

About arenaflex – A Global Retail Leader Embracing Innovation

arenaflex is one of the world’s largest retail enterprises, operating in more than a dozen countries and serving millions of members every day. Despite its massive scale, arenaflex has cultivated a family‑oriented, employee‑first culture where individuals are empowered to grow, innovate, and make a tangible impact. Recognized by industry analysts as a top workplace, arenaflex consistently ranks among the “World’s Best Companies” for its commitment to employee well‑being, ethical business practices, and forward‑thinking technology strategy.

Our technology organization, arenaflex IT, is the engine that powers the data‑driven decisions behind every aisle, online experience, and strategic initiative. As a member of the Business Intelligence & Analytics team, you will join a collaborative group of product owners, BI architects, data scientists, and fellow data engineers who are passionate about turning raw data into actionable insight.

Why This Role Matters – The Mission of the Data Engineer

In today’s fast‑moving retail environment, data is the lifeblood of every business decision. The Data Engineer – BI & Analytics for Web‑Based Business is responsible for designing, building, and operationalizing end‑to‑end data pipelines that ingest, transform, and deliver high‑quality data to downstream analytics, reporting, and machine‑learning workloads. Your work will enable business leaders to answer critical questions, optimize operations, and deliver personalized experiences to millions of customers worldwide.

Key Responsibilities

• Design, develop, and maintain robust ETL/ELT workflows using Informatica Intelligent Cloud Services (IICS) and other cloud‑native tools.
• Collaborate closely with data modelers, BI architects, and product owners to translate business requirements into scalable data pipelines.
• Automate manual processes by identifying repetitive tasks, building reusable components, and implementing CI/CD best practices with Azure DevOps.
• Implement data quality, validation, and reconciliation logic to ensure the accuracy and reliability of data flowing through the system.
• Build and manage data lake and data warehouse solutions on Azure Data Lake Storage (ADLS), Azure Synapse Analytics, and Azure Databricks, supporting both structured and unstructured data.
• Optimize data storage and processing performance through partitioning, indexing, and appropriate use of NoSQL technologies such as Cosmos DB.
• Maintain comprehensive documentation of data models, pipeline architecture, and operational procedures.
• Monitor pipeline health, troubleshoot issues, and perform root‑cause analysis to minimize downtime and ensure SLA compliance.
• Participate in peer reviews to uphold coding standards, data governance, and security best practices.
• Support ad‑hoc data extraction and reporting requests for business stakeholders, delivering timely and accurate datasets.
• Stay current with emerging data technologies and recommend innovative solutions that can enhance arenaflex’s data ecosystem.

Essential Qualifications (Must‑Have)

• 2+ years of hands‑on experience designing and operationalizing data pipelines that handle large, complex datasets.
• 2+ years of experience with Informatica IICS or PowerCenter, including building reusable mappings and workflows.
• Strong background in ETL/ELT processes, data warehousing, and data lake architecture.
• Proficiency with cloud platforms—specifically Azure services such as ADLS, Azure Databricks, Azure Synapse, and Azure Data Factory.
• Advanced SQL skills with the ability to write complex queries across multiple data sources (SQL Server, Oracle, CSV, JSON, XML, REST APIs).
• Solid understanding of data storage concepts: data lakes, data warehouses, NoSQL (Cosmos DB), and graph databases.
• Experience working with clickstream and web analytics data, including handling high‑velocity event streams.
• Demonstrated ability to work in a fast‑paced, agile development environment and adapt to shifting priorities.
• Willingness to participate in on‑call rotation and support critical data pipelines outside of regular business hours.

Preferred Qualifications (Nice‑to‑Have)

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
• Azure certifications (e.g., Azure Data Engineer Associate, Azure Fundamentals).
• Experience with event‑driven integration patterns using Azure Event Hub, Kafka, or similar technologies.
• Familiarity with Git, Azure DevOps, and CI/CD pipelines for data engineering projects.
• Knowledge of data integration patterns such as change‑data‑capture (CDC) and real‑time streaming.
• Exposure to Power BI or other visualization tools for delivering end‑user dashboards.
• Understanding of retail industry data flows, including inventory, pricing, and customer behavior analytics.
• Strong written and verbal communication skills, with the ability to convey technical concepts to non‑technical stakeholders.
• Experience with job scheduling tools such as UC4 (Automic) or Azure Scheduler.

Core Skills & Competencies

• Technical Acumen: Mastery of data engineering fundamentals, cloud services, and modern data stack components.
• Problem‑Solving: Ability to diagnose pipeline failures, optimize performance, and propose scalable solutions.
• Collaboration: Comfortable partnering with cross‑functional teams, sharing knowledge, and mentoring junior engineers.
• Attention to Detail: Commitment to data quality, governance, and documentation standards.
• Adaptability: Thrive in a dynamic environment where priorities can shift rapidly based on business needs.
• Customer‑Centric Mindset: Understanding how data impacts the end‑customer experience and business outcomes.

Career Growth & Learning Opportunities

arenaflex invests heavily in the professional development of its employees. As a Data Engineer, you will have access to:

• Structured learning pathways through internal academies and external platforms (Coursera, Pluralsight, Udacity).
• Mentorship programs pairing you with senior data architects and industry experts.
• Opportunities to lead high‑visibility projects that influence global retail strategy.
• Cross‑functional rotations that expose you to product management, analytics, and machine‑learning teams.
• Support for certifications (Azure, Informatica, Snowflake, etc.) and conference attendance.

Work Environment & Culture at arenaxflex

Our culture is built on respect, inclusion, and a shared passion for innovation. arenaflex offers a flexible, hybrid work model that allows you to work from home or from one of our modern office hubs. The team operates with an agile mindset, holding regular stand‑ups, sprint reviews, and retrospectives to continuously improve processes.

We celebrate diversity and encourage every voice to be heard. Employee resource groups, wellness programs, and community outreach initiatives foster a sense of belonging and purpose beyond the daily tasks.

Compensation, Perks & Benefits (General Overview)

• Competitive Salary: Market‑aligned base pay with performance‑based bonuses.
• Comprehensive Health Coverage: Medical, dental, and vision plans that extend to eligible dependents.
• Retirement Savings: 401(k) plan with company match to help you build long‑term financial security.
• Employee Stock Purchase Plan (ESPP): Opportunity to purchase arenaflex stock at a discounted rate.
• Life & Disability Insurance: Protection for you and your loved ones.
• Paid Time Off (PTO): Generous vacation, holidays, and sick leave, with additional time off for seniority and tenure.
• Education Reimbursement: Financial support for tuition, certifications, and continuing education.
• Employee Assistance Program (EAP): Confidential counseling, legal, and financial guidance services.
• Retail Discounts & Travel Benefits: Access to arenaflex merchandise, travel services, and partner discounts.
• Flexible Work Arrangements: Remote work options, flexible scheduling, and a supportive work‑life balance.

How to Apply – Join arenaflex’s Data‑Driven Future

If you are ready to leverage your data engineering expertise to shape the future of a global retail powerhouse, we want to hear from you. Bring your passion for building reliable pipelines, your curiosity for emerging technologies, and your collaborative spirit to arenaflex. Apply today and start a rewarding career where your work directly influences the experiences of millions of shoppers worldwide.

Apply Job!