Analytics Engineer

Title: Analytics Engineer Location: Overland Park, K ansas Job Description: JOB SUMMARY The Analytics Engineer at Creative Planning bridges data engineering and business intelligence , designing clean, well -modeled, trusted datasets that power the firm's reporting, analytics, AI tools, and internal applications. This role works closely with Data Engineers, who ingest and orchestrate data, and Business Intelligence Analysts who focus on data output to the business. The Analytics Engineer is heavily involved in build ing the curated middle layer . Deep experience with Azure Databricks, SQL, and data modeling, along with an understanding of how data is consumed, is key to success in this role. We do not accept resume submissions from third -party recruiters or staffing agencies. Please contact our recruiting team directly. JOB DUTIES • Design, build, and maintain curated, business -ready data models in Azure Databricks, transforming raw and staged data into reliable analytical datasets. • Develop and enforce data modeling standards, including dimensional models, naming conventions, and business logic definitions, so metrics are consistent across the firm. • Partner with Data Engineers on ingestion and pipeline requirements, and with Business Intelligence Analysts and stakeholders to understand how data is consumed. • Define the strategy and standards for semantic models, and build and optimize them alongside Business Intelligence Analysts. • Implement data quality checks, testing, and monitoring to ensure accuracy, consistency, and completeness. Investigate and resolve data discrepancies, working with Data Engineers on upstream causes. • Apply software engineering best practices, including version control, code review, CI/CD, and environment management, to analytics code and transformations. • Create and maintain documentation, including data dictionaries, lineage, and metric definitions, so data is understandable to both people and AI tools. • Optimize query and transformation performance, and manage processing efficiency and cost in Databricks. • Identify opportunities to automate manual data preparation and improve data workflows across the firm. • Support data governance and security practices, including appropriate handling of sensitive client and firm data. REQUI RED QUALIFICATIONS / EXPERIENCE • Bachelor's degree in Computer Science, Data Science, Information Systems, Finance, or a related field. • 4+ years of experience in analytics engineering, data engineering, business intelligence , or a similar role, preferably in wealth management, financial services, or a related industry. • Advanced SQL skills, including complex transformations, performance tuning, and data modeling. • Hands -on experience with Azure Databricks and large -scale data transformation. • Experience with dimensional modeling and building curated data layers for analytics. • Strong knowledge of Power BI, including semantic model design and DAX, and how modeling choices affect reporting. • Experience with Azure Data Factory, SQL Server, and other cloud -based data tools in the Azure ecosystem. • Experience with version control (such as Git) and collaborative development practices. • Strong communication skills, with the ability to work with both technical and non -technical partners and explain data concepts clearly. • Strong attention to detail and commitment to data quality. • Ability to work independently and collaboratively in a fast -paced environment. • Commitment to teamwork and excellence. • Motivated and results oriented. • Available to work outside of normal business hours when required. PREFERRED QU ALIFICATIONS / EXPERIENCE • Experience with Delta Lake and medallion architecture. • Experience with CI/CD tooling such as Azure DevOps or GitHub. • Experience with data testing and observability frameworks. • Familiarity with wealth management data domains such as portfolio, custodial, CRM, and financial planning data.