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.
The office is based in Indiana, but we're open to remote employees within the Eastern Time Zone.
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
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 model 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 modelling (Star/Snowflake Schemas) concepts for accurately defining dimensions, facts and hierarchies.
Experience in developing complex BI reports with ability to drill down/up, and interactive dashboards.
Experience in data science language 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 healthcare domain with knowledge of medical claims, pharmacy claims, eligibility is a plus.
BENEFITS
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 $110K to $125K per year, based on experience.
We're anequal 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.
Alera Group is committed to protecting your privacy. Please review our Privacy Policy to understand what personal information we may collect and use as part of your application process.
#LI-AM2
#LI-Remote
Qualifications:
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 model 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 modelling (Star/Snowflake Schemas) concepts for accurately defining dimensions, facts and hierarchies.
Experience in developing complex BI reports with ability to drill down/up, and interactive dashboards.
Experience in data science language 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 healthcare domain with knowledge of medical claims, pharmacy claims, eligibility is a plus.
Education:UNAVAILABLEEmployment Type: FULL_TIME
Alera Group logo
About Alera Group
Alera Group is an independent, national insurance and financial services firm based in Deerfield, IL, US. Established in 2017, it has grown swiftly to become one of the top independent, national insurance and financial services firms in the US, signifying its origins from 24 entrepreneurial companies spread across the nation. The company operates within the insurance sector, providing a broad range of sophisticated solutions for employee benefits, property, and casualty, retirement services, and wealth management. Alera Group is built on a unique model of collaboration and is driven by its mission to can create positive impacts using its resources and expertise.
Show More