Note: The job is a remote job and is open to candidates in USA. Cars Commerce builds technology solutions that simplify automotive commerce for dealerships, manufacturers, and consumers. The Senior Analytics Platform Engineer will own the infrastructure, deployment, performance, governance, and operations of semantic layer, data catalog, and self-service analytics platforms, while optimizing the data warehouse and partnering with BI, data warehouse, data science, and ML engineering teams.
Responsibilities
- Lead the technical architecture of our semantic and metrics layer, including infrastructure deployment, API design, pre-aggregation strategies, and enforcing robust authentication and row-level security protocols
- Manage the core governance infrastructure by administering Atlan—including crawl schedules and AI-driven enrichment—while maintaining the policy center for data access, PII classification, and compliance
- Oversee the self-service analytics platform operations, focusing on licensing, connection management, and version upgrades, ensuring high-quality platform administration rather than individual content creation
- Drive Amazon Redshift performance optimization in alignment with the platform, defining and tuning queries to support semantic layer pre-aggregation and business intelligence patterns
- Assume accountability for platform health, including uptime monitoring, observability alerting, and tracking compute and licensing expenditures across the data stack
- Provide technical leadership during tool migrations and contribute infrastructure and operability expertise to the evaluation and RFP processes for new semantic and BI technologies
Skills
- Remote and must be located in the Chicago area. May require onsite interviews
- * Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience
- * Five plus years of experience in data engineering or platform engineering, with meaningful ownership of production data infrastructure
- * Deep, hands-on experience tuning Amazon Redshift for performance — distribution/sort key design and compression encoding, WLM or concurrency-scaling/Serverless configuration, materialized views and result caching for query acceleration, and reading/optimizing execution plans. This is a hard requirement
- * Experience administering a data catalog or governance platform — Atlan, Collibra, Alation, DataHub, or similar
- * Experience administering an enterprise BI or self-service analytics platform — Tableau Server/Cloud, Looker, Sigma, Omni, Power BI, or similar — including licensing, security model, and workspace/connection management
- * Experience with a semantic layer, metrics layer, or query acceleration tool (Cube, Omni, dbt Semantic Layer, AtScale, LookML, or comparable), or a demonstrated ability to ramp quickly on a new one given the Redshift and platform-administration depth above
- * Solid understanding of API layer design, authentication/authorization patterns, and row-level security implementation
- * Experience with observability and monitoring tooling — Datadog, Metaplane, CloudWatch, or similar — including setting up alerting and being accountable for uptime
- * Expertise in SQL or similar query languages (PL/SQL, DDL, HiveQL, or SparkSQL) for complex data manipulation
- * Strong programming skills in Python, Scala, or Java, with a focus on automation and engineering efficiency
- * Experience managing source code via GitHub and architecting CI/CD pipelines for data using Jenkins, GitHub Actions, or CircleCI
- **For US-based Positions: Applicants must be authorized to work in the United States. Please note that we are unable to sponsor employment visas at this time.**
- * Prior experience owning three or more of these tool categories (catalog, semantic layer, BI platform, warehouse performance) simultaneously on a lean team
- * Experience supporting a BI platform migration (e.g., moving from one self-serve tool to another) from the infrastructure side
- * Experience optimizing cloud data warehouse costs at scale (Redshift, Snowflake, or BigQuery)
- * Direct production experience with Cube.dev, Omni, or a comparable semantic layer product specifically
Benefits
- Bonus and/or equity programs for some roles, depending on level and role
- Medical, Dental & Vision Healthcare Plans
- New Hire Stipend for Home Office Set-Up
- Generous PTO
- Paid Holidays, Floating Holiday, Volunteer Day, Recharge Day
- Remote work for candidates located in the Chicago area
Company Overview