Data Infrastructure Engineer

Responsibilities

• Architect Single-Tenancy Solutions: Design and implement scalable single-tenancy architectures, transitioning from multi-tenant systems to secure, isolated customer environments with virtual partitioning.
• Empower Customer Data Control: Build infrastructure that enables customers to securely access, analyze, and manage their data independently, ensuring privacy and ownership compliance.
• Optimize Database Performance: Configure, maintain, and optimize SQL-based database systems for high performance and scalability. Resolve complex technical issues to ensure reliability. 
• Develop ETL and synchronization systems to seamlessly translate internal data structures into client-facing representations.
• Collaborate Across Teams: Partner with engineering, IT, and product teams to align database solutions with business goals and ensure seamless integration into broader workflows.
• Document and Enhance Processes: Create clear documentation for architecture, workflows, and best practices while identifying opportunities for automation and process improvement.
• Ensure Security and Compliance: Implement robust security measures and maintain compliance with industry standards and customer agreements in all database operations.

Requirements

• Expert in SQL query design (normalization), optimization, indexing, and performance tuning with extensive experience managing relational databases like PostgreSQL in large-scale environments.
• Expertise with non-SQL databases (MongoDB).Experience with CDC (Debezium) and data synchronization.
• Experience with ETL tools such as Spark, Airflow, Pandas and Polars.
• Knowledge of analytics and integrations tools like Airbyte, Grafana and Power BI.
• 5+ years of SQL-focused database engineering experience and a bachelor’s degree in Computer Science or equivalent work experience.
• Proven ability to design and manage multi-tenant and single-tenant database models, implement secure virtual partitioning, and optimize schemas for scalability and reliability.
• Strong troubleshooting skills to resolve complex database issues and develop innovative, efficient solutions for data infrastructure challenges.
• Coding skills (such as Python and Golang).
• Experience building database systems that enable secure customer access, data control, and compliance with privacy regulations.
• Effective team player who collaborates with engineering and IT teams and translates technical database concepts into actionable strategies for stakeholders.
• Knowledge of Python or Bash for automation, cloud database platforms like AWS RDS, and containerized environments, such as Docker or Kubernetes.