Senior Analytics Engineer
Vantage Specialty Chemicals is seeking a Senior Analytics Engineer to enhance the data-driven decision-making process within the organization. This role involves designing and maintaining semantic models, translating business requirements into data structures, and collaborating with various business stakeholders. The ideal candidate will have a strong background in data modeling, SQL proficiency, and experience with tools like Power BI. The position emphasizes teamwork, data governance, and effective communication, supporting a diverse and inclusion-focused work culture.
Job description
Vantage provides natural solutions to our customers’ technical performance and marketing needs through a unique combination of chemistry, application expertise and service. Underpinned by our broad portfolio of formulations, ingredients and actives that are built on a backbone of sustainable oils, fats and their derivatives, Vantage targets selected markets and applications including personal care, food, surface treatment, agriculture, pharma, and consumer and industrial performance. Vantage is headquartered in Deerfield, IL., operates in 11 countries worldwide and employs more than 1,000 talented professionals focused on delivering exceptional customer experiences with every interaction. We are a dynamic people-centered organization where you’ll be part of a collaborative global team. Embracing our cultural diversity, we learn from each other to constantly improve, adapt and iterate. We value the voices and talents of our colleagues, empowering them to drive their unique ideas to completion. We’re convinced that exceptionally motivated employees produce outstanding results, and we celebrate them by fostering a culture of recognition, development, learning, excellence and shared achievement. Most importantly, we know you’re going to like it here. For more information visit: vantagegrp.com or LinkedIn/vantage. The Analytics Engineer serves as the critical bridge between the Data Engineering platform and the business-facing analytics layer. This role is responsible for transforming reliable, pipeline-ready data into well-structured, semantically consistent analytical models that power reporting, decision-making, and self-service analytics across the organization. The Analytics Engineer operates at the intersection of technical data modeling and business understanding — owning the logic, definitions, and structures that ensure data means the same thing to every stakeholder who consumes it and functioning as a translator who speaks both the languages of engineering and business. Essential Duties and Responsibilities
Data Modeling & Semantic Layer Ownership:
- Design, build, and maintain semantic models that translate Silver/Gold layer data into business-consumable structures.
- Define and enforce consistent business metrics, KPIs, and data definitions across reporting domains.
- Develop and manage dimensional models (fact/dimension tables, star schemas) aligned to business reporting needs.
- Own the semantic model layer in Microsoft Fabric / Power BI, ensuring performance, accuracy, and consistency.
Business Logic & Requirements Translation:
- Partner with business stakeholders to understand reporting requirements and translate them into well-structured data models.
- Validate that analytical datasets accurately reflect business rules, processes, and definitions.
- Collaborate with the BI Analyst to ensure semantic models support downstream report development without rework.
Documentation & Data Governance:
- Maintain data dictionaries, business glossaries, and metric definitions.
- Document semantic model design decisions, transformation logic, and business rule implementations.
- Support data governance initiatives by establishing and enforcing consistent naming conventions and model standards.
Team Collaboration & Stakeholder Engagement:
- Work closely with the Data Engineer to align on data availability, schema design, and Gold layer outputs.
- Engage proactively with Finance, Sales, Operations, and other business teams to understand evolving data needs.
- Serve as a subject matter expert on data meaning and model structure when business stakeholders have questions about report accuracy.
Education & Experience
- Education: Bachelor’s degree in Computer Science, Information Technology, Business, Information Systems, Data Analytics, or equivalent experience.
- Experience: 6 years of experience in analytics engineering, data modeling, or a hybrid BI/data role.
Knowledge, Skills, & Talents
Required Qualifications:
- ERP exposure required (such as SAP, Epicor, D365, NAV, or similar) — especially relevant given a complex multi-ERP environment.
- Strong SQL proficiency — able to write, optimize, and troubleshoot complex queries.
- Experience building semantic models — Power BI datasets, tabular models, or equivalent.
- Working knowledge of dimensional modeling concepts (star schema, slowly changing dimensions).
- Demonstrated ability to translate business requirements into data model structures.
- Strong documentation discipline — data dictionaries, transformation logic, business rule documentation.
- Ability to engage and communicate effectively with business stakeholders across functions.
- Minimum English level: C1 — role involves regular communication with US-based leadership and cross-functional stakeholders.
Preferred Qualifications:
- Experience with Microsoft Fabric and/or Databricks
- Familiarity with dbt or similar transformation frameworks
- Experience supporting a medallion architecture (Bronze → Silver → Gold)
- Understanding of data governance and MDM concepts
Working Conditions
Hybrid
Equal Employment Opportunity
Vantage is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status or any other protected category.
Job details
- Published
- October 13, 2026
- Experience
- Senior
- Job source
- smartrecruiters
- Workplace
- Hybrid · Bogota, CO
- First seen
- October 14, 2026
Skills mentioned in this job
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at VantageSpecialtyChemicals
Similar jobs from this company
- R-2263 Supply Analyst IVantageSpecialtyChemicalsCalle 26 # 92 - 32, COOn-site
- Credit and Collection SpecialistVantageSpecialtyChemicalsBogota, COOn-site
- Asistente AdministrativoVantageSpecialtyChemicalsBogota, COOn-site
- Engineering ManagerVantageSpecialtyChemicalsChicago, USOn-site
- IT Governance, Risk, Compliance, & Change LeadVantageSpecialtyChemicalsBogota, COOn-site
- Inside Sales RepresentativeVantageSpecialtyChemicalsBogota, COHybrid
Across the market
Similar jobs from other companies
- Senior Analytics EngineerFP MarketsLimassol, CYHybrid
- Senior Analytics EngineerOverseeWarsaw, PLRemote
- Senior Analytics EngineerZooplaLondon, GBHybrid
- Senior Analytics EngineerCloudFactoryKathmandu, NPRemote
- Senior Analytics EngineerMoxieUSRemote
- Senior Analytics EngineerGuzman y GomezSurry Hills, AUOn-site
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.