logo

View all jobs

Manager, Enterprise Data Services

Philadelphia, PA
JPC is looking for a Manager, Enterprise Data Services that will be responsible for our client’s database environments, with a focus on providing a seamless flow of data throughout firm systems with consideration back-end data schemas and frontend accessibility for end-users. This role requires a deep understanding of database administration, data integration, and reporting tools. Strong and proven leadership, team management and project management skills are a must.
Responsibilities
  • Lead and mentor a team of data professionals, including database administrators and developer
  • Plan, execute, and manage data-related projects, ensuring they are completed on time and within budget
  • Provide operational support for all database environments
  • Participate in the creation, maintenance and enforcement of policies and procedures for ensuring the security and integrity of firm databases
  • Ensure database code is developed with industry best practices and performance in mind.
  • Manage and maintain the company SQL Server databases, ensuring high availability, performance, and security
  • Design, develop, and maintain ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS) to ensure accurate and efficient data flow within the organization
  • Create and maintain data integration workflows to support data warehousing and reporting needs
  • Develop, customize, and maintain reports using SQL Server Reporting Services (SSRS) to provide timely and accurate data to various teams
  • Collaborate with end-users to gather reporting requirements and deliver solutions that meet their needs
  • Be an escalation point for companywide SSRS and SSIS related questions
  • Develop, coordinate and implement installations, upgrades, patches, and backups related to SQL servers including testing of upgrades and patches along with backup verification
  • Develop, implement and administer PowerShell scripts for both operational and development tasks for both database integration and system integration
  • Assist with disaster recovery (DR) and high availability (HA) solutions including Availability Groups, Failover Clustering Instances, and Log Shipping
Requirements
  • 10+ years working with SQL Server and related technologies
  • 3+ years of experience in managing and leading a team of data professionals
  • Strong proficiency in development of T-SQL Script writing, testing, and debug in large software application systems
  • Strong knowledge of data integration, ETL processes, and data warehousing concepts
  • Understanding of indexes, index management, and database statistics
  • Strong verbal and written communication skills
  • Strong problem solving and critical thinking skills
  • Experience with Red-Gate Source Control preferred
  • Experience with PowerShell preferred
  • Experience with Ola Hallengren’s Maintenance Solution preferred
  • Experience with diagramming databases and environments (Erwin, Visio, etc.) preferred
  • Experience with CozyRoc SSIS toolset preferred
  • Experience with Windows Clustering preferred
  • This role is hybrid, 3 days a week in the office in Philadelphia, PA
  • Bachelor’s degree in computer science, business administration, information technology, or related field

Share This Job

Powered by