Data Infrastructure Engineer

TRACTIAN is transforming the industrial world by empowering frontline maintenance workers to achieve more. As a Data Infrastructure Engineer, you will design and implement secure, scalable database solutions that enhance customer data control and optimize performance, collaborating with various teams to ensure integration and compliance.

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