Senior Lead Consultant; Databricks Analytics Engineer

Position: Senior Lead Consultant (Databricks Analytics Engineer)
##

Job Description # Senior Lead Consultant (Databricks Analytics Engineer)
Apex Systems is a leading global technology services firm that incorporates industry insights and experience to deliver solutions that fulfill our clients’ digital visions. We provide a continuum of services, including strategy and enablement, innovation and productivity, and technology foundations to drive better results and bring more value to our clients.

Apex transforms our customers with modern enterprise solutions tailored to the industries we serve. Apex has a presence in over 70 markets across North America, Europe, and India. Apex is a part of the Commercial Segment of ASGN Incorporated (NYSE: ASGN). To learn more, visit .
* Own the design, development, and optimization of analytics-ready data models within Databricks, primarily in the Silver and Gold layers, with the ability to troubleshoot upstream in raw data when needed
* Design and implement enterprise-grade semantic models in Databricks Unity Catalog, enabling governed, reusable business metrics and definitions
* Build and manage semantic tables, metric views, and YAML-driven definitions optimized for BI and AI-driven analytics
* Partner with Data Product, BI, Platform, and AI teams to accelerate adoption of trusted, self-service analytics
* Collaborate closely with the AI team (including deployed AI consultants) to enable Databricks AI/BI Genie, supporting natural language querying and agent-style BI workflows
* Design datasets specifically for AI-driven and natural language use cases, ensuring models are enriched, well-described, and optimized for LLM-based querying
* Leverage Databricks Genie and agents to support data discovery, lineage, and model optimization
* Ensure best practices for data governance, performance, scalability, and usability across analytics and AI consumption layers
* Contribute to standards, patterns, and documentation for analytics engineering and semantic modeling
* Demonstrate strong technical knowledge and implementation skills. Stay current on relevant technology trends and practices. Build trust and respect among internal and external stakeholders and demonstrate collaborative teamwork.
* Produce high quality deliverables, meet project deadlines, and take responsibility for engagement success. Demonstrate a passion for quality and process improvement.
* Demonstrate professional level consulting skills and communication/presentation skills.
* Continually innovate, seek creative solutions, and find new ways of adding value. Listen and seek to understand the client and meet their needs, providing consultative guidance. Stay attuned to the future needs of the client and work with internal resources to identify opportunities. Proactively provide solutions and approach adversity with a solution-focused mindset.
* Identify and evaluate new team members through professional networking and technical screening.
* 8+ years of experience in analytics engineering with a strong focus on building analytics-ready data models and consumption layers.
* 5+ years of hands-on experience with Databricks in a production environment.
* Proven experience designing and building data models, transformations, and consumption layers within Databricks.
* Practical experience with Databricks AI/BI Genie, including natural language querying and AI-assisted analytics workflows (production experience strongly preferred).
* Deep experience with semantic modeling in Databricks Unity Catalog
* Strong SQL skills and experience with analytics-focused data modeling
* Strong Python experience for data transformation and analytics workflows
* Experience building datasets specifically for natural language and AI-driven analytics use cases, with an understanding of how model design impacts AI/LLM-based querying
* Experience working with governed, enterprise-scale analytics environments
* Experience with clickstream or digital product analytics data preferred
* Background in retail, consumer goods, or digital commerce preferred
* Databricks certification (Certified Data Analyst, Data Engineer, or Generative AI Engineer) preferred
* Experience with Adobe Analytics, including digital event data, behavioral metrics, and downstream analytics use cases preferred
* Experience building dashboards or semantic layers for Tableau preferred
* Competitive Salary
* Health, Dental and Vision Insurance
* Health Savings Accounts (HSA) with Employer Contribution
* Flexible Spending Accounts
* Long and Short-Term Disability
* Life Insurance
* Voluntary Benefits
* Employee Assistance Program
* Paid Parental Leave
* Wellness Incentives
* Vacation and Holiday Pay
* 401(k) Retirement Plan with Employer Match
* Employee Stock Purchase
* Training and Advancement Opportunities
* Tuition Reimbursement
* Birthdays Off
* Philanthropic Opportunities
* Referral Program
* Partial Gym Membership Paid
* Team Building Events
* Discount Programs
* Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race,…