Data Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

AssetMark · 1 day ago

Data Engineer

AssetMark is a company shaping the future of financial services, seeking a Data Engineer to lead the architecture and optimization of critical data pipelines. The role involves ensuring data reliability and scalability, mentoring junior engineers, and integrating Generative AI techniques into workflows.

AdviceConsultingFinancial Services
badNo H1Bnote

Responsibilities

Design, build, and optimize highly scalable and fault-tolerant ELT/ETL pipelines using Python, SQL, and dbt to integrate complex financial datasets from diverse sources into Snowflake (hosted on Azure)
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
Lead the design and implementation of dimensional, Kimball/ Inmon, and/or Data Vault models within the data warehouse to support advanced analytics and reporting
Conduct performance tuning for complex SQL queries and data pipelines within Snowflake to ensure low latency and cost-efficient compute usage
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)
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
Establish and maintain comprehensive data lineage documentation and tooling to provide transparency and ensure compliance across the data transformation layer
Ensure all data assets and pipelines adhere to strict financial industry compliance, governance, and security standards (RBAC, encryption, PII masking)
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
Act as a technical mentor for junior data engineers, guiding them on best practices in Python, Snowflake, data modeling, and cloud architecture
Partner with Data Scientists, Product Managers, and Business Analysts to translate high-level business requirements into precise, scalable technical solutions

Qualification

Microsoft AzureSnowflakePythonData ModelingDbtData ObservabilityGenerative AIStreaming DataInfrastructure as CodeMentorshipCollaboration

Required

Proven hands-on experience building and deploying data solutions on Microsoft Azure
Deep expertise with Snowflake architecture, optimization, and advanced SQL features
Strong proficiency in Python for data manipulation, scripting, and pipeline automation
Solid experience with data modeling techniques (Dimensional, 3NF, or Data Vault) and developing complex ETL/ELT workflows
Experience with modern data transformation tools like dbt (Data Build Tool) and orchestration tools (e.g., Azure Data Factory, Airflow)
Experience working in the financial services or wealth management domain
Prior exposure to Data Observability platforms (e.g., Monte Carlo, Collibra)
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)
Proficiency with Infrastructure as Code (IaC) tools like Terraform
3 - 7 years of professional experience in a Data Engineering, Software Engineering, or similar role

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

Company

AssetMark

twittertwittertwitter
company-logo
AssetMark is an investment adviser registered with the Securities and Exchange Commission.

Funding

Current Stage
Public Company
Total Funding
$2.81M
2024-04-25Acquired
2019-07-17IPO
2016-12-09Series Unknown· $2.81M

Leadership Team

leader-logo
Louis Maiuri
Chairman and Group CEO
linkedin
leader-logo
Erin Wood
SVP Advanced Planning
linkedin
Company data provided by crunchbase