Lead BI Developer

Job not on LinkedIn

🔥 4 minutes ago

🇲🇽 Mexico – Remote

⏰ Full Time

🟠 Senior

📊 Business Intelligence Developer

👻 Ghost score 12%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Allstate

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1931

💼 Consulting

📦 Logistics

🛡️ Insurance

💰 Post-IPO Equity on 2014-01

Consulting • Logistics • Insurance

Allstate is an industry leader in providing insurance solutions, focusing on home, auto, device, and identity protection. With a commitment to customer well-being, Allstate aims to instill peace of mind and financial security for its customers. The company also emphasizes community impact and sustainability through various initiatives, showcasing their dedication to social responsibility and positive change.

📋 Description

• Design, develop, and maintain scalable enterprise data warehouse solutions • Build, optimize, and support ETL/ELT pipelines using modern data integration tools and frameworks • Develop and maintain data ingestion, transformation, and orchestration processes in Microsoft Fabric • Create and manage Fabric Data Engineering workloads, including Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, and Warehouses • Design and implement dimensional models using Star and Snowflake Schemas • Develop complex T-SQL code, including stored procedures, views, functions, and performance optimization • Build and maintain Power BI semantic models, reports, dashboards, and DAX measures • Develop data engineering solutions using Python and PySpark for large-scale data processing • Monitor data quality, troubleshoot issues, and implement data governance best practices • Collaborate with business users and technical teams to gather requirements and translate them into scalable data solutions • Participate in architecture reviews, code reviews, and technical design discussions • Support deployment, monitoring, performance tuning, and production support activities

🎯 Requirements

• 5+ years of experience in Data Engineering, Data Warehousing, or Business Intelligence • Extensive experience with SQL Server, T-SQL Development, SSIS, and enterprise data warehousing • Strong experience with dimensional modeling, including Star Schemas, Snowflake Schemas, Fact and Dimension Tables, and Slowly Changing Dimensions (SCD) • Hands-on experience with Microsoft Fabric, including Data Factory, Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, Data Warehouses, and OneLake • Strong experience using Python, PySpark, and Spark-based data processing • Advanced Power BI skills, including semantic models, dataset design, DAX development, dashboard development, and performance optimization • Experience with data integration, ETL/ELT frameworks, data quality processes, and data governance practices • Ability to work independently with minimal supervision • Strong analytical and problem-solving abilities • Excellent communication and stakeholder management skills • Strong documentation and organizational skills • Team-oriented mindset and willingness to mentor and share knowledge • Ability to manage multiple priorities in a fast-paced environment • Valid photo identification required at the start of virtual interviews, except for internal candidates • Microsoft Fabric Certifications preferred • Azure Data Engineering experience preferred • Experience implementing metadata-driven ingestion frameworks preferred • Experience building audit, logging, and monitoring solutions preferred • Knowledge of CI/CD processes and DevOps practices preferred • Experience supporting large-scale enterprise analytics platforms preferred • Experience with Agile/Scrum methodologies preferred

🏖️ Benefits

• Opportunity to develop skills and advance professionally • Opportunity to challenge the status quo and shape the future of protection • Opportunity to support causes that matter to employees • Camera-on virtual interview process • Interview accommodations available upon request