Data Engineer

Join the Data Engineer role at Asset Mark in Charlotte, NC. Asset Mark is a leading strategic provider of innovative investment and consulting solutions serving independent financial advisors.

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.

• 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 Dev Ops) 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.

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

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.

Charlotte, NC office with hybrid work schedule.

As an Equal Opportunity Employer, Asset Mark is committed to building a diverse and inclusive workplace.