BI Developer Senior - Lead | New York, NY, USA

BI Developer Senior - LeadJoin Forbes' 2024 Best Employer for Diversity!As a BI developer senior-lead in the Commercial Lines group you'll assist our business partners with their data analysis and reporting. This will include your coding of complex, cost-effective ETLs/ Dimensional models/reporting solutions for business related problems. You'll interact daily with our business partners, serving as a knowledge expert to prepare business specific data analysis, build new and maintain existing ETL structures, multidimensional cubes, and reporting to aide in their decision making. Participation in the on-call support rotation is required. Remote work allowed.Must-have qualifications• Bachelor's degree or higher in an Information Technology or Business discipline or related field of study (e.g., Computer Science, MIS, Business Management) and a minimum of 2 years designing/developing, programming and supporting software programs/applications.• In lieu of a degree, a minimum of 5 years related work experience with working knowledge of designing/developing, programming and supporting software programs/applications.Preferred skills• Proficient with Snowflake and with scripting languages like Python to aid with complex ETL structures & along with some application development knowledge. Knowledge of Big Data technologies and Cloud (i.e., Azure, AWS) is a plus.• Experience in design and implementation of ETL framework for complex data mart projects. Plus, experience in multiple database platforms, including SQL Server and DB2.• Thorough working knowledge Microsoft BI stack SSIS including recent versions of SQL Server. Working knowledge of SSAS / another multidimensional model is a plus.• Knowledge of data modeling, data warehousing, and data quality with proven ability to build solution-oriented data models (i.e., architecture, business process, design, and the implementation of automation).• Strong analytical and communication skills, and business acumen, with an appetite for continuously developing, adapting, and improving tools, processes, and services as business needs evolve.Compensation• $105,000 - $132,000yeardepending on position level and experience• Gainshare bonus up to 30-40% of your eligible earnings based on level and company performanceBenefits• 401(k) with dollar-for-dollar company match up to 6%• Medical, dental & vision, including free preventative care• Wellness& mental health programs• Health care flexible spending accounts, health savings accounts, & life insurance• Paid time off, including volunteer time off• Paid & unpaid sick leave where applicable, as well as short & long-term disability• Parental & family leave; military leave & pay• Diverse, inclusive & welcoming culture with Employee Resource Groups• Career development & tuition assistance• Onsite gym & healthcare at large locationsEnergage recognizes Progressive as a 2024 Top Workplace for: Innovation, Purposes & Values, Work-Life Flexibility, Compensation & Benefits, and Leadership.Sponsorship for work authorization for foreign national candidates is available for this position. Individuals in F-1 visa status who will need sponsorship now or in the future are not eligible for hire for this position.Equal Opportunity EmployerFor ideas about how you might be able to protect yourself from job scams, visit our scam-awareness page at https://www.progressive.com/careers/how-we-hire/faq/job-scams/#LI-Remote