Senior Business Intelligence Architect

Accreditation Council for Graduate Medical Education; United States; Remote; USD 115,000 - 136,000; Full time

Job summary

An established industry player is seeking a Senior Business Intelligence Architect to lead the design and implementation of a robust business intelligence platform. This role involves collaborating with data architects and engineers to develop and maintain analytics, reporting, and dashboard capabilities. The ideal candidate will have extensive experience with Microsoft Azure and Power BI, along with strong SQL skills. Join a dynamic team that values innovation and provides a comprehensive benefits package, including medical, dental, and wellness benefits. If you're passionate about driving data-driven decisions, this opportunity is perfect for you.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

Paid Time Off

401k Plan

Wellness Benefits

Qualifications

• 5+ years of experience in business intelligence roles.
• Proficient in Microsoft Azure and Power BI applications.
• Strong SQL skills and experience with data modeling.

Responsibilities

• Lead design and development of BI platform and dashboards.
• Manage BI deployment pipeline and oversee data governance.
• Supervise and mentor BI report developers.

Skills

Microsoft Azure

Power BI

SQL

Python

DAX

ETL Solutions

Data Warehouse Principles

Agile Methodologies

Education

Bachelor's Degree in Computer Science

Tools

Azure Data Lake

Azure Data Factory

Tabular Editor

DAX Studio

Job description

Senior Business Intelligence Architect

REGULAR FULL-TIMEProfessional

Chicago, IL, US

Salary Range:$115,175.00 To $135,500.00 Annually

The offered salary will be determined by a variety of factors including an applicant’s education, years of experience, knowledge, skills, and abilities as well as internal equity and alignment with market data.

Job Title:	SeniorBusinessIntelligenceArchitect
Department:	InformationServices
FLSA Status:	Exempt
Reports to:	Manager,DataAnalytics,Reporting,andQuality

The following describes the various aspects of the designated job. Some or all of these aspects may be changed over time, with or without notice, at the sole discretion of the Accreditation Council for Graduate Medical Education (ACGME).

Applicants must be currently authorized to work in the United States (US) on a full-time basis. The ACGME will not provide employment sponsorship for this position (e.g., H-1B Visa or other US employment authorization).

JOB OVERVIEW

Undergeneralguidance,willberesponsibleforleadingthedesign,development,andmaintenanceof the business intelligence (BI) platform implementation, semantic modeling, analytics, reporting, and dashboarding capabilities. This professional will work in collaboration with the appropriate data architects, data engineers, and business stakeholders to analyze, design, develop, test, and support enterprise-level BI solutions.

ESSENTIALFUNCTIONSAND RESPONSIBILITIES

• Leads the design and development of BI platform implementation, semantic modeling, analytics reporting, and dashboard capabilities.
• Leads the design build and management of BI models, reports, dashboards, and published apps including Power BI Report Builder for paginated reports.
• Manages tenants and capacity, tenant settings, gateways, workspaces, and security (such as role- based access control (RBAC) and row-level security (RLS)).
• Manages BI deployment pipeline/CI/CD process within Azure Dev Ops and GIT. Including approving pull requests between workspace environments and approving user acceptance testing outcomes after determining completion of user acceptance testing activities.
• Oversees enterprise-level dashboard design utilizing best practices for dataset governance and report file management system.
• Works closely with the manager, data analytics, reporting, and quality to develop BI report governance process, procedures, and auditing.
• Manages and mentors a team of BI report developers in developing new reports, enhancing and maintaining existing reports, and creating and maintaining documentation for enterprise BI solutions.
• Collaborates with training lead to develop BI training programs.
• Continuously stays abreast of industry best practices.
• Otherdutiesasassigned.

SUPERVISORY RESPONSIBILITY

Supervises, directs, and evaluates assigned staff member(s). Supervisory functions include: making hiringandterminationdecisions;prioritizingassignmentsanddirectingwork;developingandoverseeing employee work schedules and approving time away from work; providing and/or facilitating employee training and development; approving/processing employee concerns and problems and counseling or disciplining as appropriate; completing employee performance appraisals; determining or making recommendations regarding new hire salaries and salary changes; and acting as the liaison between employees and management.

QUALIFICATIONS

Minimum

• Bachelor’sdegreeincomputerscience,engineering,orarelatedscientificortechnicaldiscipline.
• Five years’ experience performing duties similar to those listed.
• Three years’ experience with Microsoft Azure database platform, including Azure Data Lake, Data Factory, and SQL.
• Three years’ experience with Microsoft Power BI applications, Embedded Power BI, and third-party external tools such as Tabular Editor and DAX Studio as well as with Power BI Desktop, Power BI service; experience in DAX functions and Power BI modeling.
• Three years’ experience creating user documentation and providing user training.
• Three years’ experience defining and designing dimensional models.
• Three years’ experience with enterprise integration, advanced analytics, and data models that support a federated architecture.
• Three years’ experience with system design and integration tasks, comprising design and implementation of major systems, integration of systems elements, and related support systems.

REQUIREDKNOWLEDGE,SKILLSETS,AND ABILITIES

• DemonstratedproficiencywithavarietyofMicrosoftapplicationdevelopmentanddatabase management tools.
• Knowledgeofdatawarehouseprinciplesandpractices,aswellasETLsolutions.
• KnowledgeofBItoolsandtechnologyinadditiontoPowerBI.
• Strong SQL and data extraction skills.
• Agility with additional programming languages such as Python and Scala.
• Demonstrated commitment to and compliance with the organization’s policies and procedures.
• Results-oriented focus; able to work independently and take initiative.
• Ability to implement projects and adhere to established timelines; must be able to work with various staff members and departments to complete projects.
• Comfort with ambiguity, variability, and change in business requirements.
• Ability to communicate clearly, effectively, and appropriately for the intended purpose and audience.

WORK ENVIRONMENT/CONDITIONS

• This position is based in a typical office environment with no specific or unusual physical or environmental demands.
• Most of the work performed is normally done in the ACGME office and/or a home office with the typical physical demands of an office environment.

BENEFITS

We offer a very attractive benefits package that includes medical, dental, and vision insurance, paid time off, 401k plan and other wellness benefits.

The ACGME is an Equal Opportunity Employer.