Lead Data Engineer / DBA - Sembi

Preferred Time Zone Coverage: US/EU

About Sembi:
Sembi is a leader in software quality and security management, offering a comprehensive suite of tools that enhance testing, strengthen security, and accelerate product delivery. By unifying industry-leading solutions like TestRail, Xray, Testmo, Ranorex, Kiuwan, and PreEmptive, Sembi empowers development teams to build software the world can rely on.

DBA / Lead Data Engineer
The Lead Data Engineer / Database Administrator (DBA) is a senior technical leader responsible for owning the design, performance, and scalability of both the internal data warehouse and production databases. This role will lead the data engineering function, mentor junior data engineers, and ensure the reliability, performance, and quality of data pipelines across the company. This is a hands-on position that requires deep expertise in SQL, AWS infrastructure, ETL design, and BI tooling.

Key Responsibilities

• Lead and mentor a small team of data engineers, promoting technical excellence and best practices.
• Own and manage AWS-based data infrastructure related to the data warehouse and ETL systems, including provisioning, system performance, and cost optimization.
• Design, implement, and maintain end-to-end ETL pipelines to support data ingestion, transformation, and integration from internal systems and third-party tools.
• Optimize queries and indexes for production application databases to ensure fast, reliable access.
• Triage and resolve data integrity issues across the warehouse and source systems.
• Partner with BI analysts and stakeholders to enable high-quality reporting and analytics.
• Support data tooling and BI platforms such as Yellowfin, Tableau, PowerBI and others.
• Ensure secure and performant connectivity between CDATA drivers and data warehouse.

Requirements

• 5+ years of experience in data engineering, data infrastructure, or database administration roles.
• Expert-level SQL skills, with strong experience in relational database performance tuning and optimization.
• Hands-on experience managing AWS infrastructure, including RDS, S3, EC2, and IAM.
• Proven ability to design and maintain scalable, maintainable ETL pipelines and data workflows.
• Experience owning both production and warehouse environments in a high-volume data environment.
• Strong communication and collaboration skills with cross-functional teams.
• Preferred Qualifications
• Prior experience in a team lead or mentorship capacity over other data engineers.
• Experience with BI tools like Yellowfin, Tableau, Looker, or equivalent.
• Familiarity with version-controlled data workflows (e.g., dbt, Airflow).
• Knowledge of data security, compliance, and governance best practices.
• Exposure to scripting languages like Python for ETL tasks and automation.

An Equal Opportunity Employer - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Idera, Inc and it's subsidiaries are committed to respecting and protecting the privacy of its customers, job applicants, partners and website visitors. For more information about our Privacy Statement, please go to https://www.idera.com/legal/privacystatement . By clicking on the “Apply Now” button, you understand and agree that the use of Idera’s web site is subject to Idera Terms of Use and Idera’s Privacy Statement, including the fact that Idera and it's subsidiaries may transfer your personal information collected in connection with your registration on this website to its affiliates globally and to third party entities that provide services to Idera and it's subsidiaries.