What are the responsibilities and job description for the Sr Business Intelligence Developer position at Mass General Brigham Health Plan?
The Opportunity
The Sr Business Intelligence Developer is vital to the team! You will use Microsoft Business Intelligence tools, primarily Microsoft SSMS, SSAS, and SSIS to maintain BI data structures in support of operational, clinical, and financial analysis. Support Data Scientists on the team with Microsoft SQL queries, ETL processes and Python.
What You'll Do
- Supports BI Development and works with the data scientists to support and learn what they are doing
-Works with end users, analysts, technical staff, and team members to plan, designs, develops, implements, and enhances business intelligence capabilities using Microsoft Business Intelligence tools.
-Assists with maintaining and troubleshooting issues with existing cubes, queries and processes.
-Develops efficient Microsoft SQL queries and data processes for Data Scientists on the team in support of Machine Learning and Artificial Intelligence.
-Assists end users, as a subject matter expert on existing company data, processes and business intelligence tools.
-Create clear documentation for users and technical staff.
-Follows established change control and versioning policies as pursuant with company standards and best practices.
-Serves as project manager for relevant analytics projects, including meeting facilitation, resource management, and stakeholder expectation setting.
-Provide training and mentorship to team, and end users on key analytic and reporting systems and databases when necessary.
Mass General Brigham Health Plan Holding Company, Inc. is an Equal Opportunity Employer. By embracing diverse skills, perspectives and ideas, we choose to lead. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.
Our promise as a people-first organization starts with our employees. AllWays Health Partners is committed to diversity, equity, and inclusion in our workforce, internal culture, and investments. As an equal opportunity employer, AllWays Health Partners recognizes the power of a diverse community and encourages applications from individuals with varied experiences, perspectives, and backgrounds.
- Bachelor's Degree Computer Science required or Bachelor's Degree Information Systems required
- MGB can review and consider experience in lieu of a degree
- Experience as a business intelligence developer or a similar role 5-7 years required
- Python experience and SSIS highly preferred
- BI SSAS cube development experience
Skills for Success
- Strong proficiency in SQL and experience with relational databases (e.g., SQL Server, Oracle, MySQL).
- Exposure to Azure. The newer BI tools require some Python, like Azure Data Engineering certs require you to use python for data manipulation.
- Expertise in Microsoft Business Intelligence data engineering tools (SSMS, SSAS and SSIS) Expertise in business intelligence and data visualization tools such as Microsoft PowerBI or similar.
- Solid understanding of data warehousing concepts, dimensional modeling, and ETL best practices.
- Knowledge of programming languages (e.g., Python, R) and statistical analysis techniques is a plus.
- Excellent analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
- Strong communication skills to effectively collaborate with stakeholders and present complex data insights in a clear and concise manner.
- Health Insurance industry experience is a plus.
Working Model
- M-F Eastern Business Hours Required
- A quiet, stable, secure, compliant work station is required
Mass General Brigham Health Plan Holding Company, Inc. is an Equal Opportunity Employer. By embracing diverse skills, perspectives and ideas, we choose to lead. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.
Our promise as a people-first organization starts with our employees. AllWays Health Partners is committed to diversity, equity, and inclusion in our workforce, internal culture, and investments. As an equal opportunity employer, AllWays Health Partners recognizes the power of a diverse community and encourages applications from individuals with varied experiences, perspectives, and backgrounds.