AssetMark
Join the Data Engineer role at AssetMark in Charlotte, NC. AssetMark is a leading strategic provider of innovative investment and consulting solutions serving independent financial advisors.
Job Summary The Data Engineer will bridge data engineering and data analysis, transforming raw data into reliable data products for business intelligence and reporting. Own the entire modeling layer of the data warehouse, driving consistency, speed, and accuracy for analytics consumers.
Responsibilities
Design, develop, and maintain analytical data models (Star Schemas, Dimensional Models) in Snowflake to support business reporting, BI tools (Power BI), and strategic decision-making.
Own the entire dbt lifecycle: write, test, and deploy complex transformation logic in modular SQL, ensuring efficiency, reusability, and adherence to coding standards.
Collaborate with data engineers to transition raw Bronze/Silver layers into certified, aggregated Gold layer datasets.
Optimize SQL queries and dbt models for performance; manage Snowflake compute usage and costs.
Implement rigorous data quality testing using dbt tests and other validation frameworks.
Generate and maintain comprehensive documentation, data dictionaries, and data lineage tracking.
Integrate dbt workflows into CI/CD pipelines (Azure DevOps) for automated testing and deployment.
Partner with business stakeholders to define and govern consistent metric definitions and KPIs.
Serve as technical expert for data analysts and business users; provide guidance on querying techniques and data model structure.
Qualifications
3+ years as an Analytics Engineer, BI Engineer, or Data Analyst focused on data modeling and transformation.
Expert proficiency in Advanced SQL, Snowflake, and dbt in production environments.
Strong experience with dimensional modeling (Kimball) concepts.
Foundational scripting ability in Python for automation.
Experience with Power BI or Tableau from a data preparation/modeling standpoint.
Familiarity with data governance practices and semantic layers.
Experience in the Financial Services or Wealth Management domain.
Knowledge of software engineering practices (Git flow, code reviews).
Compensation & Benefits Base Salary: $126,000 - $140,000. Eligible for variable incentive compensation and competitive benefits.
Benefits include Flex Time, paid time off, 401(k) with 6% match, medical, dental, vision, HSA, volunteer time off, career development, fitness reimbursement, and hybrid work schedule.
Location & Work Schedule Charlotte, NC office with hybrid work schedule.
As an Equal Opportunity Employer, AssetMark is committed to building a diverse and inclusive workplace.
#J-18808-Ljbffr
Job Summary The Data Engineer will bridge data engineering and data analysis, transforming raw data into reliable data products for business intelligence and reporting. Own the entire modeling layer of the data warehouse, driving consistency, speed, and accuracy for analytics consumers.
Responsibilities
Design, develop, and maintain analytical data models (Star Schemas, Dimensional Models) in Snowflake to support business reporting, BI tools (Power BI), and strategic decision-making.
Own the entire dbt lifecycle: write, test, and deploy complex transformation logic in modular SQL, ensuring efficiency, reusability, and adherence to coding standards.
Collaborate with data engineers to transition raw Bronze/Silver layers into certified, aggregated Gold layer datasets.
Optimize SQL queries and dbt models for performance; manage Snowflake compute usage and costs.
Implement rigorous data quality testing using dbt tests and other validation frameworks.
Generate and maintain comprehensive documentation, data dictionaries, and data lineage tracking.
Integrate dbt workflows into CI/CD pipelines (Azure DevOps) for automated testing and deployment.
Partner with business stakeholders to define and govern consistent metric definitions and KPIs.
Serve as technical expert for data analysts and business users; provide guidance on querying techniques and data model structure.
Qualifications
3+ years as an Analytics Engineer, BI Engineer, or Data Analyst focused on data modeling and transformation.
Expert proficiency in Advanced SQL, Snowflake, and dbt in production environments.
Strong experience with dimensional modeling (Kimball) concepts.
Foundational scripting ability in Python for automation.
Experience with Power BI or Tableau from a data preparation/modeling standpoint.
Familiarity with data governance practices and semantic layers.
Experience in the Financial Services or Wealth Management domain.
Knowledge of software engineering practices (Git flow, code reviews).
Compensation & Benefits Base Salary: $126,000 - $140,000. Eligible for variable incentive compensation and competitive benefits.
Benefits include Flex Time, paid time off, 401(k) with 6% match, medical, dental, vision, HSA, volunteer time off, career development, fitness reimbursement, and hybrid work schedule.
Location & Work Schedule Charlotte, NC office with hybrid work schedule.
As an Equal Opportunity Employer, AssetMark is committed to building a diverse and inclusive workplace.
#J-18808-Ljbffr