Lead Data Engineer

The ESI Enablement & Platform Technology - Power BI Platform Team provides analytical services to business units and IS Stakeholders. In this role you will engineer, develop, and support the complete lifecycle of the Enterprise PowerBI/ Fabric Services Platform, PowerBI Reports for ESI EPT Service Lines & Strategic Projects, Caregiver Training, Data Warehouse, and a variety of Azure Services for ETL processes. The successful candidate will possess a strong understanding of Power BI Services, Data Analysis, and ability to articulate findings and recommendations to stakeholders.

Organization Background: At Providence, we are grounded in our goal to serve all as we engineer the future of healthcare. Providence Global Innovation Center, launched in Feb 2020, is the first development and innovation center of Providence outside the United States. Providence is a $26B non-profit organization and is one of the largest health systems in the United States.

The ESI Enablement & Platform Technology - Power BI Platform Team provides analytical services to business units and IS Stakeholders. In this role you will engineer, develop, and support the complete lifecycle of the Enterprise PowerBI/ Fabric Services Platform, PowerBI Reports for ESI EPT Service Lines & Strategic Projects, Caregiver Training, Data Warehouse, and a variety of Azure Services for ETL processes. The successful candidate will possess a strong understanding of Power BI Services, Data Analysis, and ability to articulate findings and recommendations to stakeholders.

What will you be responsible for

• Strong knowledge of PowerBI/Fabric Administration
• Strong knowledge of database and data analysis
• Strong knowledge of PowerBI/Fabric Service report development and administration.
• Integrate unstructured data from multiple systems to create a single source of truth
• Develop, monitor, and manage report curation and data modeling
• Creating/implementing/Adopting API Governance and Standards for Data Analytics
• Creating APIs to integrate unstructured data from a variety of systems to create a single source of truth (SailPoint, ServiceNow, Project Online, ADO, Intune, Azure licensing, and other systems of records for single/bi-direction data sets)
• Working on Azure Services like Azure Data Factory, Azure Workbook, Log Analytics, Azure Functions, and other data analytics tools
• Leveraging various Azure Services such as Azure Storage, Logic Apps, Data Factory, Azure SQL SaaS, Runbooks, Automation, Graph API, and various other data tools Developing/maintaining microservice automation (Prisma Cloud/Kubernetes)
• Proficient in data visualization, PowerBI, writing complex SQL queries using Spark SQL
• Building SharePoint intake forms w/power automate & bi-directional ADO integration
• Develop reporting solutions for Hosting platform involving Windows, Networking, VMWare, Storage and more

What would your day look like

• Work closely with service teams to determine project engagement and priority, business data reporting and analysis requirements
• Gather Requirements, Data and Create Power BI Reports
• Create scripts to support enhancements
• Work with external vendors on bi-directional API integrations
• Collaborate with PBI DWH and Reporting teams on data analysis and integrity
• Gather requirements, develop, and implement solutions across all endpoint technologies in the Microsoft stack

Who we are looking for

• Minimum 6-9 years of experience in Power BI Administration and Capacity management
• Minimum 6-9 years of experience in BI Development
• 6-9 years of experience working in cloud technologies such as Azure/AWS/Google cloud service
• Experience with Apache Spark and Azure Databricks
• Working knowledge of Microsoft Fabric
• Ability to troubleshoot technical problems, demonstrate problem solving
• Ability to effectively communicate and excellent interpersonal skills
• Experience working in Agile/sprints in a global team setup
• Bachelor's Degree in Computer Science, Data Analytics, Business Management, or IS