Analytics Engineer II: Data Products & AI-Driven Insights

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

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