{"schemaVersion":"jobsearcher.job.v1","id":"ab7d814820f4c152fbf1bf0e","url":"https://jobsearcher.com/jobs/ab7d814820f4c152fbf1bf0e","canonicalUrl":"https://jobsearcher.com/jobs/ab7d814820f4c152fbf1bf0e","title":"Analytics Engineer / BI Data Modeler","description":"We’re looking for an experienced Analytics Engineer (or BI Data Modeler) to build a business-trusted analytics layer on top of our production data. Our core system runs on PostgreSQL (application stack: NestJS + TypeORM) and integrates with QuickBooks and Salesforce. The operational schema is optimized for transactions (OLTP); your mission is to turn it into clear analytical models, consistent metrics, and reliable historical logic that power reporting and decision-making.\nWhat you’ll do\nTranslate operational data into business concepts (e.g., Orders, Invoices, Bills, Payments, Customers, Warehouses, Revenue, Margin etc).\nDesign analytics-friendly models (facts/dimensions, star schemas where appropriate) with clear grain, keys, and definitions.\nBuild aggregated and denormalized tables/views optimized for BI consumption (Metabase, Power BI, Looker, etc.).\nImplement a semantic / metrics layer using Cube.dev (definitions, reusable measures, dimensions, and business logic).\nStandardize core metrics (revenue, margin, aging, win rate, quote time, fulfillment KPIs) with documentation and alignment across teams.\nModel status/history and event-based logic accurately (paid/voided/overdue/cancelled/re-quoted, lifecycle timestamps, effective-dated changes).\nReconcile and unify data across systems (application, QuickBooks, Salesforce) into canonical business models.\nPartner with engineering and business stakeholders to ensure models reflect real workflows and become the company’s source of truth.\nWhat we’re looking for\nStrong SQL and PostgreSQL skills (performance-aware modeling, window functions, incremental patterns, etc.).\nProven experience building analytics data models (fact/dimension design, star schema, metric layers / semantic layers).\nTrack record converting OLTP schemas into analytics-ready structures.\nSolid understanding of financial/operational data (invoicing, payments, AR/AP, terms, due dates, aging).\nComfort working with complex business rules and turning them into consistent, testable definitions.\nNice to have\nExperience with dbt (or similar transformation frameworks).\nHands-on experience with Cube.dev (semantic layers, metrics definitions, governance).\nExperience with Metabase / Looker / Power BI.\nExperience with snapshot/event-driven modeling (SCD, audit trails, lifecycle modeling).\nDomain background in logistics, marketplaces, or operational SaaS.\nWhat this role is not\nNot a “dashboard-only” BI role.\nNot purely data infrastructure / platform engineering.\nThe focus is on business-correct, durable data models and metrics that the whole company can rely on.\nJob Type: Full-time\nPay: $65,000.00 - $72,000.00 per year\nBenefits:\n401(k)\nDental insurance\nHealth insurance\nPaid time off\nVision insurance\nWork Location: In person","company":"Olimp","rawCompany":"olimp","city":"Buffalo Grove","state":"IL","isRemote":false,"isActive":false,"createdAt":"2026-04-14T10:56:28.671Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-2051.01","title":"Business Intelligence Analysts","slug":"business-intelligence-analysts"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Analytics Engineer / BI Data Modeler","description":"We’re looking for an experienced Analytics Engineer (or BI Data Modeler) to build a business-trusted analytics layer on top of our production data. Our core system runs on PostgreSQL (application stack: NestJS + TypeORM) and integrates with QuickBooks and Salesforce. The operational schema is optimized for transactions (OLTP); your mission is to turn it into clear analytical models, consistent metrics, and reliable historical logic that power reporting and decision-making.\nWhat you’ll do\nTranslate operational data into business concepts (e.g., Orders, Invoices, Bills, Payments, Customers, Warehouses, Revenue, Margin etc).\nDesign analytics-friendly models (facts/dimensions, star schemas where appropriate) with clear grain, keys, and definitions.\nBuild aggregated and denormalized tables/views optimized for BI consumption (Metabase, Power BI, Looker, etc.).\nImplement a semantic / metrics layer using Cube.dev (definitions, reusable measures, dimensions, and business logic).\nStandardize core metrics (revenue, margin, aging, win rate, quote time, fulfillment KPIs) with documentation and alignment across teams.\nModel status/history and event-based logic accurately (paid/voided/overdue/cancelled/re-quoted, lifecycle timestamps, effective-dated changes).\nReconcile and unify data across systems (application, QuickBooks, Salesforce) into canonical business models.\nPartner with engineering and business stakeholders to ensure models reflect real workflows and become the company’s source of truth.\nWhat we’re looking for\nStrong SQL and PostgreSQL skills (performance-aware modeling, window functions, incremental patterns, etc.).\nProven experience building analytics data models (fact/dimension design, star schema, metric layers / semantic layers).\nTrack record converting OLTP schemas into analytics-ready structures.\nSolid understanding of financial/operational data (invoicing, payments, AR/AP, terms, due dates, aging).\nComfort working with complex business rules and turning them into consistent, testable definitions.\nNice to have\nExperience with dbt (or similar transformation frameworks).\nHands-on experience with Cube.dev (semantic layers, metrics definitions, governance).\nExperience with Metabase / Looker / Power BI.\nExperience with snapshot/event-driven modeling (SCD, audit trails, lifecycle modeling).\nDomain background in logistics, marketplaces, or operational SaaS.\nWhat this role is not\nNot a “dashboard-only” BI role.\nNot purely data infrastructure / platform engineering.\nThe focus is on business-correct, durable data models and metrics that the whole company can rely on.\nJob Type: Full-time\nPay: $65,000.00 - $72,000.00 per year\nBenefits:\n401(k)\nDental insurance\nHealth insurance\nPaid time off\nVision insurance\nWork Location: In person","datePosted":"2026-04-14T10:56:28.671Z","dateModified":"2026-04-14T10:56:28.671Z","hiringOrganization":{"@type":"Organization","name":"Olimp","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Buffalo Grove","addressRegion":"IL","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"ab7d814820f4c152fbf1bf0e"},"url":"https://jobsearcher.com/jobs/ab7d814820f4c152fbf1bf0e"}}