Analytics Engineer II

Mariner Wealth Advisors; Overland Park, Northern (KS, KY); Hybrid; USD 95,000 - 140,000; Full time

Job summary

Mariner Wealth Advisors is seeking an Analytics Engineer II to build and deliver enterprise data products that support analytical and operational reporting. You will translate business requirements into scalable data models in Snowflake using SQL, dbt, and Python, while contributing to governance and AI-enabled analytics capabilities.

You will partner with Data Engineering, BI, and business stakeholders to design data products across the analytics lifecycle, develop semantic-layer models, and

Qualifications

• 3+ years of professional experience in analytics engineering, data engineering, or business intelligence.
• 3+ years of experience with SQL and analytical databases such as Snowflake, Databricks, SQL Server, or Azure.
• Experience developing and maintaining data models, pipelines, and reporting datasets.
• Experience working in Agile environments and collaborating with cross-functional teams.

Responsibilities

• Collaborate with business stakeholders to gather and clarify data and reporting requirements and translate them into effective data solutions.
• Develop and maintain scalable data models and data products using dbt and Snowflake in alignment with established architecture and engineering standards.
• Partner with Data Engineering, Business Intelligence, and business teams to design and implement data products across the analytics lifecycle.
• Contribute to semantic-layer models, business metrics, and standardized definitions that support AI-enabled agents, workflows, and consistent analytics.
• Apply Snowflake capabilities, including DDL, RBAC, SQL functions, and Cortex, in development and support of data products.
• Support data quality and governance by applying data validation, security, and quality practices.
• Participate in code reviews, version control, testing, and CI/CD processes.
• Provide clear project updates, technical documentation, and implementation status to stakeholders.

Skills

Analytical thinking

Problem solving

Data validation

Effective communication

Education

Bachelor’s degree in Computer Science/Engineering/Data Analytics or related field

Tools

Snowflake

dbt

Git

Semantic-layer tools

Job description

The Analytics Engineer II builds and delivers enterprise data products that support analytical and operational reporting across Mariner. This role translates defined business requirements into scalable data models and datasets in Snowflake using SQL, dbt, and Python while contributing to data quality, governance, and AI-enabled analytics capabilities. The Analytics Engineer II partners with Data Engineering, Business Intelligence, business analysts, and other stakeholders throughout the analytics lifecycle. This opportunity offers hands-on involvement in modern data platforms, semantic-layer development, and the implementation and ongoing support of data products across the organization.

Responsibilities

• Collaborate with business stakeholders to gather and clarify data and reporting requirements and translate them into effective data solutions.

• Develop and maintain scalable data models and data products using dbt and Snowflake in alignment with established architecture and engineering standards.

• Partner with Data Engineering, Business Intelligence, and business teams to design and implement data products across the analytics lifecycle.

• Contribute to semantic-layer models, business metrics, and standardized definitions that support AI-enabled agents, workflows, and consistent analytics.

• Apply Snowflake capabilities, including data definition language (DDL) operations, role-based access control (RBAC), SQL functions, and Snowflake Cortex, in the development and support of data products.

• Support data quality and governance by applying data validation, security, and quality practices throughout data development and implementation.

• Participate in code reviews, version control, testing, and continuous integration and continuous delivery (CI/CD) processes in accordance with team standards.

• Provide clear project updates, technical documentation, and implementation status to technical and business stakeholders.

Requirements

• 3+ years of professional experience in analytics engineering, data engineering, or business intelligence.

• 3+ years of experience with SQL and analytical databases such as Snowflake, Databricks, SQL Server, or Azure.

• Experience developing and maintaining data models, pipelines, and reporting datasets.

• Experience working in Agile environments and collaborating with cross-functional teams.

Preferred qualifications include a bachelor’s degree in computer science, engineering, data analytics, or a related technical field; experience in wealth management or financial services; experience with dbt for data modeling, testing, documentation, and deployment workflows; experience with Git and version control practices; understanding of extract, load, transform (ELT) and extract, transform, load (ETL) processes and tools; and exposure to semantic-layer concepts and tools.

Skills

• Apply strong analytical, problem-solving, and data validation skills to develop reliable data solutions.

• Communicate effectively with technical and business stakeholders, including providing clear documentation and project updates.

• Collaborate across Data Engineering, Business Intelligence, and business teams to deliver solutions that meet defined needs.

• Organize and coordinate work effectively across assigned projects while contributing within established engineering and delivery practices.

#LI-MK1

We welcome your interest in being a part of our firm. We believe in giving associates progressive opportunities, actively nurturing professional growth and giving back to the community. We are dedicated to building a diverse culture where everyone has the support they need to achieve their career goals. We offer an innovative workplace and a culture that fosters camaraderie, teamwork and work-life balance.

By submitting your application, you agree to the collection and use of your personal information as described in our Employee and Applicant Privacy Notice.

EOE M/F/D/V