Who we are looking for:We are seeking a highly skilled Engineer IV in Data Engineering with a strong foundation in computer science and excellent problem-solving skills. You will be responsible for maintaining and extending our database operations, optimizing SQL queries, and designing scalable data services. What you will do:Actively and consistently support all efforts to simplify and enhance the customer experience.Maintain and extend (as required) existing database operations solution for backups, index defragmentation, data retention, etc.Troubleshoot any SQL Server or ETL stack (SSIS, C#, Web APIs) outages during our operational support window.Leverage monitoring tools to ensure high performance and availability; work with operations and engineering to improve as required.Leverage DMVs and monitoring tools to ensure system performance; work with data operations and engineering to improve as required.Ensure existing HADR (availability groups) solution is functional and meets requirements.Support development, integration, and stage SQL Server environments for application development and data science teams.Ensure that new database development meets company standards for readability, reliability, and performance. Work with internal teams on transactional and analytical schema design.Collaborate with software and DevOps engineers to design scalable services, plan feature roll-out, and ensure high reliability and performance of our products.Conduct code reviews, develop high-quality documentation, and build robust test suites.Own the overall performance of products and services within a defined area of focus.Respond-to and troubleshoot highly complex problems quickly, efficiently, and effectively. This may include being part of the emergency after-hours on-call rotation.Mentor junior data engineers.Perform additional duties as assigned. What you will need:Bachelor's degree in Computer Science, Information Technology, Computer Information Systems, Management Information Systems, or similar5 years' building & supporting the database-tier of SaaS web applications.Ability to read, write, speak, and understand English. Expert in SQL Query optimizationETL workflow implementation (SSIS, Airflow, C#, Python)Experience working with Cloud Services (AWS RDS, S3, SQS, SNS)Experience working with NoSQL data stores (e.g., MongoDB)Experience developing Windows services in C#Experience writing unit and integration testingExpert SQL and data-layer development experience; OLTP schema design.Experience using and integrating with cloud services, specifically: AWS RDS, S3, SQS, SNS.Nice to HaveExperience with AirflowExperience with DBTCompensation: $127,000.00 - $152,000.00 annually. Please note that final compensation will be determined based upon the applicant's relevant experience, skillset, location, business needs, market demands, and other factors as permitted by law. No immigration or work visa sponsorship will be provided for this position.#LI-AM3