Advisory Business Intelligence Engineer

The Advisory Business Intelligence Engineer is a senior technical and strategic leader responsible for designing and delivering enterprise-grade semantic models, driving business intelligence engineering excellence, and advising leadership on best-in-class data practices. This role blends hands-on engineering with architectural and advisory leadership, making it ideal for a professional who thrives at the intersection of deep technical expertise and strategic influence. The selected candidate will own the design and implementation of Lakehouse semantic models in Databricks, applying Kimball dimensional modeling principles to build scalable, performant, and governed business intelligence assets., * Lead the design and development of enterprise semantic layers using Databricks Lakehouse and Unity Catalog.

• Build scalable, performant semantic models aligned to Kimball dimensional modeling best practices.
• Provide hands-on development in SQL and Python, including complex transformations and model optimization.
• Conduct code reviews, enforce engineering standards, and provide final sign-off on business intelligence engineering deliverables.
• Mentor and guide junior engineers, fostering a culture of technical excellence.
• Act as a trusted advisor to leadership on architecture, modeling strategy, and data governance.
• Oversee day-to-day operations of builds and manage highly visible projects with assigned engineers.
• Partner closely with Data Engineering and Analytics teams to ensure semantic models meet business and technical requirements.
• Contribute to the evolution of best practices, CI/CD patterns, and development workflows.

Authorization: Candidate must be able to work directly on Apex’s w2 without requiring sponsorship now or in the future

Top Must-Haves:

• 8-10 years of BI Engineering/Architecture experience
• Lead or Hands-on Manager overseeing BI projects and ability to drive processes
• Databricks or Snowflake ingestion and data modeling (medallion architecture) exp.
• SQL, Python, and CI/CD expertise, Education: A Bachelor’s degree in Computer Science, Information Systems, or a related technical field is preferred.

Experience: Eight to twelve years of experience in Business Intelligence Engineering, Data Engineering, or Analytics Engineering. Demonstrated experience as a lead or hands-on manager overseeing projects and driving technical processes is required.

Technical Skills: Deep expertise in Databricks, including Lakehouse architecture, medallion architecture, Delta, and Unity Catalog. Strong command of SQL, Python, and CI/CD workflows is required. Proven experience building enterprise semantic layers and dimensional models using Kimball principles is necessary.

Preferred Qualifications

• Experience with dbt.
• Background in Logistics or Retail analytics.
• Familiarity with business intelligence governance, metadata management, and performance tuning in large-scale environments.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Everforth Apex uses a virtual recruiter as part of the application process. Click for more details. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Everforth Apex and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at, UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex Systems.