Lead BI Developer

This is a fully remote position, open to applicants in Mexico.

📋 Description

• Design, develop, and sustain scalable enterprise data warehouse solutions.

• Construct, optimize, and maintain ETL/ELT pipelines utilizing contemporary data integration tools and frameworks.

• Create and oversee data ingestion, transformation, and orchestration processes in Microsoft Fabric.

• Establish and manage Fabric Data Engineering workloads, encompassing Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, and Warehouses.

• Devise and implement dimensional models utilizing Star and Snowflake Schemas.

• Write advanced T-SQL code, including stored procedures, views, functions, and performance tuning.

• Construct and maintain Power BI semantic models, reports, dashboards, and DAX measures.

• Develop data engineering solutions using Python and PySpark for extensive data processing.

• Monitor data quality, resolve issues, and apply best practices for data governance.

• Collaborate with business users and technical teams to gather requirements and convert them into scalable data solutions.

• Engage in architecture reviews, code evaluations, and technical design discussions.

• Assist in deployment, monitoring, performance tuning, and production support activities.

⛳️ Requirements

• Minimum of 5 years of experience in Data Engineering, Data Warehousing, or Business Intelligence.

• Extensive knowledge of SQL Server, T-SQL Development, SSIS, and enterprise data warehousing.

• Strong expertise in dimensional modeling, including Star Schemas, Snowflake Schemas, Fact and Dimension Tables, and Slowly Changing Dimensions (SCD).

• Practical experience with Microsoft Fabric, such as Data Factory, Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, Data Warehouses, and OneLake.

• Proficient in Python, PySpark, and Spark-based data processing.

• Advanced skills in Power BI, including semantic models, dataset design, DAX development, dashboard creation, and performance tuning.

• Familiarity with data integration, ETL/ELT frameworks, data quality processes, and data governance practices.

• Ability to work independently with minimal oversight.

• Strong analytical and problem-solving skills.

• Excellent communication and stakeholder management abilities.

• Strong documentation and organizational capabilities.

• Team-oriented mindset with a readiness to mentor and share knowledge.

• Capacity to handle multiple priorities in a dynamic environment.

• Valid photo identification required at the beginning of virtual interviews, except for internal candidates.

• Microsoft Fabric Certifications are preferred.

• Experience with Azure Data Engineering is preferred.

• Experience in implementing metadata-driven ingestion frameworks is preferred.

• Experience in creating audit, logging, and monitoring solutions is preferred.

• Knowledge of CI/CD processes and DevOps practices is preferred.

• Experience supporting large-scale enterprise analytics platforms is preferred.

• Familiarity with Agile/Scrum methodologies is preferred.

🏝️ Benefits

• Opportunity to enhance skills and progress professionally.

• Chance to challenge existing norms and influence the future of protection.

• Opportunity to support meaningful causes that resonate with employees.

• Camera-on virtual interview process.

• Interview accommodations available upon request.