Data Engineer

AssetMark; Charlotte (NC); On-site; USD 135,000 - 157,000; Full time

Benefits offered by this job

Flex Time

401K Matching

Medical, Dental, Vision - HSA

Volunteer Time Off

Hybrid Work Schedule

Career Development

Job summary

AssetMark is seeking a Data Engineer (Analytics Engineering) to lead architecture, development, and optimization of data pipelines powering the platform. You will drive reliability and scalability across Azure and Snowflake, integrating GenAI into engineering workflows.

The role requires collaboration with stakeholders, mentoring junior engineers, and delivering governed data assets for analytic consumption from a hybrid Charlotte, NC area office.

Qualifications

• 3–7 years of professional Data/Analytics Engineering experience.
• Snowflake architecture, optimization, and advanced SQL experience.
• Proficiency in SQL/dbt; Python is a plus.
• Strong data modeling skills (Dimensional, Kimball/Inmon).
• Experience with cloud data environments (Azure preferred).
• Familiarity with data observability and governance practices.

Responsibilities

• Lead data architecture and engineering efforts for analytics platforms.
• Design, build, and optimize scalable ELT/ETL pipelines in Snowflake using dbt and SQL.
• Own Azure data infrastructure (Azure Data Factory, Synapse) and data flows to Snowflake.
• Model dimensional data warehouses to support analytics and reporting.
• Champion data quality, observability, and governance across pipelines.
• Mentor junior engineers and drive GenAI integration to accelerate development.

Skills

SQL

dbt

Snowflake

Python

Azure

Data modeling

Data governance

CI/CD

Tools

dbt

Snowflake

Azure Data Factory

Azure Synapse

Airflow

GitHub Actions

Azure DevOps

Job description

Job Description: 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 Data Engineer (Analytics Engineering) will be a key technical leader responsible for the architecture, development, and optimization of mission-critical data pipelines that power AssetMark's platform. This role requires an experienced individual who is comfortable representing the analytic engineering function independently with business stakeholders and can ensure data reliability and scalability across our Azure and Snowflake data stack, while proactively integrating Generative AI (GenAI) techniques into our engineering workflows and data products. The ideal candidate will transform raw data into governed, high-quality assets, mentor junior team members, and drive the adoption of modern data observability practices. We can only 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 Architecture & Engineering Leadership
• Data Platform Development: Design, build, and optimize highly scalable and fault-tolerant ELT/ETL pipelines using dbt and SQL to transform complex datasets in Snowflake and deliver enterprise scale data assets for analytic/user consumption.
• Cloud & Infrastructure: Own the data infrastructure on Azure, including leveraging services like Azure Data Factory and Azure Synapse, with expertise in setting up and managing data flows into Snowflake.
• Data Modeling: Lead the design and implementation of dimensional, Kimball/Inmon models within the data warehouse to support advanced analytics and reporting.
• Performance Optimization: Conduct performance tuning for complex SQL queries and data pipelines within Snowflake to ensure low latency and cost-efficient compute usage.
• Code Quality & CI/CD: Champion software engineering best practices, including robust unit/integration testing, automated data validation, and maintaining resilient CI/CD pipelines (e.g., using Azure DevOps or GitHub Actions).
• Data Quality, Observability, and Governance: Data Quality: Define and enforce data quality standards across the transformation layer, including designing dbt and other automated tests to validate data accuracy, completeness, and consistency at each data architecture layer. Data Reliability: Implement advanced data quality frameworks and observability solutions (e.g., Monte Carlo) to automatically monitor data freshness, volume, distribution, and schema health, proactively preventing data downtime. Data Lineage: Establish and maintain comprehensive data lineage (e.g. Atlan) documentation and tooling to provide transparency and ensure compliance across the data transformation layer. Security & Compliance: Ensure all data assets and pipelines adhere to strict financial industry compliance, governance, and security standards (RBAC, encryption, PII masking).
• Innovation & Mentorship: GenAI Integration: Proactively evaluate and pilot Generative AI techniques (e.g., leveraging LLMs via tools like GitHub Copilot or open-source frameworks) to accelerate internal development processes, generate boilerplate code, and enhance documentation. Mentorship: Act as a technical mentor for junior data engineers, guiding them on best practices in SQL, dbt, Snowflake, data modeling, and cloud architecture. Stakeholder Engagement: Serve as a trusted technical partner to users and data stewards - proactively learning domain context, eliciting and clarifying business rules, and applying critical thinking to evaluate tradeoffs and translate consumption needs into well-designed and scalable data assets.

Required Qualifications

• Experience: 3–7 years of professional experience in a Data Engineering, Analytics Engineering, or similar role, with demonstrable progression in scope and complexity.
• Data Warehouse: Expertise with Snowflake architecture, optimization, and advanced SQL features.
• Programming: Strong proficiency in SQL/dbt for data transformation; experience with Python a plus.
• Modeling: Solid experience with data modeling techniques, including Dimensional Modeling and developing complex ETL/ELT workflows.
• Business Acumen & Communication: Thrives at the intersection of data engineering and analytics - learning business domains, earning trust with business users and data stewards, and driving clarity from ambiguity to lead well-defined data solutions from requirement to delivery.
• Cloud Expertise: Proven hands‑on experience building and deploying data solutions in a Cloud environment (Azure preferred).
• Data Ops: Experience with modern data transformation tools like dbt and orchestration tools (e.g., Azure Data Factory, Airflow).

Preferred Skills (Differentiators)

• Experience working in the financial services or wealth management domain.
• Prior exposure to Data Observability platforms (e.g., Monte Carlo, Atlan).
• Familiarity with Generative AI (GenAI) concepts or hands‑on use of LLM coding assistants (e.g., Copilot) to improve engineering efficiency.
• Experience with real-time or streaming data technologies (e.g., Kafka, Azure Event Hubs).
• Exposure to Infrastructure as Code (IaC) tools like Terraform.

Compensation

The Base Salary range for this position is between $135,000-$157,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.

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.

Our Culture & Benefits

• 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.

AssetMark is a fast-growing financial technology company changing the game for advisors and their clients. If you are searching for a challenging, rewarding, and evolving career, you have come to the right place. We offer competitive salaries, full benefits, and excellent opportunities for growth.

To learn more about us, visit our website.