Advisory Business Intelligence Engineer

The Role

The Advisory Business Intelligence Engineer is a senior technical and strategic leader responsible for designing and delivering enterprise-grade semantic models, driving BI engineering excellence, and advising leadership on data practices.

Responsibilities

• 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 BI engineering deliverables.
• Mentor and guide junior BI engineers, fostering a culture of technical excellence.
• Act as a trusted advisor to leadership on BI architecture, modeling strategy, and data governance.
• Oversee day-to-day operations of builds and manage highly visible projects with assigned engineers.
• Partner with Data Engineering and Analytics teams to ensure semantic models meet business and technical requirements.

Requirements

• 8-12 years of experience in Business Intelligence Engineering, Data Engineering, or Analytics Engineering.
• Experience as a lead or hands-on manager overseeing BI projects and driving processes.
• Deep expertise in Databricks, including Lakehouse architecture, medallion architecture, Delta, and Unity Catalog.
• Strong command of SQL, Python, and CI/CD workflows.
• Proven experience building enterprise semantic layers and dimensional models using Kimball principles.
• Demonstrated ability to mentor engineers, lead technical initiatives, and influence architectural decisions.
• Strong communication skills with the ability to advise leadership and translate technical concepts into business value.
• Experience with dbt.
• Background in Logistics or Retail analytics.
• Familiarity with BI governance, metadata management, and performance tuning in large-scale environments.

Qualifications

• Candidates must be able to work directly on w2 without requiring sponsorship now or in the future.

Skills

• SQL
• Python
• CI/CD workflows
• Kimball modeling principles
• dbt
• Logistics or Retail analytics

Benefits

• Medical
• Dental
• Vision
• Life
• Disability
• ESPP (employee stock purchase program)
• 401K program
• HSA (Health Savings Account on the HDHP plan)
• EAP (Employee Assistance Program) with up to 8 free counseling sessions
• Corporate discount savings program
• On-demand training program
• Certification prep and library of technical and leadership courses/books/seminars
• Certification discounts and other perks to associations like CompTIA and IIBA
• Customer service team for questions about benefits and other resources
• Certified Career Coach

Pay

$150-160K

Schedule

6 month contract to hire

Contact

To apply for this position, send your information and resume to [email protected] or call us at +353 21 2330 150. For more details about Everforth Apex's benefits, click here.

Everforth Apex is an equal opportunity employer. We do not discriminate or allow discrimination based on race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law.