Job Url: https://www.remoterocketship.com/company/idera/jobs/lead-data-engineer-dba-united-states-remote Job Description: IDERA Software Website LinkedIn All Job Openings IDERA Software is a company that specializes in providing database management and monitoring tools. Its diverse range of products includes ER/Studio Data Modeling Tools, SQL Diagnostic Manager, SQL Compliance Manager, SQL Secure, and SQL Safe Backup, catering to users of SQL Server, Oracle, Sybase, DB2, and MySQL databases across on-prem, cloud, or hybrid environments. The company offers solutions for database performance monitoring, security, compliance, and automated backups, along with free tools for SQL Server management like SQL Data Profiler, SQL Check, and PowerShell tools. IDERA Software aims to streamline database management and enhance database performance, compliance, and security for enterprises. They host events such as Data Days, a virtual industry-focused event for data professionals, to showcase their leadership in the data industry. SQL Server β€’ MySQL β€’ Database Monitoring β€’ Database Design β€’ Database Development 51 - 200 employees Founded 2000 🏒 Enterprise ☁️ SaaS 🀝 B2B Lead Data Engineer / DBA 2 days ago πŸ‡ΊπŸ‡Έ United States – Remote ⏰ Full Time 🟠 Senior 🚰 Data Engineer Airflow AWS EC2 ETL Python SQL Tableau Apply Now Receive Emails with Similar Jobs Report problem πŸ“‹ Description β€’ Senior technical leader owning design, performance, and scalability of internal data warehouse and production databases. β€’ Lead data engineering function and mentor junior data engineers. β€’ 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 for data ingestion, transformation, and integration from internal and third-party systems. β€’ 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. β€’ Prior experience in a team lead or mentorship capacity over other data engineers (preferred). β€’ Experience with BI tools like Yellowfin, Tableau, Looker, PowerBI, or equivalent (preferred). β€’ Familiarity with version-controlled data workflows (e.g., dbt, Airflow) (preferred). β€’ Knowledge of data security, compliance, and governance best practices (preferred). β€’ Exposure to scripting languages like Python for ETL tasks and automation (preferred).