Full Time | Ambulatory Healthcare Services2 Months Ago
Save
Sorry! This job is no longer available. Please explore similar jobs listed on the left.
ACV is Hiring a Sr. Data Engineering MAX Digital Near Buffalo, NY
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:Maintain and extend (as required) existing database operations solution for backups, index defragmentation, data retention, etc.Troubleshoot any SQL Server or ETL stack outages during our operational support window.Triage any issues with data stack (SSIS, C#, Web APIs).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.Architect and build entire services including but not limited to; data modeling, storage, message brokers, protocols and interfaces.Design, build and maintain complex systems that can scale rapidly with little maintenance.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.Be empowered to lead and complete software projects with minimal guidance from managers.Lead team discussions to define technical requirements on new and current products.Respond-to and troubleshoot highly complex problems quickly, efficiently, and effectively.Mentor junior engineers What you will need:Expert understanding of SQL query execution fundamentals and query optimization principles.Experience maintaining and extending an existing codebase, adapting to pre-existing patterns and tracing the code’s path of execution.ETL workflow implementation (SSIS, Airflow, C#, Python)Experience working with Cloud Services (AWS RDS, S3, SQS, SNS)Experience working with NoSQL data stores (MongoDB)Experience writing unit and integration testing (DBT, C#)Expert SQL and data-layer development experience; OLTP schema design.Experience integrating 3rd-party APIs, implementing authentication & authorization and developing asynchronous data flows.Nice to HaveOLAP schema design experience.Experience with Airflow, Snowflake, etc.Experience with DBT Compensation: $124,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-RG1