Commercial Analytics SQL ETL Developer - Raleigh, United States - Merz Therapeutics

Description

We are seeking local candidates only as this role is onsite in Raleigh, NC. 3 days in office, and 2 days remote

This is primarily a technical backend role including predominantly SQL ETL development, SSIS and data prep to partner with our Business side Data Analyst who focusses more on the front end and visualization


Who We Are:
Harvesting Hope with a Growing Family

At Merz Therapeutics, we take a nurturing approach to our organization - treating colleagues like family, embracing our whole selves and creating a company culture that encourages growth and decisive action.

We are committed to caring for whole communities by focusing on individuals suffering from movement disorders and neurological conditions and the healthcare providers dedicated to helping them, while simultaneously bolstering our team members in a united effort to make a difference.

As a private, family-owned company, we have the liberty and support to make decisions for ourselves, our customers and the patients we serve.

We pride ourselves on building an inclusive culture where there is room to celebrate individual growth and the ability to contribute to a common good as a collaborative team.

Our mission is grounded in a long-term view of making a difference for the common good, while growing together as a family.

If you're looking to immerse yourself in a passionate team rooted in community, connection and camaraderie, then we're looking for YOU #IAmMerzTx

Are you a self-starter, and do you thrive in entrepreneurial environments?

As the Commercial Analytics SQL Developer, you, you will be responsible for developing and maintaining robust ETL processes using SQL Server Integration Services (SSIS) and SQL Server Management Studio (SSMS), along with a working knowledge of SAP.

This role is critical in supporting our commercial operations by ensuring seamless data integration, enhancing automation and maintaining rigorous data governance and management standards.

You will work closely with the Commercial Business Partner, Analytics, CRM, and IT Team to optimize data flows and support business intelligence initiatives


Are you ready to galvanize a team around a culture of care, putting patients first to spark change? Apply TODAY

Essential Duties and Responsibilities


1.

ETL Development and Maintenance

Design, build, and maintain efficient, reliable, and reusable ETL processes using SSIS. Ensure the stability, integrity, and smooth operation of ETL tasks and data workflows.


2.

Database Management

Utilize SSMS to manage SQL Server databases, optimize queries, and ensure performance tuning. Collaborate with IT and data teams to ensure database security, backup, and recovery plans are robust and up-to-date.


3.

Data Governance

Implement and maintain data governance practices to ensure data accuracy, consistency, and security across all data management activities.


4.

Commercial Data Management

Work with the Commercial Analytics and Sales Operations team to manage and optimize commercial data storage, processing, and utilization. Develop and implement data standards and policies.


5.

Cross-Functional Collaboration

Partner with commercial stakeholders to understand their data needs and ensure the ETL processes and data management practices support their strategic objectives.

6.

Integration with SAP

Collaborate with IT to leverage SAP data and systems to streamline data extraction and integration processes. Ensure that data handling between SAP and our databases meets business needs and complies with data governance standards.


7.

Project Management

Manage projects related to data integration, automation, and improvements, ensuring they are delivered on time and meets business requirements.


Education

• Bachelor's degree in Computer Science, Engineering, Information Systems or Analytics Related Field

Required


Professional experience

• Minimum 35 years of experience in SQL development, specifically with strong expertise in SSIS and SSMS.

Required

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.

However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.

41 CFR c)