Senior Software Engineer, Integrations

Opiniion Inc. is a resident satisfaction software company dedicated to enhancing living experiences for residents through innovative solutions. They are seeking a Senior Software Engineer to manage and improve the integrations layer connecting their platform to various property management systems, ensuring reliable data flow and system performance.

Responsibilities:

• 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
• 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
• 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
• 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

Requirements:

• 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)
• 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
• 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