Role overview
Integon is a part of The Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers’ evolving needs. It’s how we’ve become industry leaders in property and casualty insurance servicing. We support our insurance company affiliates by offering property and casualty insurance products inclusive of personal auto, homeowners, RV, motorcycle, small business auto insurance and more.
Job Description
The Business Intelligence Developer Lead Consultant provides the development, testing, implementation, and maintenance of complex Business Intelligence solutions and reports using the Microsoft SQL Server BI stack and/or other tools. This role is responsible for the aggregation of data from multiple sources into an efficient data warehouse and designing reporting solutions for very large multidimensional databases.
Key Responsibilities
• Evaluates and improves existing BI systems and processes
• Collaborates with teams to integrate systems
• Develops and executes database queries
• Develops standard reports and functional dashboards based on business requirements
• Translates complex business needs to technical specifications
• Designs, builds, and deploys complex BI solutions
• Maintains and supports data analytics platforms
• Conducts developer testing and troubleshooting
• Partners and collaborates with technical and non-technical stakeholders to solve complex business problems
• Develops and updates technical documentation
Education
• 4 year Bachelors Degree (Preferred)
Experience
• 5 or more years of experience (Preferred)
Supervisory Responsibilities
• This job does not have supervisory duties.
Functional Skills
• Knowledge of Structured Query Language (T-SQL)
• Advanced knowledge of the following skill sets: SSIS, SSRS, SSAS
• Knowledge of relational database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Knowledge of data warehouse design (e.g. dimensional modeling) and data mining
• Analytical mind with a problem-solving aptitude
• Development knowledge of all phases of Software Development Lifecycle
• Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint)
• Must possess excellent verbal and written communication skills
• Effective organization and time management skills with the ability to work under pressure and adhere to project deadlines
At Integon, great things happen when our people work together. That’s why when you join our team, we make sure it isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.
You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live.
Good Hands. Greater Together.®
In the event you need assistance or accommodation in completing your online application, please contact Integon via WhatsApp at 664.387.5841
Direct General Auto & Life, Personal Express Insurance, Century-National Insurance, ABC Insurance Agencies, NatGen Preferred, NatGen Premier, Seattle Specialty, National General Lender Services, ARS, RAC Insurance Partners, Mountain Valley Indemnity, New Jersey Skylands, Adirondack Insurance Exchange, VelaPoint, Quotit, HealthCompare, AHCP, NHIC, Healthcare Solutions Team, North Star Marketing, Euro Accident.
Our purpose
Providing protection to help people achieve their hopes and dreams has always been Allstate’s purpose. It’s the why behind everything we do.
Our purpose points us to our destination, but Our Behaviors help us get there.
Collaborate:
Being united helps us reach collective goals and brings out the best in each of us individually. It gives us more opportunities to learn, grow and add value to what we do each day.
Challenge Ideas:
In a world where change is certain, we want to lead it positively. So we rely on the collective expertise of our employees to consider different options and create the best path forward toward progress — in our industry and beyond.
Provide Clarity:
When expectations are clear, goals are easier to meet. We’re working together in new ways to make sure we know where we’re going and the role we all play in getting there. To save time and focus on what matters most: helping people achieve their hopes and dreams.
Provide Feedback:
Every bold idea deserves the chance to grow to excellence. Candid, helpful feedback empowers us to keep making things better for our customers, our communities and fellow employees.
Working in Sales
What We Do:
As an expert on our products and services, you can give customers personalized attention and innovative solutions to make their lives easier.
How We Support You:
Starting day one, you’ll have access to resources and incentives to keep you feeling challenged and excited about your careers.
Make An Impact:
As a member of our sales team, you’ll bring a sense of ease and support to customers looking for a better understanding of their protection options. Whether in the field or talking to customers over the phone, you’ll continue to build trust in who we are and what we do.
Working together
You’re in Good Hands ® is more than a promise we make to our customers. It’s a promise we make our employees, too.
As part of our team, we want you to love where you work, and that starts by giving you the freedom to be yourself. Our workplace flexibility and focus on inclusion creates an environment where you can connect and belong. Our goal is for you to feel trusted, heard and empowered to express yourself. When you thrive, we all thrive. And this year, we’re proud to share that we’ve been recognized by Forbes as one of America’s Best Employers For Diversity, and one of America’s Best Large Employers.
When you join us, you’ll have the opportunity to push your skills to the next level each day. Our dedication to continuous learning ensures that you have access to development programs designed to propel your career forward. As you learn and grow, so do we.
Working here also means getting the chance to do meaningful work and make a real impact in your community. We have been driving change for over 90 years, but the mark we leave on the world, can be even greater when we work together.
Good Hands. Greater Together.
Role overview
Integon is a part of The Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers’ evolving needs. It’s how we’ve become industry leaders in property and casualty insurance servicing. We support our insurance company affiliates by offering property and casualty insurance products inclusive of personal auto, homeowners, RV, motorcycle, small business auto insurance and more.
Job Description
The Business Intelligence Developer Lead Consultant provides the development, testing, implementation, and maintenance of complex Business Intelligence solutions and reports using the Microsoft SQL Server BI stack and/or other tools. This role is responsible for the aggregation of data from multiple sources into an efficient data warehouse and designing reporting solutions for very large multidimensional databases.
Key Responsibilities
• Evaluates and improves existing BI systems and processes
• Collaborates with teams to integrate systems
• Develops and executes database queries
• Develops standard reports and functional dashboards based on business requirements
• Translates complex business needs to technical specifications
• Designs, builds, and deploys complex BI solutions
• Maintains and supports data analytics platforms
• Conducts developer testing and troubleshooting
• Partners and collaborates with technical and non-technical stakeholders to solve complex business problems
• Develops and updates technical documentation
Education
• 4 year Bachelors Degree (Preferred)
Experience
• 5 or more years of experience (Preferred)
Supervisory Responsibilities
• This job does not have supervisory duties.
Functional Skills
• Knowledge of Structured Query Language (T-SQL)
• Advanced knowledge of the following skill sets: SSIS, SSRS, SSAS
• Knowledge of relational database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Knowledge of data warehouse design (e.g. dimensional modeling) and data mining
• Analytical mind with a problem-solving aptitude
• Development knowledge of all phases of Software Development Lifecycle
• Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint)
• Must possess excellent verbal and written communication skills
• Effective organization and time management skills with the ability to work under pressure and adhere to project deadlines
At Integon, great things happen when our people work together. That’s why when you join our team, we make sure it isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.
You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live.
Good Hands. Greater Together.®
In the event you need assistance or accommodation in completing your online application, please contact Integon via WhatsApp at 664.387.5841
Direct General Auto & Life, Personal Express Insurance, Century-National Insurance, ABC Insurance Agencies, NatGen Preferred, NatGen Premier, Seattle Specialty, National General Lender Services, ARS, RAC Insurance Partners, Mountain Valley Indemnity, New Jersey Skylands, Adirondack Insurance Exchange, VelaPoint, Quotit, HealthCompare, AHCP, NHIC, Healthcare Solutions Team, North Star Marketing, Euro Accident.
Our purpose
Providing protection to help people achieve their hopes and dreams has always been Allstate’s purpose. It’s the why behind everything we do.
Our purpose points us to our destination, but Our Behaviors help us get there.
Collaborate:
Being united helps us reach collective goals and brings out the best in each of us individually. It gives us more opportunities to learn, grow and add value to what we do each day.
Challenge Ideas:
In a world where change is certain, we want to lead it positively. So we rely on the collective expertise of our employees to consider different options and create the best path forward toward progress — in our industry and beyond.
Provide Clarity:
When expectations are clear, goals are easier to meet. We’re working together in new ways to make sure we know where we’re going and the role we all play in getting there. To save time and focus on what matters most: helping people achieve their hopes and dreams.
Provide Feedback:
Every bold idea deserves the chance to grow to excellence. Candid, helpful feedback empowers us to keep making things better for our customers, our communities and fellow employees.
Working in Claims
What We Do:
Your ability to quickly and calmly make smart decisions can make a huge difference in how confident customers feel throughout the claims process. And as you support our customers, we’re there to support you.
How We Support You:
We empower your success starting day one. You’ll have access to everything you need to grow professionally while helping our customers get their lives back on track.
Make An Impact:
Helping customers with their claims is about learning their stories, not just processing their paperwork. You can take pride in the fact that you’re providing invaluable guidance and helping to build continued trust in our company.
Working together
You’re in Good Hands ® is more than a promise we make to our customers. It’s a promise we make our employees, too.
As part of our team, we want you to love where you work, and that starts by giving you the freedom to be yourself. Our workplace flexibility and focus on inclusion creates an environment where you can connect and belong. Our goal is for you to feel trusted, heard and empowered to express yourself. When you thrive, we all thrive. And this year, we’re proud to share that we’ve been recognized by Forbes as one of America’s Best Employers For Diversity, and one of America’s Best Large Employers.
When you join us, you’ll have the opportunity to push your skills to the next level each day. Our dedication to continuous learning ensures that you have access to development programs designed to propel your career forward. As you learn and grow, so do we.
Working here also means getting the chance to do meaningful work and make a real impact in your community. We have been driving change for over 90 years, but the mark we leave on the world, can be even greater when we work together.
Good Hands. Greater Together.
Role overview
Integon is a part of The Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers’ evolving needs. It’s how we’ve become industry leaders in property and casualty insurance servicing. We support our insurance company affiliates by offering property and casualty insurance products inclusive of personal auto, homeowners, RV, motorcycle, small business auto insurance and more.
Job Description
The Business Intelligence Developer Lead Consultant provides the development, testing, implementation, and maintenance of complex Business Intelligence solutions and reports using the Microsoft SQL Server BI stack and/or other tools. This role is responsible for the aggregation of data from multiple sources into an efficient data warehouse and designing reporting solutions for very large multidimensional databases.
Key Responsibilities
• Evaluates and improves existing BI systems and processes
• Collaborates with teams to integrate systems
• Develops and executes database queries
• Develops standard reports and functional dashboards based on business requirements
• Translates complex business needs to technical specifications
• Designs, builds, and deploys complex BI solutions
• Maintains and supports data analytics platforms
• Conducts developer testing and troubleshooting
• Partners and collaborates with technical and non-technical stakeholders to solve complex business problems
• Develops and updates technical documentation
Education
• 4 year Bachelors Degree (Preferred)
Experience
• 5 or more years of experience (Preferred)
Supervisory Responsibilities
• This job does not have supervisory duties.
Functional Skills
• Knowledge of Structured Query Language (T-SQL)
• Advanced knowledge of the following skill sets: SSIS, SSRS, SSAS
• Knowledge of relational database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Knowledge of data warehouse design (e.g. dimensional modeling) and data mining
• Analytical mind with a problem-solving aptitude
• Development knowledge of all phases of Software Development Lifecycle
• Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint)
• Must possess excellent verbal and written communication skills
• Effective organization and time management skills with the ability to work under pressure and adhere to project deadlines
At Integon, great things happen when our people work together. That’s why when you join our team, we make sure it isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.
You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live.
Good Hands. Greater Together.®
In the event you need assistance or accommodation in completing your online application, please contact Integon via WhatsApp at 664.387.5841
Direct General Auto & Life, Personal Express Insurance, Century-National Insurance, ABC Insurance Agencies, NatGen Preferred, NatGen Premier, Seattle Specialty, National General Lender Services, ARS, RAC Insurance Partners, Mountain Valley Indemnity, New Jersey Skylands, Adirondack Insurance Exchange, VelaPoint, Quotit, HealthCompare, AHCP, NHIC, Healthcare Solutions Team, North Star Marketing, Euro Accident.
Our purpose
Providing protection to help people achieve their hopes and dreams has always been Allstate’s purpose. It’s the why behind everything we do.
Our purpose points us to our destination, but Our Behaviors help us get there.
Collaborate:
Being united helps us reach collective goals and brings out the best in each of us individually. It gives us more opportunities to learn, grow and add value to what we do each day.
Challenge Ideas:
In a world where change is certain, we want to lead it positively. So we rely on the collective expertise of our employees to consider different options and create the best path forward toward progress — in our industry and beyond.
Provide Clarity:
When expectations are clear, goals are easier to meet. We’re working together in new ways to make sure we know where we’re going and the role we all play in getting there. To save time and focus on what matters most: helping people achieve their hopes and dreams.
Provide Feedback:
Every bold idea deserves the chance to grow to excellence. Candid, helpful feedback empowers us to keep making things better for our customers, our communities and fellow employees.
Working together
You’re in Good Hands ® is more than a promise we make to our customers. It’s a promise we make our employees, too.
As part of our team, we want you to love where you work, and that starts by giving you the freedom to be yourself. Our workplace flexibility and focus on inclusion creates an environment where you can connect and belong. Our goal is for you to feel trusted, heard and empowered to express yourself. When you thrive, we all thrive. And this year, we’re proud to share that we’ve been recognized by Forbes as one of America’s Best Employers For Diversity, and one of America’s Best Large Employers.
When you join us, you’ll have the opportunity to push your skills to the next level each day. Our dedication to continuous learning ensures that you have access to development programs designed to propel your career forward. As you learn and grow, so do we.
Working here also means getting the chance to do meaningful work and make a real impact in your community. We have been driving change for over 90 years, but the mark we leave on the world, can be even greater when we work together.
Good Hands. Greater Together.
Benefits
Experience the benefits that make Allstate a great place to work.
*Benefits vary based on position.
Health
- Medical, dental and vision coverage
- HSAs and FSAs
- Wellbeing programs
- Free therapy sessions
Retirement
- 401(k) plan
- Pension plan
- Free financial counseling
Work-life balance
- Paid time off
- Work flexibility
Career development
- Talent shares
- Tuition reimbursement
- Learning opportunities
For a full description of Allstate’s benefits, visit allstate.jobs/benefits/
Start making a difference
Realize your full potential by doing
work that matters.
Grow your career in meaningful ways.
We want to make sure you have every opportunity to grow, explore new horizons and follow your passion in a meaningful career. It’s an exciting time to join Allstate. Help us shape the future.
Ryan D. / 6 years with Allstate
Sales Market Leader
October 2020 – Present
Anthony N. / 9 years with Allstate
Market Sales Associate Manager
February 2024 – Present
Michael K. / 23 years with Allstate
Property Delivery Director
2023 – Present/Remote
Bree M. / 8 years with Allstate
Unrepresented Bodily Injury Adjuster
December 2022 – Present
Rie T. / 9 years with Allstate
Unrepresented Severe/Complex Adjuster – Casualty 100
2023 – Present
Similar opportunities
Can’t find what you’re looking for?
Let’s stay in touch
If you are interested in being notified of future opportunities at The Allstate Corporation, please click the link below to join our careers community.
Eric G.
Associate counsel, Innovation Law
Our leaders understand that the world is changing fast and people need to adapt and learn new skills. Allstate is committed to helping employees continuously develop and grow.
Kelly
Cloud Engineer
Dana T.
Senior Product Consultant
Paul D.
Software Engineer
I’m proud of building Allstate’s first Bilingual Unlicensed Service team during my first assignment as a leader. It’s an exciting opportunity for our employees and to better serve our Spanish-speaking customers.
Xiomara
Employee Engagement Leader
Joe W.
Commercial Senior Claims Service Adjuster
Brooke T
Property Senior Claims Adjuster
Everyone is encouraged to volunteer and give back however they can throughout the year. I enjoy giving back to the community and supporting the causes that are meaningful to me.
Lisa
Senior Lead Internal Auditor
