BI Developer Lead Consultant

1 month ago


Texas, United States Allstate Insurance Company Full time

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 Description

The Business Intelligence Developer Lead Consultant provides the development, testing, implementation, and maintenance of complex Business Intelligence solutions and reports through the use of 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 multi- dimensional databases.

Key Responsibilities:

Data Analysis and Reporting:
Develop, implement, and maintain BI solutions, including reports, dashboards, and data models.
Analyze complex data sets to identify trends, patterns, and insights.
Translate business requirements into technical specifications for BI solutions.

ETL Development:
Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into the data warehouse.
Ensure the accuracy, reliability, and performance of ETL processes.

Data Warehouse Management:
Design and maintain data warehouse architecture, including dimensional modeling and data integration.
Optimize data storage and retrieval processes to support reporting and analytics.

Collaboration and Communication:
Work closely with business stakeholders, business/systems analysts, and IT teams to understand data needs and deliver effective BI solutions.
Provide training and support to end-users on BI tools and reports.

Quality Assurance:
Conduct testing and validation of BI solutions to ensure data accuracy and consistency.
Troubleshoot and resolve data issues and discrepancies.

Continuous Improvement:
Stay updated with the latest BI technologies, tools, and best practices.
Continuously seek opportunities to enhance the efficiency and effectiveness of BI solutions.

Qualifications:
Education: Bachelors degree in computer science, Information Technology, or a related field.

Experience:
Minimum of 8 years of experience in BI development, data analysis, and data warehousing.

12+ months experience in Lender Place Insurance Tracking and Loss Draft business services,

associated processes, systems knowledge, and hands-on application development experience in

a lead role.

Minimum 2 years of experience working in a lead capacity with offshore developers.
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 understanding of data warehouse design principles and dimensional modeling.
Experience with cloud-based data platforms (e.g., Azure, AWS) is a plus.

Soft Skills:
Excellent analytical and problem-solving skills.
Strong communication and collaboration abilities.
Ability to manage multiple tasks and projects simultaneously.

#LI-JH1

Compensation

Compensation offered for this role is $104, ,750.00 annually and is based on experience and qualifications.

At National General, great things happen when our people work together. Thats why when you join our team, we make sure it isnt just a job its 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.

Youll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, weve 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 & Partners

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.

Benefits

National 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


  • Lead Power BI Analyst

    2 weeks ago


    Texas City, Texas, United States Saxon Global Full time

    Position Overview:As a Lead Power BI Analyst at Saxon Global, you will play a crucial role in transforming data into actionable insights that drive business decisions.Essential Skills and Qualifications:Key Competencies: Expertise in Power BI for data visualization and reporting. Strong proficiency in SQL and intermediate skills in Python. 8-12 years of...

  • Sr BI Developer

    3 months ago


    Texas City, United States Saxon Global Full time

    ESSENTIAL JOB FUNCTIONS To perform this job successfully, an individual must be able to satisfactorily perform each essential function listed below. • Design and develop ETL scripts using SQL, T-SQL or a leading edge data integration tool like SSIS • Must have experience working in building Data Warehouses and Data Marts. • Understand data...


  • Texas, United States AgnesCole Consulting Full time

    About the OpportunityAgnesCole Consulting is seeking a Senior Business Intelligence Lead to join our team on a full-time basis.The Senior Business Intelligence Lead will be an experienced professional with exceptional leadership skills and a robust background in data & analytics to drive the development of our Digital Transformation.This is an excellent...


  • Texas, United States E-Solutions Full time

    Position: Power BI AdministratorCompany: E-SolutionsWe are seeking a highly skilled professional with over 10 years of experience in Power BI administration. The ideal candidate will possess a robust understanding of the Power BI ecosystem, including both Power BI Server and Desktop.Key Responsibilities:Configure and oversee Power BI settings and resources,...

  • Power BI

    5 months ago


    Texas City, United States Saxon global inc Full time

    Role Power BI DeveloperLocation Dallas TX (Remote until Covid)Duration Long termJob Description Hands-on development experience with Microsoft Business Intelligence stack Effective verbal and written communication skills to interact with CFO and other leadership team members Ability to manage ambiguity and solve undefined problems Demonstrates...

  • Senior Tax Consultant

    2 weeks ago


    Round Rock, Texas, United States RES Consultant Group Full time

    Position OverviewA distinguished CPA firm is seeking a Senior Tax Consultant to join their team in a hybrid work environment. The ideal candidate will possess experience in the construction sector and familiarity with tiered partnership structures.About the FirmThis public accounting firm prioritizes the growth of its staff, the empowerment of its clients,...


  • Austin, Texas, United States GCS Technologies Full time

    Position Overview:As a Lead IT Project Consultant, you will oversee and execute a variety of IT infrastructure initiatives for diverse clientele, with a particular emphasis on Microsoft Azure and Office 365 technologies. Key Responsibilities:Your role will encompass managing projects that may involve cloud computing, server management, networking, data...


  • Texas City, Texas, United States QAD, Inc. Full time

    Job OverviewAs a Lead Sales Consultant at QAD, you will focus on acquiring new clients within the Manufacturing and Food and Beverages sectors.Your primary responsibility will be to drive software sales, ensuring that both company and personal sales targets are met. In this role, you will create marketing strategies that generate leads, manage your assigned...


  • Texas, United States The Page Group Full time

    About The Page GroupWe are a dynamic and innovative company seeking a highly skilled Senior Software Engineer to join our team in Austin, TX. As a key member of our engineering team, you will play a critical role in designing, developing, and maintaining complex business applications.Key Responsibilities:Technical Leadership: Lead and consult on feature...


  • Texas, United States AgnesCole Consulting Full time

    Position OverviewSenior Business Intelligence ManagerAgnesCole Consulting is seeking a highly skilled Senior Business Intelligence Manager to enhance our client's data-driven decision-making capabilities. This role is crucial for leading the charge in their Digital Transformation initiatives, leveraging extensive experience in data analytics and...

  • APIGEE Lead Developer

    20 hours ago


    Texas, United States Capgemini Full time

    Job Title: Apigee DevOps EngineerLocation: Remote OpportunityWe are seeking an experienced Apigee DevOps Engineer to manage and optimize our Apigee API platform for Capgemini. The ideal candidate will have a strong background in Apigee (OPDK, Hybrid), as well as expertise in DevOps tools and practices.Key Responsibilities:Manage and optimize Apigee API...

  • OBIEE Developer

    3 months ago


    Texas City, United States Five Cubes, Inc. Full time

    Job Title: OBIEE DeveloperLocation:Dallas,TXJob Description: The Oracle Business Intelligence Solution Architect will serve as a thought-leader for the data warehouse and business intelligence projects. This role will be responsible for requirements gathering, functional specifications, data modeling, security strategy, installation and configuration,...


  • Texas, United States MSS McKesson Sourcing Services Inc. Full time

    About the RoleMSS McKesson Sourcing Services Inc. is seeking a highly skilled Sales Operations Consultant to join our team. As a key member of our organization, you will play a critical role in driving business growth and success.Key ResponsibilitiesDefine and Maintain Sales Pipeline: Utilize market analysis to refine the drug pipeline and identify...


  • Texas, United States MSS McKesson Sourcing Services Inc. Full time

    About the RoleMSS McKesson Sourcing Services Inc. is seeking a highly skilled Sales Operations Consultant to join our team. As a key member of our organization, you will play a critical role in driving business growth and success.Key ResponsibilitiesDefine and Maintain Sales Pipeline: Develop and maintain a comprehensive sales pipeline through market...


  • Austin, Texas, United States Tech Firefly Full time

    Position OverviewTech Firefly is collaborating with a prominent insurance provider to recruit a Lead Actuarial Consultant to enhance their team.Key ResponsibilitiesFormulate and assess profitability standards for analyzing business unit performance.Monitor, evaluate, and communicate essential profitability indicators for both new and ongoing business to...

  • SAP BOBJ Consultant

    21 hours ago


    Texas City, United States Overture Rede Private Limited Full time

    Experience: 10 years of project management experience with at least 5 years in managing SAP BOBJ projects. BOBJ Expertise: Oversee the development and deployment of SAP BusinessObjects solutions including Web Intelligence (WebI) Crystal Reports Universe Design and Lumira. Ensure best practices are followed in the design development and deployment of BOBJ...


  • Texas, United States Gainwell Technologies LLC Full time

    About This RoleWe are seeking a highly skilled and experienced Software Engineering Manager to join our team at Gainwell Technologies LLC. As a key member of our organization, you will be responsible for leading a team of software engineers and ensuring the successful delivery of our products.Key ResponsibilitiesTeam Leadership: Manage and lead a team of...

  • Tax Manager

    6 days ago


    Round Rock, Texas, United States RES Consultant Group Full time

    Job Summary:We are seeking a highly skilled Tax Manager to join our team at RES Consultant Group. As a Tax Manager, you will be responsible for leading tax preparation and review projects, managing teams, and ensuring high-quality deliverables.Key Responsibilities:Lead tax preparation and review projects for clients in the construction industryManage teams...


  • Texas, United States Arka IT Solutions Full time

    About the RoleArka IT Solutions is seeking an experienced Applications Architect to join our team. As a key member of our project, you will be responsible for designing and developing custom applications using PowerApps that integrate Power Automate capabilities with SharePoint.Key ResponsibilitiesDesign and develop custom applications using PowerApps that...

  • SAP FICO Consultant

    4 days ago


    Texas, United States Numeric Technologies Full time

    About the RoleNumeric Technologies, Inc is seeking a highly skilled SAP FICO Consultant to provide expert services for our clients.Key Responsibilities:Involving with Architects and business partners for gathering requirements and design documentsUsing Agile methodology to analyze impact changes of current technologies when partners move from legacy systems...