Location: Mount Laurel,NJ, USA
Job Description: Design strategies for enterprise databases, data warehouse systems, and cloud data systems. Develop complex ETL (extract, transform and load) scripts in SSIS, Azure Data Factory and Information to integrate external data sources with Pinnacle Enterprise Data Warehouse. Develop database archiving and partitioning strategy to improve performance and enforce retention. Create and enforce database development standards. Act as technical lead for strategic and enterprise-level data projects. Lead data integration between behavioral health Electronic Medical Record systems (EMR) and Revenue Cycle System. Develop a custom Master Patient Index that aligns patient information across disparate systems. Perform day-today operations of enterprise data warehouse and analytics platform, including monitoring and maintenance, database optimization and tuning, backup creation and maintenance, and troubleshooting. Create enterprise-level end-to-end data flow diagrams and logical data models. Develop and review complex SQL/T-SQL scripts and stored procedures for reporting and data development projects. Perform data cleanup and data migration. Implement and manage a Master Data Management system. Support data audits and periodic database disaster recovery exercises. Perform critical maintenance, deployment, and release support activities, including occasional off-hours support. Remote work is available for this role. Position reports to management in Mt. Laurel, NJ or other remote locations. Job Requirements: Requires a Master's degree in Computer Science or Engineering (including Electrical) and 3 years of experience. Must have experience in each of the following skills: SSIS, Azure Data Factory, and Informatica ETL; SQL and T-SQL scripting; designing, building, and maintaining star schema data warehouses in Microsoft SQL Server; database security, backups, recovery, partitioning, performance, and monitoring; data modeling, data management, data quality, and master data; query tuning using profiler, index, and execution plan optimization; SQL Agent management and troubleshooting; SSIS components including ZappySys; integration methods including REST APIs, scheduled file movers, and cross-database movement; and CI/CD tools including Git and Azure DevOpsContact: Email resume to ...@pinnacletreatment.com