Opiniion Inc.

POSITION OVERVIEW: Opiniion is seeking a backend software engineer with strong SQL and Node.js skills. We are migrating from MongoDB to PostgreSQL across a complex Node.js application. We need someone who can own this — not just run scripts, but design the schema, execute a safe migration, and guide us to write better application code on the other side. We also need someone who has experience writing fast, secure, and clean APIs and application code in Node.js. The absolute floor for experience is 5 years. RESPONSIBILITIES: - Write and maintain Node.js API services - Architect the relational schema from our existing document-based data model - Design and execute a zero-downtime migration strategy (dual-write, expand-contract, etc.) - Own DB performance — indexing, query analysis, connection pooling - Work with Node.js to read, process, and optimize MongoDB and SQL - Work inside Docker locally and on AWS QUALIFICATIONS: - Have shipped a production NoSQL → relational migration, and can walk us through it - Have a strong background in backend software engineering, and understand relevant computer science fundamentals - Know PostgreSQL deeply (JSONB, CTEs, window functions, transactions, EXPLAIN ANALYZE) - Are competent and autonomous at writing Node.js code - Have used schema migration tooling - Are comfortable in AWS (RDS, ECS, IAM, VPC basics) - Think about data integrity first, speed second - Are willing to use AI in your daily development work You’re NOT the right person if: - Haven’t worked in Node.js before - Can’t write raw SQL — we’re not hiding behind abstractions here - Can’t explain database migrations and other core concepts - Need hand-holding on Docker, AWS, or advanced SQL - Are opposed to using AI in your daily development work TECHNICAL SKILLS: - Proficiency in Node.js — building APIs and service-layer code - Deep PostgreSQL knowledge - Experience with MongoDB and NoSQL-to-relational migration patterns - Docker for local development environments - AWS fundamentals: RDS, ECS, IAM, VPC OUR TECHNOLOGY STACK: - Vue.js, Node.js, AWS, Docker, and MongoDB (Soon changing to PostgreSQL) - GitHub, CircleCI OPINIION’S CULTURE: At Opiniion, we take our work seriously, but we don’t take ourselves too seriously! Our culture has been affectionately coined "Funfessional"—a perfect blend of professionalism and fun. We are committed to maintaining the highest standards of integrity, ethics, and excellence in all we do while fostering an environment where people enjoy coming to work. We believe in collaboration, innovation, and building a team that truly cares—about our clients, their residents, and each other. BENEFITS SNAPSHOT: - Comprehensive healthcare plans, encompassing medical, dental, and vision insurance, along with group life coverage. Opiniion covers 40-90% of the premium cost for employees and all dependents. - 401(k) retirement plan with a 100% corporate match on the first 1% and 50% match on the next 5%. - Pre-tax Health Spending Accounts (HSA). - Paid Parental Leave for all new parents (including adoption or foster care). - Unlimited Time Off policies. - 10 Paid Holidays annually. - Monthly Gym Reimbursement benefit. *Note that the above benefits are available only to full-time employees of Opiniion* Opiniion is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status, military service and veteran status, physical or mental disability, genetic information, or any other characteristic protected by applicable federal, state or local laws and ordinances.

Role Description We’re hiring our first dedicated analytics engineer to join an established data engineering team. You won’t be building alone — you’ll work alongside data engineers who own the pipelines and infrastructure (Fivetran, Databricks), and your job is to build the analytics layer on top: reliable data models within our medallion architecture (bronze, silver, gold), clean dashboards, and governed metrics that teams across the company can trust and self-serve. This is a hands-on individual contributor role, but collaboration is central to the work. You’ll spend your time writing SQL, building and maintaining gold-layer models in Databricks, and creating dashboards in Omni Analytics — but you’ll also be a regular presence in conversations with Product, CS, Sales, and Marketing, translating their questions into reliable analytics and surfacing insights they wouldn’t find on their own. Strong cross-team communication skills matter as much as technical depth here. What You’ll Do: - Data Modeling & Transformation - Build and maintain dimensional and semantic models in Databricks that serve as the analytics layer for the company, working within a medallion architecture (bronze, silver, gold). - Own the gold layer — write clean, tested, version-controlled SQL transformations that turn curated silver-layer data into business-ready tables optimized for reporting and analysis. - Partner with data engineers on data quality, lineage, and freshness across the medallion layers to ensure models are reliable and well-documented. - Dashboards & Business Intelligence - Design and build dashboards and topics in Omni Analytics for Product, Client Success, Sales, Marketing, and executive stakeholders. - Implement governance practices for dashboards: naming conventions, documentation, version control, and testing. - Create client-facing analytics views that can be shared externally to demonstrate platform value. - Metrics & Governance - Collaborate with Product and leadership to document KPI definitions and implement them consistently across all reporting surfaces. - Contribute to a metric catalog so that stakeholders reference the same numbers from the same source. - Flag data quality issues proactively and work with the data engineering team to resolve them. - Investigations & Analysis - Conduct deep-dive investigations into conversion drops, data mismatches, and funnel issues using SQL and platform tooling. - Document findings and build repeatable analysis runbooks so investigations don’t start from scratch each time. - Partner with product engineering to identify gaps in event instrumentation and recommend improvements. - Stakeholder Enablement - Help internal teams learn Omni Analytics so they can answer routine questions without filing a request. - Write lightweight documentation for dashboards, data models, and common queries. Qualifications - 5+ years in analytics engineering, BI development, or product analytics roles. - Advanced SQL — you write complex, performant queries daily and are comfortable with window functions, CTEs, and large-scale data. - Hands-on experience with a modern BI tool (Omni, Looker, or similar) — building explores, semantic layers, and governed dashboards. - Experience with Databricks, BigQuery, or a comparable cloud analytics platform for data modeling and transformation. - Familiarity with medallion layer architecture (bronze/silver/gold) is strongly preferred. - Familiarity with ELT/ETL orchestration tools (Fivetran, dbt, or similar). Requirements - Product-minded: you don’t just build tables — you understand what questions the business is trying to answer and work backward from there. - Builder mentality: you prefer creating tested, documented, reusable assets over one-off queries. - Clear communicator: you can explain data findings to non-technical stakeholders in writing and in conversation. You’re comfortable presenting to CS, Sales, Marketing, and Product teams and translating between technical and business language. - Cross-team collaborator: you proactively build relationships across departments, seek out context before building, and make sure your work is shaped by the people who will use it — not just the people who requested it. - Comfortable with ambiguity: this is a first-of-its-kind role at Opiniion, and you’ll help shape how analytics work gets done. Nice-to-Haves - dbt or similar modeling/testing frameworks. - Python for light ETL, scripting, or anomaly detection. - Comfortable working with data from MongoDB or other NoSQL sources. - GA4 or product analytics instrumentation experience. - Proptech, real estate technology, or multifamily industry experience. - Experimentation platforms or statistical analysis background. What Success Looks Like - In your first 90 days, you’ll have shipped your first governed dashboards in Omni and earned trust with at least one stakeholder team. - Within 6 months, here’s what we’d expect: - Core business KPIs are modeled in Databricks and surfaced through Omni dashboards that stakeholders actively use. - The majority of routine analytics questions from Product, CS, Sales, and Marketing are answered through self-service dashboards rather than ad-hoc requests. - Data models are documented, tested, and version-controlled — not tribal knowledge. - You’ve conducted at least one meaningful investigation that identified a root cause of a platform or funnel issue and informed a product fix. - Executive dashboards are in production and shared with leadership and clients. Benefits - Comprehensive healthcare plans, encompassing medical, dental, and vision insurance, along with group life coverage. Opiniion covers 40-90% of the premium cost for employees and all dependents. - 401(k) retirement plan with a 100% corporate match on the first 1% and 50% match on the next 5%. - Pre-tax Health Spending Accounts (HSA). - Paid Parental Leave for all new parents (including adoption or foster care). - Unlimited Time Off policies. - 10 Paid Holidays annually. - Monthly Gym Reimbursement benefit.

Role Description We’re looking for a Senior Software Engineer to own and evolve the integrations layer that connects Opiniion to the property management systems our clients depend on. This is the connective tissue of the platform: ETL pipelines, PMS API integrations, data ingestion, and the transformation logic that ensures resident, property, and operational data flows reliably into our systems. You’ll join an established data engineering team under a dedicated engineering manager. The team already operates pipelines in production, but this role exists because we need a senior engineer who can raise the bar — improving reliability, expanding PMS coverage, building more resilient error handling, and designing integrations that scale as our client base grows. This is a hands-on IC role with real ownership over a critical part of application infrastructure. What You’ll Do: - PMS Integrations & API Development - Build, maintain, and extend integrations with property management systems including Yardi, RealPage, Entrata, and others — handling API communication, authentication, data mapping, and error recovery. - Design integration patterns that are reusable across PMS platforms, reducing the effort to onboard new partners and data sources. - Own the reliability of production integrations: monitoring, alerting, retry logic, and incident response when data pipelines fail or degrade. - ETL Pipelines & Data Engineering - Build and maintain ETL pipelines that ingest, transform, and load data from external PMS platforms and internal sources into our data infrastructure. - Write performant SQL transformations within the ETL pipeline, and ensure data flows cleanly into our data warehouse. - Partner with the analytics engineering team to ensure upstream data quality so that downstream dashboards and reporting are trustworthy. - Code Quality & Engineering Practices - Write clean, tested, well-documented code. Ship with minimal bugs and maintain high standards in code reviews. - Contribute to architecture decisions for the integrations layer — proposing solutions, evaluating tradeoffs, and documenting approach strategies. - Champion engineering best practices: version control discipline, CI/CD hygiene, automated testing, and clear documentation. - Collaboration & Communication - Work closely with product, customer success, and other engineering teams to understand integration requirements and prioritize work. - Communicate reliably with your team: set clear timelines, flag blockers early, and help teammates overcome obstacles. - Partner with QA to ensure integration changes are thoroughly tested before reaching production. Qualifications - 5+ years of professional software engineering experience, with meaningful time spent on integrations, ETL, or data engineering work. - Strong Python proficiency — you write production-grade Python daily and are comfortable building services, scripts, and pipeline logic. - SQL proficiency — you write complex queries confidently and understand data modeling concepts (joins, CTEs, window functions, indexing). - Experience building and consuming RESTful APIs, including authentication flows (OAuth, API keys, token refresh), pagination, rate limiting, and error handling. - Familiarity with ETL/ELT patterns and tools (Fivetran, Airflow, custom pipeline orchestration, or similar). Requirements - Ownership mindset: you treat production integrations as your responsibility, not just your code. When something breaks at 2am, you care about the fix and the prevention. - Strong communicator: you set clear expectations, surface problems early, and write things down so the team doesn’t depend on tribal knowledge. - Collaborative: you help teammates overcome blockers, give thoughtful code reviews, and work efficiently in a group when the problem calls for it. - Process-oriented: you follow the team’s stated processes and actively look for ways to improve them. You voice concerns constructively. - Autonomous: you can pick up a well-scoped task and drive it to completion without needing constant direction, while knowing when to ask for help. Nice-to-Haves - JavaScript proficiency — comfortable reading, writing, and maintaining JavaScript in production codebases. - Ruby on Rails experience. - AWS experience (our infrastructure is hosted on AWS) — Lambda, S3, RDS, SQS, or similar services. AWS CDK experience is a plus. - Databricks or Spark SQL experience. - Experience integrating with property management systems (Yardi, RealPage, Entrata) or proptech platforms. - Familiarity with MongoDB or other NoSQL data sources. What Success Looks Like In your first 90 days, you’ll have shipped improvements to at least one production PMS integration and built context across the integration codebase. Within 6 months: - You own multiple PMS integrations end-to-end and the team trusts you to ship changes to them independently. - Pipeline reliability has measurably improved — fewer data gaps, faster recovery from failures, better alerting. - You’ve contributed architectural improvements that make onboarding new PMS integrations faster or more standardized. - Teammates seek your code reviews and your input on integration design decisions. Benefits - Comprehensive healthcare plans, encompassing medical, dental, and vision insurance, along with group life coverage. Opiniion covers 40-90% of the premium cost for employees and all dependents. - 401(k) retirement plan with a 100% corporate match on the first 1% and 50% match on the next 5%. - Pre-tax Health Spending Accounts (HSA). - Paid Parental Leave for all new parents (including adoption or foster care). - Unlimited Time Off policies. - 10 Paid Holidays annually. - Monthly Gym Reimbursement benefit.