Sr. Database Administrator & Data Engineer

DescriptionHOW WE CARE FOR YOU:At ACM Global Laboratories, we are dedicated to getting health care right. Our robust benefits and total rewards foster employee wellbeing, professional development and personal growth. We care for your career while improving patients lives.Pension PlanRetirement PlanComprehensive Benefits PackageTuition ReimbursementBenefits Effective Date of HireSame Day Pay through Daily PayEmployee Referral ProgramEmployee Assistance ProgramEmployee DiscountsPaid Time Off & HolidaysSUMMARYAs a member of the ACM Systems team, The SQL Database Administrator leads the design, implementation, maintenance and optimization of SQL Server Databases and interactive business intelligence dashboards. Provides superior customer service by modeling the Brand Promise and Core Values.ACM Global Laboratories is a growing international organization that provides continued opportunities for internal advancement. At ACM you will be part of a team that is focused on improving people's lives where you are supported by leadership and colleagues. We are backed by a large healthcare network in the complex and rewarding field of advanced laboratory science. Your voice is heard, and with that, you have an ability to make an impact on the organization and influence your professional growth.STATUS: Full TimeLOCATION: RemoteDEPARTMENT: Information TechnologySCHEDULE: DaysATTRIBUTESBachelor'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.Master's degree preferred.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 techniquesExperience participating in an on-call rotation and providing after-hours supportAbility to lead and manage initiatives within their area of expertise.RESPONSIBILITIESDatabase Administration/Engineering 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.Cross-Functional Communication 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.PHYSICAL REQUIREMENTS: L - Light Work - Exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force frequently, and/or a negligible amount of force constantly; requires occasional walking, standing or squatting.PAY RANGE: $100,000.00 - $135,000.00The listed base pay range is a good faith representation of current potential base pay for successful applicants. It may be modified in the future. Pay is determined by factors including experience, relevant qualifications, specialty, internal equity, location, and contracts.Rochester Regional Health is an Equal Opportunity / Affirmative Action Employer. Minority/Female/Disability/VeteranMinimum Salary: 100000.00 Maximum Salary: 135000.00 Salary Unit: Yearly