Who We Are. 

At We Insure Group, we are passionate, driven, and purposeful in our mission to personalize protection at the right value. We believe in delivering tailored insurance solutions that meet each client’s unique needs, ensuring they feel confident and supported in every decision. 

As both a franchise platform and direct insurance provider, We Insure empowers like-minded entrepreneurs with the opportunity to own and operate successful agencies. With over 200 locations across 35 states, we support our agency owners, customers, and carrier partners by enabling faster service, greater efficiency, better choices, and improved results. 

What sets us apart? We’re data-driven for better value and people led for better service. Our purpose is rooted in clarity, guidance, and long-term trust helping individuals and business owners make informed choices about their insurance coverage. We're building something meaningful and looking for purpose-driven individuals to help lead the way. 

Location: Chicago, IL: Hybrid role

Your Impact.

We are seeking a skilled Business Intelligence Engineer with 3+ years of professional experience to join our growing analytics team. In this role, you will help develop and maintain our data infrastructure—encompassing data pipelines, data warehousing, dashboarding, and analytics solutions. You will collaborate with cross-functional stakeholders in sales, marketing, customer experience, and finance to deliver actionable insights that drive strategic decisions. Under the guidance of our EVP of Strategy, you will play a key role in continuously refining and scaling our Business Intelligence environment to meet evolving business needs.

Key Responsibilities

Data Warehouse & ETL Operations

• Develop and maintain reliable ETL pipelines (via Python or tools like Fivetran, Airbyte, etc.) to ingest data from multiple systems (e.g., CRM, marketing platforms, finance systems, customer support logs) into our data warehouse
• Oversee day-to-day data-loading jobs, ensuring timely, accurate, and complete data for analysis
• Troubleshoot and optimize ETL processes, focusing on performance and scalability

BI Dashboards & Reporting

• Build, maintain, and enhance interactive dashboards using Python (Plotly Dash) and Power BI (or similar tools)
• Collaborate with stakeholders across sales, marketing, customer experience, and finance to understand reporting requirements and develop meaningful data visualizations
• Ensure consistent data accuracy and high-quality standards in all published reports

Data Modeling & Governance

• Design and implement data schemas, views, and transformations to support comprehensive and efficient self-service analytics
• Contribute to a single source of truth by implementing and enforcing data definitions, standards, and documentation across the organization
• Partner with data owners to uphold best practices around data quality, security, and privacy

Ongoing Tool & Infrastructure Management

• Support the administration and scaling of the cloud data warehouse (e.g., AWS Redshift, Google BigQuery, or Snowflake)
• Monitor BI tool usage, recommend upgrades or migrations, and coordinate new feature rollouts
• Collaborate with infrastructure teams to manage resource allocation and control costs effectively

Authentication & Security

• Integrate dashboards and data pipelines with company-wide authentication solutions (Okta, Auth0, or similar) to ensure secure user access and role-based permissions
• Proactively address potential security vulnerabilities in the data pipeline and BI tools

Version Control & Collaboration

• Use GitHub or similar version control systems for managing ETL code, data modeling scripts, and dashboard configurations
• Participate in code reviews, maintain coding standards, and ensure thorough documentation for new features or changes
• Engage in agile or iterative development practices to deliver updates efficiently and respond to changing business needs

Performance Monitoring & Optimization

• Continuously improve query performance and dashboard responsiveness via indexing strategies, optimized data models, or caching
• Identify opportunities to streamline workflows, reduce latency, and enhance system reliability

User Support & Continuous Improvement

• Provide ongoing support to end-users in sales, marketing, customer experience, and finance, addressing data inquiries, troubleshooting issues, and guiding on best practices for self-service analytics
• Solicit feedback from stakeholders to refine dashboards, data models, and analytics processes, ensuring solutions evolve with business priorities
• Stay informed on emerging BI technologies and trends, recommending tools or methods that elevate the company’s analytics capabilities

Your Experience.

• 3+ years in a BI Engineer, Data Engineer, or similar analytics role
• Proficiency in SQL (complex queries, performance tuning, data modeling).
• Hands-on background with ETL/ELT pipelines (custom Python scripts, Airbyte, Fivetran, Stitch, etc.)
• Track record of building interactive dashboards in Python (Plotly Dash) or other BI platforms (Power BI, Tableau, Looker)
• Experience administering or working with cloud data warehouses (e.g., Redshift, BigQuery, Snowflake)
• Familiarity with version control (Git, GitHub) for collaborative development.
• Basic understanding of authentication and authorization (Okta, Auth0, or equivalent)
• Strong communication skills to translate technical concepts for non-technical stakeholders and collaborate across departments

Preferred.

• Experience with advanced data modeling techniques (star schemas, OLAP cubes, dimensional modeling)
• Knowledge of data governance frameworks and data privacy regulations (e.g., GDPR)
• Background in agile methodologies or sprint-based development (e.g., Jira, Trello)
• Exposure to containerization (Docker, Kubernetes) or cloud-based DevOps pipelines (CI/CD)
• Familiarity with sales, marketing, customer experience, or finance domain metrics and KPIs

Our Values. The We Way. 

At We Insure, Group our values shape how we work, how we lead, and how we grow—together. They’re more than just words—they guide every interaction, every decision, and every customer experience. 

We Way Reflects Our Commitment to.  

• We personalize protection at a price you can trust 

• We hustle to find opportunity 

• We care authentically 

• We thrive in ambiguity 

• We own our results 

• We have fun along the way 

• And—we’re just getting started 

Our Total Rewards.  

• Medical, Dental, Vision, Life, Pet; Flexible Spending Account 

• Competitive Salaries 

• 401K Match   

• Work-Life Balance: Personal Days, PTO Days, 12 Paid Holidays, Two Paid Days for Volunteer Service, Paid Parental Leave 

• Short and Long-Term Disability 

• Employee Support Programs, Including Mental Health 

• Tuition Reimbursement   

• Matching Charitable Gift Program 

• Lucrative Referral Program 

This position is not able to be performed in California, Colorado, New York or Washington. 

 EEO

We Insure Group is an equal opportunity employer that does not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, and gender identity), national origin, age, disability, veteran status, marital status, or any other protected characteristic. Our hiring practices ensure that all qualified applicants receive fair consideration without regard to these characteristics.

Disability

We Insure Group is committed to creating an inclusive and accessible workplace for all candidates, including those with disabilities. We are dedicated to ensuring equal employment opportunities and providing reasonable accommodations to qualified individuals with disabilities. If you require reasonable accommodations to participate in the application or interview process, please contact our HR department at hrinfo@peak6insurtech.com. We will work with you to provide the necessary accommodations to ensure your full participation in our hiring process.

Note to applicant: It is unlawful in Massachusetts and Maryland to require or administer a lie detector test as a condition of employment or continued employment. Please know that our company does not use lie detector tests in our hiring process. 

Base Salary Range: