Sr. Database Administrator & Data Engineer

$100,000 - $135,000/Yr

Rochester Regional Health - Rochester, NY

Full-time - Mid Level

Remote - Rochester, NY

Hospitals

About the position

The Sr. Database Administrator & Data Engineer at ACM Global Laboratories is responsible for leading the design, implementation, maintenance, and optimization of SQL Server databases and interactive business intelligence dashboards. This role emphasizes superior customer service and collaboration within the ACM Systems team, contributing to the organization's mission of improving healthcare outcomes. The position offers opportunities for professional growth and is part of a supportive team environment backed by a large healthcare network.

Responsibilities

• Design, implement, and maintain SQL Server databases to ensure data integrity, security, and optimal performance.
• Monitor and manage database performance, conducting regular tuning and optimization.
• Ensure high availability and disaster recovery solutions are in place for critical systems.
• Develop, construct, test, and maintain architectures such as databases and large-scale data processing systems.
• Build data pipelines to support data integration from various sources, including on-premise systems and cloud platforms like Azure and Snowflake.
• Implement and maintain ETL processes for efficient data movement and transformation.
• Plan and execute data migration projects, ensuring data quality and consistency during transitions between systems.
• Utilize tools like Informatica to automate and streamline data migration processes.
• Troubleshoot and resolve any issues related to data migration activities.
• Design, develop, and maintain interactive dashboards and reports using business intelligence tools such as Qlik, PowerBI, or Tableau.
• Perform data analysis to support business decisions, providing actionable insights based on trends and patterns.
• Collaborate with stakeholders to design and deploy data models that support analytical and reporting requirements.
• Collaborate with business users to gather requirements and translate them into technical specifications.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
• 5+ years of experience in database administration, data engineering, and reporting roles.
• Proficient in SQL and database management.
• Strong problem-solving skills and the ability to troubleshoot complex issues.
• Excellent communication skills, with the ability to work collaboratively with cross-functional teams.
• Ability to manage multiple projects and deadlines in a fast-paced environment.
• Familiarity with cloud-based data storage solutions and tools.
• Proven experience working with SQL Server, Azure, and Snowflake.
• Experience with business intelligence tools like Qlik Sense or Power BI.
• Experience with data migration tools such as Informatica is a plus.
• Demonstrated experience in managing projects and mentoring team members.
• Knowledge of data warehousing concepts and data modeling techniques.
• Experience participating in an on-call rotation and providing after-hours support.
• Ability to lead and manage initiatives within their area of expertise.

Nice-to-haves

• Master's degree preferred.

Benefits

• Pension Plan
• Retirement Plan
• Comprehensive Benefits Package
• Tuition Reimbursement
• Benefits Effective Date of Hire
• Same Day Pay through Daily Pay
• Employee Referral Program
• Employee Assistance Program
• Employee Discounts
• Paid Time Off & Holidays