Data Engineer
AssetMark, Inc.1 month ago
Charlotte, NC, USAMid Level / Senior
Base Salary
$135k - $157k/yr
Responsibilities
- Design, build, and optimize scalable and fault-tolerant ELT/ETL pipelines using dbt and SQL in Snowflake.
- Own Azure data infrastructure and manage data flows using Azure Data Factory and Azure Synapse.
- Lead dimensional and Kimball/Inmon data modeling for enterprise analytics and reporting.
- Tune Snowflake queries and pipelines for performance, latency, and cost efficiency.
- Maintain unit and integration tests, automated data validation, and CI/CD pipelines.
- Define data quality standards and implement automated testing across transformation layers.
- Implement observability for data freshness, volume, distribution, and schema health using solutions such as Monte Carlo.
- Establish data lineage documentation and tooling using platforms such as Atlan.
- Ensure data assets meet financial-industry security, governance, compliance, RBAC, encryption, and PII-masking standards.
- Evaluate and pilot GenAI techniques and tools to improve development and documentation workflows.
- Mentor junior data engineers and partner with business users and data stewards to translate requirements into scalable data assets.
Requirements
- 3–7 years of professional experience in Data Engineering, Analytics Engineering, or a similar role.
- Expertise with Snowflake architecture, optimization, and advanced SQL features.
- Strong proficiency with SQL and dbt; Python experience is a plus.
- Experience with dimensional data modeling and complex ETL/ELT workflows.
- Hands-on experience building and deploying cloud data solutions, preferably in Azure.
- Experience with data transformation tools such as dbt and orchestration tools such as Azure Data Factory or Airflow.
- Ability to understand business domains, clarify requirements, communicate with stakeholders, and lead data solutions from requirements through delivery.
- Preferred experience in financial services or wealth management.
- Preferred exposure to data observability platforms such as Monte Carlo and Atlan.
- Preferred familiarity with GenAI concepts or LLM coding assistants such as GitHub Copilot.
- Preferred experience with real-time or streaming technologies such as Kafka or Azure Event Hubs.
- Preferred exposure to Infrastructure as Code tools such as Terraform.
- Candidates must be legally authorized to work in the United States.
Benefits
- Hybrid work schedule near the Charlotte, North Carolina office.
- Flex time or paid time off and sick time off.
- 401(k) with a 6% employer match.
- Medical, dental, and vision coverage with HDHP or PPO options.
- Employer HSA contribution for HDHP participants.
- Volunteer time off.
- Career development and recognition programs.
- Fitness reimbursement.
Tech Stack
Categories
Data Engineering
About AssetMark, Inc.
AssetMark builds a wealth management platform for independent financial advisors, offering investment solutions, portfolio management, planning software, and outsourced operations through affiliates like AssetMark Trust Company, Voyant, and Adhesion Wealth. The company earns fees on assets and services delivered via its technology and advisory platform. Founded in 1996 and headquartered in Concord, California, AssetMark is a registered investment adviser and is owned by private equity firm GTCR.