Principal Software Engineer - ETL/SQL (12-15 yrs)

We are seeking an experienced and highly skilled Senior Principal Software Engineer to join our team. This is a senior-level position focused on building innovative solutions for the healthcare industry, leveraging a wide array of technologies and frameworks. If you have a deep understanding of ETL processes, strong SQL Server expertise, and a passion for working on high-impact, complex healthcare data systems, we would love to hear from you.

Key Responsibilities :

- Lead the design, development, and implementation of robust, scalable software solutions for the
healthcare domain, ensuring alignment with business goals and technical requirements.

- Architect and develop ETL solutions using SSIS (SQL Server Integration Services) and Azure Data
Factory to support data movement and transformation.

- Develop and maintain efficient, optimized SQL queries and scripts; collaborate with other team
members to ensure seamless database interactions.

- Analyze and optimize SQL performance, leveraging advanced techniques such as SQL Profiler and
SQL Execution Plans to identify bottlenecks and improve query performance.

- Develop and maintain healthcare reporting systems using SQL Server Reporting Services (SSRS)
to provide accurate and actionable insights.

- Collaborate closely with cross-functional teams including data architects, business analysts, and
stakeholders to ensure data flows and business logic are correctly implemented.

- Provide mentorship to junior and mid-level engineers, helping them to grow in their technical
skills and develop best practices.

- Stay up to date with the latest trends and technologies in the software development and
healthcare industries, ensuring the team is using the most effective tools and practices.

- Participate in code reviews, ensuring high code quality and adherence to software engineering
best practices.

Required Skills and Experience :

- Proven experience (12+ years) in software engineering, with a strong focus on the healthcare
domain and healthcare data systems.

- Enterprise-class software architectural experience with a solid understanding of considerations
of scale, support, and implementation. Experience with Microsoft tech stack hosted on Azure
desired

- Expertise in ETL processes, including hands-on experience with SSIS (SQL Server Integration
Services) and Azure Data Factory.

- Deep working knowledge of SQL Server, including database design, optimization, and advanced
SQL scripting.

- Strong understanding of SQL performance tuning, including experience with SQL Profiler and
analyzing SQL Execution Plans.

- Experience in developing reports using SQL Server Reporting Services (SSRS) to deliver accurate
business intelligence.

- Exposure to ASP.Net, C#.Net, and JQUERY with the ability to develop, enhance, and maintain
web-based applications and services.

- Strong analytical and problem-solving skills, with the ability to quickly troubleshoot and resolve
complex technical issues.

- Strong knowledge of software engineering best practices and methodologies, including agile
development, continuous integration and deployment, and software testing.

- Excellent communication and collaboration skills, with the ability to work cross-functionally with
product management, UX, and other teams.

Preferred Qualifications :

- Experience in cloud-based healthcare solutions (Azure, AWS, etc.) is a plus.

- Familiarity with HIPAA regulations and healthcare data security requirements.

- Experience with Scrum methodologies and related tools