• Leading the design, development and implementation of robust scalable software solutions, ensuring alignment with business goals and technical requirements • Translating product requirements into system design and architecture using SSIS and Azure Data Factory • Analyzing and optimizing SQL performance, leveraging advanced techniques such as SQL Profiler and SQL Execution Plans to identify bottlenecks and improve query performance • Applying your knowledge of Medicaid and Medicare regulations to system logic and design • Diagnosing root cause issues and communicating findings clearly to internal stakeholders • Collaborating closely with cross-functional teams, including data architects, business analysts, and stakeholders, to ensure seamless database interactions • Providing mentorship to junior and mid-level engineers, developing their technical skills and best practices