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 clients unique needs ensuring they feel confident and supported in every decision.

As both a franchise platform and direct insurance provider We Insure empowers likeminded 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 Were datadriven for better value and people led for better service. Our purpose is rooted in clarity guidance and longterm trust helping individuals and business owners make informed choices about their insurance coverage. Were building something meaningful and looking for purposedriven 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 infrastructureencompassing data pipelines data warehousing dashboarding and analytics solutions. You will collaborate with crossfunctional 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 daytoday dataloading 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 highquality standards in all published reports

Data Modeling & Governance

• Design and implement data schemas views and transformations to support comprehensive and efficient selfservice 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 companywide authentication solutions (Okta Auth0 or similar) to ensure secure user access and rolebased 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 endusers in sales marketing customer experience and finance addressing data inquiries troubleshooting issues and guiding on best practices for selfservice 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 companys 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).
• Handson 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 nontechnical 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 sprintbased development (e.g. Jira Trello)
• Exposure to containerization (Docker Kubernetes) or cloudbased 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 growtogether. Theyre more than just wordsthey 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

• Andwere just getting started

Our Total Rewards.

• Medical Dental Vision Life Pet; Flexible Spending Account

• Competitive Salaries

• 401K Match

• WorkLife Balance: Personal Days PTO Days 12 Paid Holidays Two Paid Days for Volunteer Service Paid Parental Leave

• Short and LongTerm 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 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: