SQL BI Developer - Remote - Contract - Interviews This Week
Hi,
Hope you are doing well !!
Let me know if you are looking for any new remote job opportunity .
Business Intelligence Analyst
6 month contract with extension based on business need
Remote
Description: Substance abuse reporting resource. Business Analysis of Clinical functions to facilitate reporting, documentation and need for changes. Designs dashboards, data extracts, ad hoc queries and other BI solutions. Works with business stakeholders to gather requirements and ensure result validity. Works with Enterprise Data Warehouse team to ensure appropriate source data is captured.
Required skills:
• MS SQL Server- Developer, including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Data tools (SSDT).
• MySQL - DBA/Developer
• Microsoft Visual Studio – SSIS packages developer.
• AWS, S3 and CLI experience to enable Montefiore to switch to retrieving data from the cloud vs vendor pushing data over SFTP.
• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
• Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
• Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
• Experience working with SSIS packages
• Designing, implementing, maintaining, and optimizing MySQL databases, ensuring high availability, performance, and data integrity
• Send data via a secure mechanism from SMART to IMA.
• Create intake process and documentation for report request:
• Regulatory reporting, changes for Joint Commission, DEA, various NYS, NYC agencies.
• Reporting changes due to labor union and workflow issues for productivity analysis, patient outcomes, quality metrics
• Research data extracts and analysis
• Audit logging and analysis
Thanks
