Advisory Business Intelligence Engineer

Job#: 3056434

Location:

Atlanta, Georgia (Remote)

Duration: 6 month contract to hire

Rate: $70-75/hr.

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

• 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

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.

A Bachelor’s degree in Computer Science, Information Systems, or a related technical field is preferred.

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.

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.

• 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 Clearly Rateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Everforth Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis…