Senior BI Developer

🔥 3 hours ago

🇲🇽 Mexico – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Business Intelligence Developer

Where this job comes from

Posted on Allstate's careers page ↗Allstate's careers page, not through a job board

First seen by Remote Rocketship 3 hours ago

Still open on Allstate's site. Checked 4 minutes ago.

Apply Now
Logo of Allstate

Allstate

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 • Work independently while collaborating with stakeholders, analysts, architects, and engineers • No supervisory duties

🎯 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 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 • Ability to manage multiple priorities in a fast-paced environment • Equivalent combination of education and experience may be considered in lieu of the above education requirements • Valid Photo Identification available at the start of a virtual interview, except for internal candidates

🏖️ Benefits

• Opportunity to shape the future of protection while supporting meaningful causes • Virtual interview option • Interview accommodations available upon request

Apply Now

📊 Check your resume score for this job

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

Similar Jobs

🕒 April 1

Alten México

10,000+ employees

🚘 Automotive

💼 Consulting

Power BI Developer delivering enterprise analytics for supply chain, business, and finance at ALTEN Mexico. Building Power BI data models, reports, and predictive insights.

Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok