Lead Analytics Engineer
Role Overview
This role is a senior individual contributor in analytics engineering at Chamberlain Group and sets the technical standard for how curated, trusted data is modeled and published for enterprise-wide consumption. Where our Data Engineers are accountable for reliably landing and conforming data on the Databricks platform, the Lead Analytics Engineer is accountable for what happens next: designing the curated Gold-layer data models and domain data marts in Unity Catalog, defining enterprise business metrics once as governed Unity Catalog metric views, building the dashboards that put those metrics in front of decision-makers, and making that layer well-tested, well-documented, performant, and genuinely self-serviceable.
This is a hands-on technical leadership role without direct reports.
This role will establish modeling and metric standards, reviewing the work of other Analytics Engineers and external partner resources, and mentoring engineers and analysts across the organization.
Success looks like a single agreed definition for every enterprise metric, business partners who trust the numbers and stop building shadow reports, and an analytics layer that serves BI tools, SQL users, and AI agents consistently.
Key Skills for This Role
Full Job Posting
Experience:
- 4+ years of experience in analytics engineering, data engineering, data warehousing, or business intelligence development, with a majority spent building production data consumed by business users, including 2+ years hands-on with Databricks
- Demonstrated technical leadership, including responsibility for standards, design review, and code review of other engineers' work
- Demonstrated experience owning enterprise or cross-functional metric definitions and driving alignment among stakeholders with competing definitions, including managing changes to established definitions and the restatement of previously reported numbers
- Experience designing and building dashboards used by business and executive audiences, and improving or retiring an existing reporting estate
- Demonstrated hands-on use of AI development tools such as Claude, GitHub Copilot, or Databricks Genie Code to improve the speed and quality of development or analytics work, with the ability to articulate specifically where those tools helped and where they did not
- Knowledge, Skills, and Abilities:
- Expert SQL, including window functions, complex joins, common table expressions, and incremental and idempotent transformation patterns
- Strong Python development skills, including PySpark, applied to building production transformations, automation, testing, and reusable tooling — this role requires genuine proficiency in both SQL and Python, not SQL alone
- Demonstrated data modeling expertise, including dimensional and star schema design, domain data mart design, grain and conformance decisions, and slowly changing dimensions
- Significant hands-on experience with Databricks, including Delta Lake, Unity Catalog, Databricks SQL, and medallion architecture, and with publishing curated data from the lakehouse for analytical consumption
- Dashboard and data visualization skill, including chart selection, layout, and performance, with judgment about when a dashboard is the right answer and when it is not. Dashboard craft developed on another enterprise BI platform is transferable; the Databricks requirements above are not
- Practical experience implementing data quality testing, documentation, and lineage as part of routine delivery rather than as an afterthought
- Git-based version control and CI/CD practices applied to analytics code, including environment promotion
- Ability to translate ambiguous business questions into durable data models and dashboards, including stakeholder interviewing, requirements documentation, and metric arbitration
- Working understanding of data classification and access control concepts for sensitive and personally identifiable data, and the ability to implement them on published data
- Ability to teach — to raise the data capability of analysts and engineers through documentation, enablement material, pairing, and working sessions
- Sound judgment about where AI tooling meaningfully accelerates analytics work and where it introduces risk, with the discipline to review, test, and validate AI-generated code and metric logic rather than accepting it uncritically
- Ability to influence and raise standards without formal authority, and to give and receive direct technical feedback constructively
- Ability to deal with ambiguity and make quality decisions in a dynamic, fast-paced environment
- Strong presentation, written and verbal communication skills with an ability to communicate effectively to all levels of the organization, including translating technical concepts for business audiences
- Insistence on high standards with a strong desire to transform and improve and a bias for action
- Education/Certifications
- Bachelor's Degree in Computer Science or equivalent relevant work experience
- Ability to travel up to 5%
- Hands-on experience with Unity Catalog metric views specifically
- Experience with Lakeflow Declarative Pipelines (formerly Delta Live Tables) and Lakeflow Jobs
- Experience with Declarative Automation Bundles (formerly Databricks Asset Bundles) or comparable deployment-as-code tooling
- Experience building reusable AI skills, prompt libraries, or agent configurations adopted by other engineers
- Experience designing governed, certified datasets and semantic definitions consumed by Databricks AI/BI dashboards and other enterprise BI tools connected to the lakehouse
- Experience building or curating AI/BI Genie spaces, or comparable experience enabling natural language or AI agent access to data through curated metadata, example queries, and verified assets
- Experience applying agentic AI development tools, such as Claude Code or comparable tools, to analytics engineering work including legacy report logic migration, test generation, and large-scale SQL refactoring
- Experience creating enablement material, patterns, or standards that helped other engineers or analysts use AI tools effectively
- Experience with data observability or data quality tooling
- Experience with agile/scrum development methodologies
- The pay range for this position is $102,600.00 - $193,425.00; base pay offered may vary depending on a number of factors including, but not limited to, the position offered, location, education, training, and/or experience. In addition to base pay, also offered is a comprehensive benefits package and 401k contribution (all benefits are subject to eligibility requirements). This position is eligible for participation in a short-term incentive plan subject to the terms of the applicable plans and policies.
- Chamberlain Group wants all of its employees to succeed and encourages people of all backgrounds to apply. We’re proud to be an Equal Opportunity Employer, and you’ll be considered for this role regardless of race, color, religion, sex, national origin, age, sexual orientation, ancestry; marital, disabled or veteran status. We’re committed to fostering an environment where people of all lived experiences feel welcome.
- Persons with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence [email protected].
- NOTE: Staffing agencies, headhunters, recruiters, and/or placement agencies, please do not contact our hiring managers directly.
Minimum Qualifications
- Other:
Preferred Qualifications
- Education/Certifications:
- Databricks Certified Data Engineer Associate or Professional, or Databricks Certified Data Analyst Associate
- Azure platform certification
Experience:
- #LI-Hybrid
- #LI-JM2
About Chamberlain Group
Private global manufacturer of intelligent access hardware and cloud-connected solutions for homes, businesses, and communities.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Chamberlain Group
Sr. Manager, Human Resources Business Partner
Germantown, USA
Finance Manager - Operations and Supply Chain (Systems)
Germantown, USA
Chamberlain Group is seeking a Finance Manager to partner with manufacturing and supply chain leaders on budgeting, forecasting, product costing, and operational reporting. The role requires at least five years of releva
Finance Manager – Distribution & Transportation
Oak Brook, USA
Sr. Manager, Human Resources Business Partner
Germantown, USA
Finance Manager - Operations and Supply Chain (Systems)
Germantown, USA
Supplier Quality Engineer III
Germantown, USA
Finance Manager – Distribution & Transportation
Oak Brook, USA
Lead, Data and Deployment Operations
Oak Brook, USA
Staff Engineer, Software - GenAI
Oak Brook, USA
Staff Software Engineer - ML/AI
Oak Brook, USA
Sr. Manager, Amazon Marketing
Oak Brook, USA