Sr. ETL & SQL- BI Developer

GENERAL SUMMARY: 

Under the direction of a Manager, Director or Lead/Experienced developer, implements a comprehensive program to extract data using a computer programming language or collect data, then analyze it and effectively report information from this data to a variety of customers in a user-friendly and actionable way. This position generates reports, develops tools and provides consultative support as needed. Our customers include physicians, physician groups, physician leaders, hospital leaders, the Board of Trustees, system leadership, transformation consulting, clinical/non-clinical services, Markets, Community, Service Lines, Revenue Cycle, Finance, external oversight/regulatory bodies, or any other user needing information. The Senior Business Intelligence Developer should be able to enhance the data driven culture within the Henry Ford health System, must be able to work in cross-collaboration to gather data, generate reports, develop automated tools, and provides actionable interpretation of information to all the customers. The candidate must be able to present information to customers at all levels, including but not limited to executives, physicians, clinical staff, peers, and external oversight/regulatory bodies. Independently develop comprehensive data assets, ad-hoc reports and implement new or improved reporting processes to support strategic goals, clinical efforts, and any business initiative. Must be able to work with least amount of direction, manage deadlines, maintain timeliness, delivery, and high quality of the products. Anticipate and quickly adapt to evolving needs of the customer. Consistently demonstrate excellent analytical and problem-solving skills while maintaining keen attention to detail. Candidate must be able to handle complex and ambiguous requests, maintain timeliness of delivery, data quality and manage changing deadlines. 

PRINCIPLE DUTIES AND RESPONSIBILITIES:

• Develop fabric notebook with Python, PySpark, and Spark for data processing and advanced analytics
• Design and publish Semantic models (Power BI datasets) to enable self-service and enterprise reporting
• Implement Lakehouse and Data Warehouse architecture within Microsoft Fabric
• Tells a story with data insights that are clear and discerning to help leaders make actionable decisions.
• Takes ownership of tasks, data assets, tools, and project goals to work towards overall success of the business initiatives.
• Works collaboratively with leaders and teams to understand how data solutions can make a positive impact.
• Consults, designs metrics, reports, and builds solutions as needed.
• Documents the process flows and ensures they are monitored for accuracy and quality, train others to create backup support.
• Provides end-user training on existing tools.
• Routinely participates in webinars and other educational resources to enhance understanding of current developments in healthcare environment.
• Generates suggestions for improving work efficiency and promoting quality, demonstrates accuracy and thoroughness.
• Guides customers to the central intake process, triage and fulfill report requests as assigned by the leader.
• Serves as a liaison between Analytics and business leaders.
• Research, reviews, and analyzes the effectiveness and efficiency of existing report procedures and develops strategies for enhancing or further leveraging these processes.
• Standardizes use of analytics tools and semantic layers throughout the organization.
• Anticipates and works strategically to guide team-members based on advanced knowledge of healthcare trends and requirements.
• Independently understands driving factors for data needs and provide data elements in addition to specific request.
• Self-manage projects and timelines.
• Other duties as assigned.