Let’s get started
By clicking ‘Next’, I agree to the Terms of Service
and Privacy Policy
Jobs / Job page
100% Remote- BI Developer Sr Cons II image - Rise Careers
Job details

100% Remote- BI Developer Sr Cons II

National General 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. We offer home, auto and accident and health insurance, as well as other specialty niche insurance products, through a large network of independent insurance agents, as well as directly to consumers.Job DescriptionThe Business Intelligence Developer Senior Consultant II provides the development, testing, implementation, and maintenance of moderately complex Business Intelligence solutions and reports within 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 assists with designing reporting solutions for very large multidimensional databases.Key Responsibilities• Adheres to documented SDLC steps and deliverables• Develops and updates technical documentation• Develops standard reports and functional dashboards based on business requirements• Develops and executes database queries and aids in development• Collaborates with teams to integrate systems• Assists with the evaluation and improvement of existing BI systems and processes• Conducts developer testing and troubleshooting• Maintains and supports data analytics platforms• Designs, builds, and deploys moderately complex BI solutions• Translates moderately complex business needs to technical specificationsEducation• 4 year Bachelors Degree (Preferred)Experience• 3 or more years of experience (Preferred)Supervisory Responsibilities• This job does not have supervisory duties.Education & Experience (in lieu)• In lieu of the above education requirements, an equivalent combination of education and experience may be considered.CompensationCompensation offered for this role is $74,240.00 - 114,120.00 annually and is based on experience and qualifications.At National General, 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.National General Holdings Corp., a member of the Allstate family of companies, is headquartered in New York City. National General traces its roots to 1939, has a financial strength rating of A– (excellent) from A.M. Best, and provides personal and commercial automobile, homeowners, umbrella, recreational vehicle, motorcycle, supplemental health, and other niche insurance products. We are a specialty personal lines insurance holding company. Through our subsidiaries, we provide a variety of insurance products, including personal and commercial automobile, homeowners, umbrella, recreational vehicle, supplemental health, lender-placed and other niche insurance products.Companies & PartnersDirect 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.BenefitsNational General Holdings Corp. is an Equal Opportunity (EO) employer – Veterans/Disabled and other protected categories. All qualified applicants will receive consideration for employment regardless of any characteristic protected by law. Candidates must possess authorization to work in the United States, as it is not our practice to sponsor individuals for work visas. In the event you need assistance or accommodation in completing your online application, please contact NGIC main office by phone at (336) 435-2000.
Allstate Glassdoor Company Review
3.4 Glassdoor star iconGlassdoor star iconGlassdoor star icon Glassdoor star icon Glassdoor star icon
Allstate DE&I Review
No rating Glassdoor star iconGlassdoor star iconGlassdoor star iconGlassdoor star iconGlassdoor star icon
CEO of Allstate
Allstate CEO photo
Thomas J. Wilson II
Approve of CEO

Average salary estimate

Estimate provided by employer
$58 / HOURLY (est.)
min
max
$55
$60

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About 100% Remote- BI Developer Sr Cons II, Allstate

Are you ready to take your Business Intelligence (BI) skills to the next level with National General? We're looking for a 100% Remote BI Developer Senior Consultant II to join our innovative team in Illinois. At National General, part of The Allstate Corporation, we thrive on pushing boundaries and anticipating our customers’ needs. In this role, you'll dive into developing, testing, implementing, and maintaining moderately complex BI solutions and reports with the Microsoft SQL Server BI stack. Your expertise will help us aggregate data from diverse sources into an efficient data warehouse, enabling us to design reporting solutions for vast multidimensional databases. Collaborating with multiple teams, you’ll assist in integrating systems while also evaluating and enhancing our existing BI frameworks. Your day-to-day will include crafting standard reports and functional dashboards based on business requirements, executing database queries, and troubleshooting. If you have a Bachelor’s degree and at least 3 years of experience in BI, we want to hear from you! Here, you’ll work in a flexible environment that values belonging and inclusivity, challenging you to grow your skills. Come be a part of something bigger with us—good hands, greater together at National General!

Frequently Asked Questions (FAQs) for 100% Remote- BI Developer Sr Cons II Role at Allstate
What are the main responsibilities of a BI Developer Senior Consultant II at National General?

As a BI Developer Senior Consultant II at National General, you'll be responsible for the development, testing, and maintenance of Business Intelligence solutions. Your main tasks will include creating standard reports, designing dashboards, and aggregating data from several sources into a data warehouse. You’ll collaborate closely with different teams to integrate systems and improve existing BI processes.

Join Rise to see the full answer
What qualifications are needed for the BI Developer Senior Consultant II position at National General?

To qualify for the BI Developer Senior Consultant II position at National General, candidates should have a Bachelor's degree, along with at least 3 years of relevant experience. While these are preferred, an equivalent combination of education and experience may also be considered. Familiarity with the Microsoft SQL Server BI stack is highly valuable.

Join Rise to see the full answer
Is the BI Developer Senior Consultant II position at National General a remote job?

Yes, the BI Developer Senior Consultant II position at National General is 100% remote, allowing you the flexibility to work from anywhere, while still being part of a dynamic and innovative team at National General, a member of The Allstate Corporation.

Join Rise to see the full answer
What is the compensation range for the BI Developer Senior Consultant II role at National General?

The compensation for the BI Developer Senior Consultant II at National General ranges from $74,240.00 to $114,120.00 annually. This is dependent on your experience and qualifications, ensuring that your expertise is rewarded competitively.

Join Rise to see the full answer
What kind of work environment does National General promote for the BI Developer Senior Consultant II?

National General promotes an inclusive and flexible work environment for the BI Developer Senior Consultant II position. The company is committed to diversity and belonging, encouraging employees to challenge themselves and contribute meaningfully to the team while supporting each other's growth.

Join Rise to see the full answer
Common Interview Questions for 100% Remote- BI Developer Sr Cons II
Can you describe your experience with the Microsoft SQL Server BI stack as a BI Developer?

When answering this question, focus on specific projects where you utilized SQL Server tools. Discuss how you designed and implemented BI solutions, highlighting your familiarity with tasks like data aggregation, report creation, and querying databases to illustrate your technical capabilities.

Join Rise to see the full answer
How do you approach troubleshooting in BI systems?

Explain your systematic approach to troubleshooting, such as identifying the source of data discrepancies, checking query performance, and utilizing logs to track down the issues. Providing a specific example of a troubleshooting experience can also strengthen your answer.

Join Rise to see the full answer
What is your experience with developing dashboards and reports?

Share your experience in creating dashboards and reports by discussing specific metrics and KPIs you tracked. Mention any tools used and how you gathered user requirements to ensure that the reports met stakeholders' needs effectively.

Join Rise to see the full answer
How do you prioritize tasks when working on multiple BI projects?

Discuss your time management strategies and methodologies, such as Agile or prioritizing based on business impact. Describe a scenario where prioritizing tasks allowed you to meet deadlines without compromising quality.

Join Rise to see the full answer
Tell us about a time you improved an existing BI process.

Select a relevant project where you identified a pain point in existing BI processes and discuss the changes you implemented. Be sure to note the positive impact your improvements had on workflow efficiency or data accuracy.

Join Rise to see the full answer
How do you ensure that your BI solutions align with business goals?

Emphasize the importance of collaborating with stakeholders to understand their objectives. Explain how you translate business needs into technical specifications and maintain consistent communication throughout the development process to align solutions effectively.

Join Rise to see the full answer
Can you explain the SDLC and its significance in BI development?

Discuss the Software Development Life Cycle (SDLC) phases, including planning, design, development, testing, and maintenance. Highlight how adhering to these steps ensures a systematic approach to BI development, resulting in high-quality and reliable BI solutions.

Join Rise to see the full answer
What data visualization tools are you familiar with?

Mention any data visualization tools you've worked with, such as Power BI, Tableau, or others. Discuss your experience in using these tools for data representation, creating visual narratives, and how they can enhance BI reporting.

Join Rise to see the full answer
Describe your experience working collaboratively in a team environment.

Provide an anecdote that underscores your teamwork skills. Focus on your ability to communicate effectively, share knowledge, and adjust to different working styles to achieve a common goal within your BI projects.

Join Rise to see the full answer
What are some best practices you follow when developing BI solutions?

Discuss best practices such as maintaining clear documentation, adhering to naming conventions, and ensuring data quality. You could also mention the importance of user feedback and iteration in improving BI solutions.

Join Rise to see the full answer
Similar Jobs
Photo of the Rise User
Posted 12 days ago
Photo of the Rise User
Posted 11 days ago
Photo of the Rise User
Posted 5 days ago
Photo of the Rise User
2U Remote Cape Town, South Africa // South Africa Remote
Posted 5 days ago
Photo of the Rise User
Dexterity Hybrid Portola Valley, CA
Posted 6 days ago
Photo of the Rise User
Posted 8 days ago
Posted 7 days ago
Posted 9 days ago

We are the Good Hands: We help customers realize their hopes and dreams by providing the best products and services to protect them from life's uncertainties and prepare them for the future.

99 jobs
MATCH
Calculating your matching score...
FUNDING
SENIORITY LEVEL REQUIREMENT
TEAM SIZE
EMPLOYMENT TYPE
Full-time, remote
DATE POSTED
December 16, 2024

Subscribe to Rise newsletter

Risa star 🔮 Hi, I'm Risa! Your AI
Career Copilot
Want to see a list of jobs tailored to
you, just ask me below!