Senior SQL Business Intelligence Developer

Senior SQL Business Intelligence Developer

800 W Fulton Market, Chicago, IL 60607 and may work remotely up to 2 days per week | Full time

The Aspen Group (TAG) is one of the largest and most trusted retail healthcare business support organizations in the U.S., supporting 15,000 healthcare professionals and team members at more than 1,000 health and wellness offices across 47 states in three distinct categories: Dental care, urgent care, and medical aesthetics. Working in partnership with independent practice owners and clinicians, the team is united by a single purpose: to prove that healthcare can be better and smarter for everyone. TAG provides a comprehensive suite of centralized business support services that power the impact of five consumer-facing businesses: Aspen Dental, ClearChoice Dental Implant Centers, WellNow Urgent Care, Lovet Animal Hospitals and Chapter Aesthetic Studios. Each brand has access to a deep community of experts, tools and resources to grow their practices, and an unwavering commitment to delivering high-quality consumer healthcare experiences at scale.

As a reflection of our current needs and planned growth we are very pleased to offer a new opportunity to join our dedicated team as a Senior SQL Business Intelligence Developer. This role is responsible for managing the definition, design, and development of reporting/dashboard for Aspen Dental Management, Inc., and for data integration from internal and external source systems into the Enterprise Data Warehouse (EDW).

Responsibilities

As a Senior SQL Business Intelligence Developer, you will be responsible for:

• Designing and developing complex ETL data loading packages
• Driving for and creating ETL architectural and development standards
• Adhering to ETL/DataWarehouse/Datamart development best practices
• Identifying and resolving any performance and/or data related issues
• Designing, constructing, deploying, testing, and supporting standard reports, dashboards, self-service queries and data visualizations
• Conducting data analysis of internal and external data sources
• Ensuring data is collected and structured in a way to ensure performance and maintainability
• Providing documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.)
• Providing production support of the data warehouse as well as ETL jobs used to support the data warehouse; this includes being an active member of the point rotation as well as providing support to other team members that are covering point

Minimum Education and Experience

Bachelor’s or foreign equivalent degree in Computer Science, Information Technology or closely related field and 5 years of experience in Business Intelligence including:

• 5 years with MSBI Stack – SQL Server DBMS, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS)
• 5 years of MS SQL Server Database Design/Development
• 5 years of Data Warehousing
• 5 years Microsoft SQL Development (T-SQL)

And demonstrated proficiency with:

• Data Modeling
• Source Control (TFS, RedGate, etc.)
• Project team leadership

OR

Master’s or foreign equivalent degree in Computer Science, Information Technology or closely related field and 3 years of experience in Business Intelligence including:

• 3 years with MSBI Stack – SQL Server DBMS, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS)
• 3 years of MS SQL Server Database Design/Development
• 3 years of Data Warehousing
• 3 years Microsoft SQL Development (T-SQL)

And demonstrated proficiency with:

• Data Modeling
• Source Control (TFS, RedGate, etc.)
• Project team leadership
   

This role is onsite in our Fulton Market office; may work remotely up to 2 days per week

Compensation: $153,650/year

A generous benefits package that includes paid time off, health, dental, vision, and 401(k) savings plan with match

Salary : $153,650