VTL - Data Warehouse & Business Intelligence Developer

UNAVAILABLE; Indianapolis (IN); Remote; USD 110,000 - 130,000; Full time

Job summary

An innovative firm is seeking a skilled Data Warehouse & Business Intelligence Developer to enhance their BI capabilities. In this remote role, you'll leverage your extensive experience in Power BI and SSAS to develop and maintain critical reports and dashboards. Collaborating with the Product and Strategy team, you'll ensure data integrity while managing the software development life cycle. This position offers a chance to work with cutting-edge technologies and contribute significantly to data-driven decision-making. If you're passionate about data and eager to make an impact, this opportunity is perfect for you.

Benefits

Medical Insurance

Dental Insurance

Life Insurance

Disability Insurance

401k

Generous Paid Time Off

Qualifications

• 10+ years of IT experience with a focus on BI and Data Warehousing.
• 7+ years of Power BI report development and dashboard experience required.

Responsibilities

• Enhance and maintain BI reports and SSAS Tabular models.
• Design and develop self-service BI platforms and dashboards.

Skills

Power BI

SQL Server Analysis Services (SSAS)

Data Warehouse

Data Mining

Data Science (Python/R)

Debugging

Performance Tuning

Dimensional Modeling

Tools

Microsoft Fabric

Azure Data Warehouse

Tabular Editor

Azure DevOps

Job description

Overview

Vital Incite, an Alera Group company, is looking to add an experienced Data Warehouse & Business Intelligence Developer to their team.

Alera Group was founded in 2017 and has grown to become the 15th largest broker of US business. We are passionate about our clients’ success in the areas of Employee Benefits, Property and Casualty Insurance, Retirement Plan Services, and Wealth Services. With a network of offices nationwide, our commitment to collaboration allows us to offer national resources combined with local service.

The Data Warehouse & Business Intelligence Developer is responsible for developing and maintaining the Data Warehouse and business intelligence applications and reports. This position will work closely with the Product and Strategy team to understand business requirements, document, design, develop, and maintain all the BI reports hosted by Vital Incite. This is a remote opportunity. Must be comfortable working within eastern time zone business hours.

Responsibilities

• Enhance and maintain BI reports.
• Enhance and maintain SSAS (SQL Server Analysis Services) Tabular models and packages.
• Document, manage and enhance facts and dimensions with data integrity.
• Analyze data, design, develop and validate the BI reports and dashboards.
• Design, develop and maintain a self-service BI platform. Debug and validate any data issues reported.
• Provide support and training of Published reports and dashboards including solving for data issues reported.
• Manage the version control, migration and software development life cycle for all SSAS and BI reports changes.

Qualifications

• 10+ years of overall IT experience.
• 7+ years of hands-on Power BI report development and dashboard experience required.
• 5+ years of experience handling data warehouse, performance tuning SSAS Tabular Models required.
• Extensive experience in Data Warehouse and Data Mining using SSAS Tabular (SQL Server), Microsoft Fabric, Azure Data Warehouse tools and technologies.
• Experience with Targit report development is a plus.
• Experience working in dimensional models and creating new dimensional models.
• Experience diagnosing and enhancing dimensional models to enhance performance and meet new business needs.
• Experience with Data science methodologies for analyzing huge data sets, slicing and dicing and developing interactive reports and dashboards.
• Experience in debugging and performance tuning.
• Experience with software such as Tabular Editor and TMDL/Version control and SDLC in tabular models.
• Experience in building data marts and data modeling (Star/Snowflake Schemas) concepts for accurately defining dimensions, facts, and hierarchies.
• Experience in developing complex BI reports with the ability to drill down/up, and interactive dashboards.
• Experience in data science languages like Python or R is a plus.
• Experience in Azure technologies including Fabrics or Databricks is a plus.
• Absolute knowledge of software development life cycle, version control, and code migration. Experience with Azure DevOps is a plus.
• Working experience with SQL Server and SQL Queries.
• Familiarity in the healthcare domain with knowledge of medical claims, pharmacy claims, eligibility is a plus.

Additional Information

Alera Group offers comprehensive benefits to our colleagues, including medical, dental, life and disability insurance, 401k, generous paid time off, and much more.

Salary range is starting at $110,000, depending on experience.

We're an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status, or any other protected class.