Power BI Developer

Description

Gather, understand and critically evaluate information and reporting requirements from multiple sources to ensure alignment with Montefiore’s strategic goals and to decompose high-level information into details. Successfully engage in multiple initiatives simultaneously. Serve as the liaison between internal and external customers and subject matter experts (SMEs)/EDW team. Design and develop creative BI components for the delivery of dashboards, scorecards, delivered reports, ad hoc queries, extracts and analytics. Utilize existing enterprise BI tool set (e.g., SQL Server Reporting Services, SS Analysis Services, SharePoint, Crystal) and web services that provide standard analytic computations that can be leveraged in multiple BI solutions. Work with customers to ensure user acceptance testing and complete delivery of reporting/analysis solution. Keeps abreast of trends and best practices in the industry to strengthen organizational and technical knowledge as it relates to BI.  The main applications are SMART the Electronic Medical Record (EMR) for Substance Abuse, and IMA (revenue cycle – specialized Substance Abuse Billing).

Responsibilities

• • Need 10+ years of experience
• • MS SQL Server- Developer, including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Data tools (SSDT). Required
• • MySQL - DBA/Developer Required
• • Microsoft Visual Studio – SSIS packages developer. Required
• • AWS, S3 and CLI experience to enable Montefiore to switch to retrieving data from the cloud vs vendor pushing data over SFTP. Required
• • Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process Required
• • Builds data transformations with SSIS including importing data from files, moving data from one database platform to another Required
• • Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
• • Experience working with SSIS packages Required
• • Designing, implementing, maintaining, and optimizing MySQL databases, ensuring high availability, performance, and data integrity Required
• • Send data via a secure mechanism from SMART to IMA. Required
• • Create intake process and documentation for report request: Required
• • Regulatory reporting, changes for Joint Commission, DEA, various NYS, and NYC agencies. Required
• • Reporting changes due to labor union and workflow issues for productivity analysis, patient outcomes, and quality metrics Required
• • Research data extracts and analysis Required
• • Audit logging and analysis Required