Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
AS
Apex Systems, Inc.
Lead Consultant (Data Analytics Engineer)
Career Insights for Data Analyst
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on Virginia data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A Data Analyst develops computer programs to analyze large customer information databases for companies and organizations. Analyzes data to identify patterns and provide information relevant to a particular business, industry or field; analysis may be used for marketing, or to detect fraud in financial transactions, or for research. Develops computer programs to protect confidential customer information.
$87,642 / year median in Virginia
+13% projected growth
Job Description
LEAD CONSULTANT - DATA ANALYTICS ENGINEERWHO WE ARE
Everforth Apex Systems is a leading global technology and digital engineering firm dedicated to helping organizations adapt, innovate, and thrive in a world of constant change. Leveraging deep industry insights and proven expertise, we deliver end-to-end solutions that accelerate time-to-value and realize our clients' digital visions across commercial and federal sectors. Our comprehensive solution portfolio spans AI & data, cloud and infrastructure, digital engineering, customer experience, cybersecurity, enterprise platforms, application development, strategy, transformation, and managed services. Powered by proprietary assets, accelerators, and strong alliances with cutting-edge technology partners—including Adobe, AWS, Microsoft, Salesforce, and more—we turn complexity into progress and measurable business outcomes. With a presence in over 70 markets across North America, Europe, and India, Everforth Apex Systems innovates alongside our customers, building and deploying tailored artificial intelligence solutions to enhance business value and improve customer experiences. As part of the commercial segment of Everforth, we are committed to driving the next wave of global IT services and digital transformation.JOB DESCRIPTION
Everforth Apex Systems is seeking a Lead Consultant, Databricks Data Analytics Engineer with deep, hands-on experience designing analytics-ready data models and semantic layers within Databricks Unity Catalog, and enabling AI-driven analytics using Databricks AI/BI Genie. In this role, you will partner closely with AI teams to enable natural language querying, with a focus on the modeling, transformation, and consumption layers of the Databricks platform.RESPONSIBLITIES
- 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.
JOB REQUIREMENTS
- 6+ years of experience in analytics engineering with a strong focus on building analytics-ready data models and consumption layers.
- 3+ years of hands-on experience with Databricks in a production environment.
- Proven experience designing and building data models, transformations, and consumption layers within Databricks.
- Hands-on 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
Preferred Qualifications:
- Experience with clickstream or digital product analytics data
- Background in retail, consumer goods, or digital commerce
- Databricks certification (Certified Data Analyst, Data Engineer, or Generative AI Engineer)
- Experience with Adobe Analytics, including digital event data, behavioral metrics, and downstream analytics use cases.
- Experience building dashboards or semantic layers for Tableau.
OUR COMPREHENSIVE BENEFITS
- 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 Everforth Apex is an equal opportunity employer.