Apply on Employer Site

AssetMark · 1 month ago

Associate Analytics Engineer

Charlotte, NC

Full-time

Hybrid

Entry Level

$81K/yr - $99K/yr

1+ years exp

AssetMark is a leading strategic provider of innovative investment and consulting solutions serving independent financial advisors. The Associate Analytics Engineer is responsible for transforming raw data into reliable datasets and applying software engineering best practices to analytics code, focusing on data modeling and collaboration with data teams.

AdviceConsultingFinancial Services

No H1B

Responsibilities

Develop and test data models, primarily using SQL and dbt, as assigned by more senior Analytics Engineers

Write and maintain data transformation logic to clean, organize, and structure data for analysis

Contribute to the design and extension of the Enterprise Dimensional Model for small, defined sections

Implement basic data quality checks and automated tests for new and existing data models

Support efforts to ensure data integrity and reliability

Draft and maintain documentation (e.g., data catalogs, ReadMEs) for new datasets and transformation processes to promote self-service and data understanding

Collaborate with Data Analysts to understand and address their data needs for reporting and analysis

Work with Data Engineers to understand data sources and ingestion processes

Follow and advocate for the team's internal standards for code style, maintainability, and best practices

Use version control (Git) and participate in code reviews for data model changes

Provide support and basic training to users of data sets and dashboards

Qualification

SQLDbtData warehousingPythonVersion control (Git)BI/data visualizationCommunicationProblem-solvingOrganizational skills

Required

Solid proficiency in SQL (Structured Query Language)

Familiarity with data transformation tools, preferably dbt (data build tool)

Understanding of data warehousing concepts (e.g., dimensional modeling/Kimball)

Familiarity with version control systems (e.g., Git)

Excellent communication skills with the ability to clearly articulate technical concepts and requirements to both technical and non-technical stakeholders

Problem-solving and critical thinking skills to investigate and resolve data issues

A positive and solution-oriented mindset, with comfort working in an agile environment

Self-motivated with strong task organizational skills and a desire to learn new technologies and methodologies

1+ years of experience in a data-focused role (e.g., Data Analyst, BI Analyst, or equivalent experience)