The Job/What You'll Do:

Adhesion is seeking a highly skilled SQL Data Transformation Developer to join our Systems Operations team. The ideal candidate will have a strong background in SQL, data transformation, and ETL processes. You will be responsible for designing, developing, and maintaining complex SQL queries and data transformation pipelines to support our business intelligence and application needs.

We can consider candidates for this position who are able to accommodate a hybrid work schedule and are close to our office location in Charlotte, NC.

Responsibilities:

• Design, develop, and optimize SQL queries and stored procedures for data extraction, transformation, and loading (ETL) processes.
• Collaborate with data analysts and other stakeholders to understand data requirements and translate them into efficient SQL solutions.
• Implement and maintain data pipelines for data integration from various sources into our data warehouse.
• Develop and maintain documentation for SQL processes, data models, and data flow diagrams.
• Perform data quality checks and ensure data consistency and accuracy in the data warehouse.
• Troubleshoot and resolve SQL-related issues in the data transformation process.
• Collaborate with the IT team to ensure database performance, security, and scalability.
• Stay up-to-date with industry trends and best practices in SQL development and data transformation.
• Other duties as assigned

Knowledge, Skills, Abilities:

• Expert at Microsoft SQL Server and SQL Server Integration Services (SSIS)
• Refactoring and increasing performance of existing ETL workflows
• Experience with ETL tools and processes.
• Excellent problem-solving and analytical skills.
• Ability to multitask as well as being able to collaborate in a team environment
• Strong attention to detail and positive attitude
• Experience with Microsoft Server Stack
• Experience working with SQL Server in Azure and On Prem
• Experience with Microsoft SQL Database Administration and Performance Tuning
• Nice to Have: Experience with High Availability SQL Server Configurations
• Nice to Have: Experience with Azure Data Factory and Power BI
• Ability to react to dynamic situations and work effectively in a fast-paced environment.

Education & Experience:

• 5 years of experience in field, Preferred
• Bachelors Degree in Computer Science, Preferred

Candidates must be legally authorized to work in the US to be considered. We are unable to provide visa sponsorship for this position.

#LI-hybrid

Due to the sensitive nature of the information that this role needs to access, AssetMark will be required to collect from applicants for this role, elements of Personally Identifiable Information in order to comply with governmental requirements.

Who We Are & What We Offer:

AssetMark's mission is centered around helping financial advisors make a difference in the lives of their clients. To help them do that, we aim to provide advisors with holistic support. We offer compelling technology that facilitates a better client experience, consulting services that ensure advisors' businesses are running at their best and a comprehensive suite of investment solutions. AssetMark's platform empowers advisors to provide the highest level of service possible to their clients.

AssetMark's culture is driven by our mission and connected by our values; Heart, Integrity, Excellence and Respect. You will join a team that lives these values every day by doing the best and what is right in all we do and encouraging different ideas for continual success and innovation. Additionally, we offer a wide range of benefits to meet the needs of our team members and their families.

• Flex Time Off or Paid Time/Sick Time Off
• 401K - 6% Employer Match
• Medical, Dental, Vision - HDHP or PPO
• HSA - Employer contribution (HDHP only)
• Volunteer Time Off
• Career Development / Recognition
• Fitness Reimbursement

As an Equal Opportunity Employer, AssetMark is committed to building a diverse and inclusive workplace where everyone feels valued.