Associate Data Engineer

AssetMark is a leading strategic provider of innovative investment and consulting solutions serving independent financial advisors. We provide investment, relationship, and practice management solutions that advisors use in helping clients achieve wealth, independence, and purpose.

The Job/What You'll Do:

The Associate Data Engineer is an integral member of the Data Team, responsible for helping to transform raw data into reliable, easy-to-use datasets for analysts, data scientists, and business users. You'll apply software engineering best practices to analytics code and focus on building foundational data models. This role provides an excellent opportunity to grow technical expertise in data modeling and the modern data stack.

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

Key Responsibilities:

Data Modeling & Transformation

• Develop and test data models, primarily using SQL and dbt, as assigned by more senior Analytics Engineers.
• Write and maintain data transformation logic to clean, organize, and structure data for analysis.
• Contribute to the design and extension of the Enterprise Dimensional Model for small, defined sections.

Data Quality & Governance

• Implement basic data quality checks and automated tests for new and existing data models.
• Support efforts to ensure data integrity and reliability.

Documentation & Collaboration

• Draft and maintain documentation (e.g., data catalogs, ReadMEs) for new datasets and transformation processes to promote self-service and data understanding.
• Collaborate with Data Analysts to understand and address their data needs for reporting and analysis.
• Work with Data Engineers to understand data sources and ingestion processes.

Technical Operations

• Follow and advocate for the team's internal standards for code style, maintainability, and best practices.
• Use version control (Git) and participate in code reviews for data model changes.
• Provide support and basic training to users of data sets and dashboards.

Knowledge, Skills & Abilities:

• Solid proficiency in SQL (Structured Query Language).

• Familiarity with data transformation tools, preferably dbt (data build tool).

• Understanding of data warehousing concepts (e.g., dimensional modeling/Kimball).

• Experience with a major cloud data warehouse platform (e.g., Snowflake, Google BigQuery, Redshift) is a plus.

• Basic knowledge of a scripting language like Python for data-related tasks is beneficial.

• Familiarity with version control systems (e.g., Git).

• Experience with a BI/data visualization tool (e.g., Tableau, Looker, Power BI).

• Excellent communication skills with the ability to clearly articulate technical concepts and requirements to both technical and non-technical stakeholders.

• Problem-solving and critical thinking skills to investigate and resolve data issues.

• A positive and solution-oriented mindset, with comfort working in an agile environment.

• Self-motivated with strong task organizational skills and a desire to learn new technologies and methodologies.

Education & Experience:

• 1+ years of experience in a data-focused role (e.g., Data Analyst, BI Analyst, or equivalent experience).

Compensation: The Base Salary range for this position is between $95,000-$105,000.

This information reflects a base salary range that AssetMark reasonably expects to pay for the position based on a number of factors which may include job-related knowledge, skills, education, experience, and actual work location. This position will also be eligible for additional variable incentive compensation and competitive benefits.

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

#LI-TN1

Who We Are & What We Offer:

We are AssetMark, a company on the move, shaping the future of financial services. Growth is in our DNA. Every day, we combine technology, insight, and collaboration to create new possibilities for advisors, for our people and for our investors. At AssetMark your ideas matter; they’re heard, valued, and drive meaningful change. Join a team that sets new standards and creates space for you to thrive and do your best work. 

Our Mission 

Our mission is simple: to help our 10,500+ financial advisors make a meaningful difference in their clients’ lives. We do this by combining powerful technology, holistic support, and expert consulting to help advisors run stronger, more efficient businesses. Backed by a comprehensive suite of investment solutions and a trust company that boasts of $150B+ AUM, our platform empowers advisors to deliver exceptional service and an outstanding client experience.

Our Values 

Heart. Client Success. Integrity. Respect. Excellence. Our values are how we show up every day.  

We believe in: 

• Leading with Heart, in truly making a difference in the lives of others: teammates, clients, investors and communities. 

• Obsessing over Client Success, bringing a relentless focus on what matters to clients that sets us apart and creates loyal, lasting relationships. 

• Unyielding Integrity, doing what’s right, always. Even when it’s hard. 

• Collective Respect, in being authentic, inclusive and valuing all voices while winning together. 

• Operating with Excellence, in learning fast, continuously improving, innovating and collaborating to find new and better solutions.  

These values shape our culture, guide our decisions, and define what it means to be part of the AssetMark family. 

Our Culture & Benefits 

Our culture brings our mission and values to life. Here, we do what’s right, embrace diverse ideas, and innovate together. We also offer a wide range of benefits to support you and your family—because thriving at work starts with thriving in life. 

• Flex Time or Paid Time Off and 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 

• Hybrid Work Schedule 

  
  

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