Senior Business Intelligence Consultant

2 weeks ago


Aiken, United States National General Insurance Full time
Role Overview

National General Insurance is part of The Allstate Corporation, known for its innovative approach to meeting the dynamic needs of our customers.

We provide a range of insurance products, including home, auto, accident, and health insurance, along with specialty niche offerings, through a broad network of independent agents and direct-to-consumer channels.

Job Description

The Senior Business Intelligence Consultant is responsible for the design, development, testing, implementation, and ongoing support of sophisticated Business Intelligence solutions and reporting mechanisms utilizing the Microsoft SQL Server BI stack and other relevant tools.

This position involves consolidating data from diverse sources into a streamlined data warehouse and crafting reporting solutions for extensive multi-dimensional databases.


Key Responsibilities:
Data Analysis and Reporting:

  • Create, implement, and sustain BI solutions, including reports, dashboards, and data models.
  • Examine intricate data sets to uncover trends, patterns, and actionable insights.
  • Convert business requirements into technical specifications for BI initiatives.
ETL Development:

  • Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into the data warehouse.
  • Ensure the precision, reliability, and efficiency of ETL operations.
Data Warehouse Management:

  • Architect and maintain data warehouse structures, including dimensional modeling and data integration.
  • Enhance data storage and retrieval methods to facilitate reporting and analytics.
Collaboration and Communication:

  • Collaborate closely with business stakeholders, analysts, and IT teams to comprehend data requirements and deliver effective BI solutions.
  • Offer training and support to end-users on BI tools and reporting.
Quality Assurance:

  • Perform testing and validation of BI solutions to guarantee data accuracy and consistency.
  • Identify and resolve data discrepancies and issues.
Continuous Improvement:

  • Keep abreast of the latest BI technologies, tools, and best practices.
  • Continuously seek ways to improve the efficiency and effectiveness of BI solutions.
Qualifications:

Education:
Bachelor's degree in computer science, Information Technology, or a related discipline.

Experience:

  • Minimum of 8 years of experience in BI development, data analysis, and data warehousing.
  • At least 12 months of experience in Lender Place Insurance Tracking and Loss Draft business services, including associated processes and systems knowledge in a lead role.

  • Minimum of 2 years of experience leading offshore development teams.
  • Proficiency in BI tools such as Power BI, Tableau, or similar.
  • Advanced SQL skills and experience with ETL tools (e.g., SSIS).
Technical Skills:

  • Strong grasp of data warehouse design principles and dimensional modeling.
  • Familiarity with cloud-based data platforms (e.g., Azure, AWS) is advantageous.
Soft Skills:

  • Exceptional analytical and problem-solving capabilities.
  • Strong communication and collaboration skills.
  • Ability to manage multiple tasks and projects concurrently.

Compensation
Compensation for this role is competitive and based on experience and qualifications.

At National General Insurance, we believe in the power of teamwork. Joining our team means more than just a job; it’s an opportunity to enhance your skills, challenge the status quo, and make a meaningful impact.

We foster a flexible environment that values connection and belonging, and we are proud to have received numerous awards for inclusivity and diversity.

National General Holdings Corp., a member of the Allstate family, is headquartered in New York City and has a long-standing history in the insurance industry, providing a variety of personal and commercial insurance products.

Companies & Partners


We collaborate with various partners to deliver comprehensive insurance solutions.

Benefits

National General Holdings Corp. is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to any characteristic protected by law.

Candidates must possess authorization to work in the United States, as we do not sponsor individuals for work visas.

In case you require assistance or accommodation in completing your online application, please reach out to our main office.

  • Aiken, United States National General Holdings Corporation Full time

    Position Overview:The Senior Business Intelligence Consultant is responsible for the design, development, and implementation of sophisticated Business Intelligence solutions and analytical reports utilizing the Microsoft SQL Server BI suite and other relevant technologies. Key Responsibilities:1. Lead the development and maintenance of advanced BI systems.2....


  • Aiken, South Carolina, United States UDR Consulting Inc Full time

    Job DescriptionUDR Consulting, Inc. is looking for qualified candidates for a Senior Business Analyst Consultant role to provide support for complex projects and programs.Position Overview:The Senior Business Analyst Consultant will serve as a key advisor to senior management, overseeing the execution, development, implementation, and accountability of...


  • Aiken, South Carolina, United States UDR Consulting Inc Full time

    Job OverviewUDR Consulting, Inc. is looking for skilled professionals for the position of Senior Business Analyst for Project Controls. This role is essential for supporting complex project management initiatives.Key ResponsibilitiesLead the development, implementation, and oversight of comprehensive project control systems.Perform advanced financial...


  • Aiken, United States PMXperts Inc. Full time

    Job DescriptionJob DescriptionTitle: Business Analyst Senior AdvisorJob ID: 1123Location: Remote- Aiken, SC - Per Diem available for those who qualifyStart: Immediately, Long-term assignment Must be US CitizenRequirements:A Master's degree in business / construction management / technical / engineering or a related area and 12 years of practical...


  • Aiken, South Carolina, United States PMXperts Inc. Full time

    Job DescriptionPosition: Senior Business Analyst - Project Controls SpecialistLocation: OnsiteRequirements:Master's degree in business, construction management, technical, engineering, or a related field with 12 years of relevant experience.Bachelor's degree in a similar field with 15 years of relevant experience may be considered equivalent.Associate's...


  • Aiken, United States National General Holdings Corporation Full time

    Position Overview:The Senior Mainframe Software Consultant is responsible for the design, development, and maintenance of intricate Mainframe application solutions. This role involves utilizing technologies such as COBOL, IDMS, DB2, VSAM, and JCL to deliver high-quality software solutions.Key Responsibilities:1. Develop and implement complex software...

  • Business Analyst

    2 weeks ago


    Aiken, United States The Ladders Full time

    Spectra Tech has an immediate need for a Business Analyst - Senior Advisor in Aiken, SC. DUTIES Responsible for performing as the Senior Advisor to senior SRNS/DOE/NNSA Management for the execution, development, implementation, maintenance and accountability of total project controls, financial analysis or estimating applications. Also responsible for...

  • Sales Consultant

    2 months ago


    Aiken, United States Summit Business Group Full time

    Job DescriptionJob DescriptionJoin Our Compassionate Team at Summit Business GroupPosition: Direct Sales RepresentativeNumber of Openings: 1 Territory Sales Position AvailableAbout Us: At Summit Business Group, we're more than just an insurance agency. We're a growing family dedicated to offering superior supplemental benefits plans to small and...

  • Business Analyst

    2 weeks ago


    Aiken, United States Longenecker & Associates Full time

    DescriptionOVERVIEWLongenecker & Associates (L&A) seeks a motivated Business Analyst - Senior Advisor to contribute to our mission supporting our work at SRNS in Aiken, SC.L&A is a woman-owned small business and trusted partner enabling critical missions across the U.S. Department of Energy (DOE) complex for more than 30 years. We contribute to DOE's nuclear...


  • Aiken, United States Pinnacle Specialty Group, Inc. Full time

    Pinnacle Specialty Group is a woman-owned and operated small business specializing in providing project and contract management for Professional, Technical, Engineering, IT and Support Services. We offer full benefits to include: Medical, Dental, Vision, Paid Time Off, 401K - Company Matched.Duties and ResponsibilitiesResponsible for performing as the Senior...

  • Business Analyst

    1 month ago


    Aiken, United States Longenecker & Associates Full time

    Job DescriptionJob DescriptionOVERVIEWLongenecker & Associates (L&A) seeks a motivated Business Analyst - Senior Advisor to contribute to our mission supporting our work at SRNS in Aiken, SC.L&A is a woman-owned small business and trusted partner enabling critical missions across the U.S. Department of Energy (DOE) complex for more than 30 years. We...

  • Business Analyst

    2 weeks ago


    Aiken, United States Longenecker & Associates Full time

    Job DescriptionJob DescriptionOVERVIEWLongenecker & Associates (L&A) seeks a motivated Business Analyst - Senior Advisor to contribute to our mission supporting our work at SRNS in Aiken, SC.L&A is a woman-owned small business and trusted partner enabling critical missions across the U.S. Department of Energy (DOE) complex for more than 30 years. We...


  • Aiken, South Carolina, United States Longenecker & Associates Full time

    Job DescriptionOVERVIEWLongenecker & Associates (L&A) is seeking a dedicated Senior Business Analyst - Strategic Advisor to enhance our mission-driven initiatives. We are a woman-owned small business with over 30 years of experience supporting critical operations across the U.S. Department of Energy (DOE) complex. Our commitment lies in contributing to the...


  • Aiken, United States National General Insurance Full time

    Role Overview National General Insurance is a key player within The Allstate Corporation, embodying the innovative spirit that positions us ahead of our customers' changing needs. We provide a comprehensive range of insurance products, including home, auto, accident, and health insurance, alongside specialized niche offerings, through a vast network of...


  • Aiken, South Carolina, United States InterSources Full time

    **Job Title: ETL Architect****Location:** Hybrid**Duration:** 6+ Months ContractWe are seeking an experienced ETL architect to join our team at InterSources.The ideal candidate will have robust SQL Server experience and a strong understanding of data integration principles.Key responsibilities will include designing and implementing ETL processes, developing...


  • Aiken, United States National General Insurance Full time

    Role Overview National General Insurance, a member of The Allstate Corporation, embodies a forward-thinking approach that anticipates the dynamic needs of our clientele. We specialize in a range of insurance products, including home, auto, accident, and health insurance, along with niche offerings, delivered through a vast network of independent agents and...


  • Aiken, South Carolina, United States pmXperts, Inc. Full time

    Position Title: Senior Project Control SpecialistJob Overview:As a Senior Project Control Specialist at pmXperts, Inc., you will play a pivotal role in overseeing the comprehensive project control processes, ensuring effective financial management and scheduling throughout the project lifecycle.Key Responsibilities:Lead the establishment, execution, and...


  • Aiken, South Carolina, United States PMXperts Inc. Full time

    Job SummaryWe are seeking a highly skilled Senior Systems Engineer to join our team at PMXperts Inc. As a key member of our engineering team, you will be responsible for leading complex technical projects and developing innovative solutions to drive business success.Key ResponsibilitiesScope technical tasks and develop creative solutions to assigned...

  • Consulting Specialist

    2 weeks ago


    Aiken, South Carolina, United States UDR Consulting Full time

    UDR Consulting is actively seeking skilled professionals across various fields in preparation for an anticipated contract award. Available Work Locations include options for REMOTE or On-Site positions. Position Overview:We are looking for a Specialist in the following areas: Construction SupportMaterial ControlsPrincipal SpecialistDocument & Data...


  • Aiken, South Carolina, United States UDR Consulting Inc Full time

    Job DescriptionUDR Consulting Inc is seeking a qualified candidate for an IT Technical Business Analyst opportunity to support the company's IT initiatives.Key ResponsibilitiesProvide value-added services by streamlining business processes and focusing on producing quality and timely IT products and services.Support projects and modify strategic documents,...