Analytics Engineere

The Analytics Engineer (Mid-Level) sits at the intersection of data engineering, analytics, and business intelligence. This role is responsible for designing, building, and optimizing scalable analytical data models that power reporting, insights, and decision-making across the organization and reports directly to the Director of Data.In this environment, the Analytics Engineer will primarily leverage PostgreSQL-based data workflows hosted in Heroku and deliver business-facing insights through Sigma. The ideal candidate combines strong SQL expertise, sound data modeling practices, and a product mindset toward data quality, performance, and usability.Key ResponsibilitiesImplement scalable, production-grade analytical data models in PostgreSQL database.Build, maintain, and optimize SQL-based ELT transformations within the Heroku/Postgres environment.Translate business and reporting requirements into clean, reusable data transformations and views.Partner closely with business stakeholders to define metrics and reporting logic.Develop and enhance Sigma dashboards and data models to ensure clarity, usability, and trust in metrics.Optimize query performance, indexing strategies, and materialization approaches in Postgres.Maintain and improve existing transformation workflows for reliability and maintainability.Implement data quality checks, documentation, and testing practices.Establish and follow data modeling and naming standards across the analytics layer.Investigate and resolve data discrepancies and performance issues.Required Qualifications:Experience:2–5 years of experience in analytics engineering, data analytics, or a related data role.Demonstrated experience working directly with PostgreSQL in an analytics context.Experience supporting business intelligence and reporting workflows.Technical Skills:Advanced SQL proficiency, including:Complex joins and CTEsWindow functionsQuery performance tuningIndexing strategies in PostgresStrong experience building analytical models in PostgreSQL.Hands-on experience working in Heroku-hosted data environments or similar PaaS platforms.Proficiency building dashboards and data models in Sigma (or comparable BI tools).Solid understanding of dimensional modeling (facts, dimensions, grain, slowly changing dimensions).Experience with Git-based version control.Core Competencies:Strong analytical thinking and structured problem solving.Ability to translate ambiguous business questions into scalable data solutions.High attention to data accuracy, documentation, and maintainability.Strong cross-functional communication skills.Ownership mindset with the ability to manage multiple priorities.Preferred Qualifications:Experience with Postgres performance tuning at scale.Familiarity with Heroku data pipelines, scheduling, or automation patterns.Experience implementing data quality tests and monitoring.Exposure to semantic layer or metric standardization work.Working knowledge of Python or scripting for data tasks.Experience supporting product, or education analytics.Performance Metrics:Success in this role will be measured by:Quality, reliability, and scalability of Postgres analytical models.Performance improvements in SQL transformations and dashboard queries.Adoption and trust of Sigma dashboards by business stakeholders.Reduction in data discrepancies and metric conflicts.Completeness and clarity of model and dashboard documentation.Responsiveness to stakeholder reporting needs.Stability of Heroku-based data workflows.