Build, operate and maintain reliable data pipelines and ETL processes on Microsoft Fabric and Azure SQL, and develop the certified datasets and Power BI dashboards the business uses, ensuring Arajet's teams receive accurate, timely and trusted data every day.
KEY ACCOUNTABILITIES:
Pipeline Development & Data Integration
Design, build and deploy ETL/ELT data pipelines using Microsoft Fabric (Data Pipelines, Dataflows, notebooks) and Azure Data Factory, loading data into the Azure SQL data warehouse and Fabric Lakehouse/Warehouse.
Integrate data from multiple airline source systems (e.g., PSS/reservations, sales and distribution channels, finance) into the data warehouse, ensuring accurate mapping and transformation.
Implement scheduled and incremental loads, optimizing pipelines for performance, cost and scalability.
BAU Pipeline Operations & Support
Monitor scheduled pipelines and loads daily, proactively detecting, troubleshooting and resolving failures to restore data flow with minimal business impact.
Ensure data freshness and availability meet agreed SLAs, performing root-cause analysis and permanent fixes for recurring incidents.
Maintain up-to-date technical documentation, data lineage and runbooks for all pipelines to guarantee operational continuity.
Data Quality, Governance & Security
Implement automated data quality checks (completeness, accuracy, consistency and reconciliation against source) and apply data governance, access and security policies to protect data assets.
Datasets & Dashboards
Build and maintain certified datasets and Power BI semantic models, and develop Power BI dashboards and reports together with BI analysts and business users, so BI delivers the "one version of the truth."
Engineering Practices
Manage code in Git and promote changes through deployment pipelines across development, test and production environments, following the standards defined by the VP Business Intelligence.
Collaboration & Knowledge Sharing
Partner with BI analysts, IT and business stakeholders to translate data requirements into solutions, and share knowledge and best practices within the team.
QUALIFICATIONS, EXPERIENCE, & SKILLS
Must Have:
- Bachelor's in Computer Science, Computer/Systems Engineering, Data Science or related field.
- 3+ years of experience in data engineering or ETL development.
- Strong SQL (SQL Server / Azure SQL) and data modeling skills.
- Hands-on experience building and maintaining ETL/data pipelines in production (Azure Data Factory, Fabric Data Pipelines, Dataflows).
- Python for data processing.
- Experience with Microsoft Fabric (Lakehouse, Warehouse, pipelines, notebooks) or the Azure data stack.
- Power BI (semantic models, DAX, dashboard development).
- Fluent Spanish; English at a conversational/professional level, able to understand and speak with English-speaking colleagues (native level not required).
- Available to work on-site in Santo Domingo, Dominican Republic.