Principal Data Engineer

Azure Data Lake Principal Architect

Hybrid Position 1-2x a week onsite at client
Direct Hire/Perm
Hours: 8:30am-5pm

Candidate needs to have experience doing solution architecture on Azure. The customer has a mature data platform currently and this person will be responsible for all new designs moving forward.

Team Overview
The our client's Data Lake Team plays a pivotal role in harnessing the power of data to drive innovation, enhance patient care, and advance research initiatives within the our clienthealthcare system. As a leading integrated health system, our clientrelies on a robust data infrastructure to make informed decisions and optimize healthcare delivery.
The mission of the Data Lake Team is to establish and maintain a centralized and scalable data platform - Data Lake, that consolidates diverse datasets from various sources across the healthcare system. This initiative aims to break down data silos, foster collaboration, and empower stakeholders with timely and accurate information.
The Data Lake Team collaborates closely with various stakeholders, including clinicians, researchers, administrators, and IT professionals. Cross-functional partnerships ensure that the Data Lake aligns with the evolving needs of the our client community.
Embracing a culture of innovation, the team is committed to exploring emerging technologies and methodologies to enhance the capabilities of the Data Lake, Lake house and Enterprise Data Warehouse. Continuous improvement initiatives are undertaken to refine processes, optimize performance, and stay at the forefront of healthcare data management.
The our client's Data Lake Team is at the forefront of revolutionizing healthcare through effective data management. By fostering collaboration, ensuring data integrity, and facilitating advanced analytics, the team contributes significantly to Mass General Brigham's mission of providing high-quality patient care and advancing medical knowledge.

Position Overview

We are seeking a highly skilled and experienced Principal Data Engineer to join our dynamic team. As a key member of our data engineering team, you will play a crucial role in designing, developing, and maintaining our data infrastructure and platform integration solutions. The Principal Data Engineer will be responsible for advancing our data engineering capabilities, ensuring data quality, and contributing to the success of data-driven initiatives.
Principal Duties and Responsibilities: Indicate key areas of responsibility, major job duties, special projects and key objectives for this position. These items should be evaluated throughout the year and included in the written annual evaluation.

Infrastructure, Architecture and Design:

• Design end-to-end data solutions on the Azure data platform, considering Scalability, Security, Compliance and Performance.
• Contribute to technical foundation of the Data Lake platform, expanding and optimizing the data ecosystem and pipeline architecture.
• Provide expertise in selecting and implementing appropriate data platform services (e.g. Azure, Databricks, Snowflake) for various data processing and storage needs.
• Collaborate with cross-functional teams to integrate data solutions with existing MGB data platform systems and applications, integrate new data management technologies aligned with the latest vendor products & capabilities (Microsoft Azure and Fabric, Databricks, Snowflake, Collibra, etc.) and software engineering tools into existing structures.
• Design, develop, construct, test, and maintain Data Lake architectures and large-scale data processing systems.
• Support big data, data lake, lakehouse ecosystem related tool selection and POC analysis.

Data Pipeline Development:

• Gather and process raw data at scale including large complex data sets, meeting functional/non-functional business requirements (using ADF, Databricks, Python, Pyspark, scripts, REST API calls, SQL Queries, etc.).
• Develop data set processes for data modeling, mining, and production.
• Create and maintain optimal data pipeline architecture on cloud-based platforms (e.g., Azure) and relational data systems (SQL Server, SSIS, Snowflakes).

Cross-Functional Collaboration:

• Work on cross-functional teams delivering enterprise solutions for internal and external clients.
• Collaborate with Software Developers, Database Architects, Data Analysts, and Data Scientists on data initiatives.
• Support stakeholders, including the Management team, Product owners, and Architecture teams, in addressing data-related technical issues and fulfilling data infrastructure needs.
• Partner with integrated platform & data science teams to define integrated solutions to meet the evolving needs of data analysts, developers & consumers (e.g. data ingestion framework, AI/Client capabilities, scalable compute), contributing to the innovation and leadership of the organization.

Data Optimization and Automation:

• Identify, design, and implement internal process improvements, automation of manual processes, optimization of data delivery, etc.
• Build the data infrastructure required for optimal extraction, transformation, and loading of data from traditional/legacy sources.

Subject Matter Expertise and Leadership:

• Act as a subject matter expert for internal or external data products.
• Contribute to solution architecture design and advise on engineering solution best practices.
• Mentor and guide junior data engineers by leading code reviews and documenting best practices.
• Use our clientvalues to govern decisions, actions, and behaviors.
• Perform other duties and responsibilities as assigned.

Qualifications:
(Must be realistic, neither overstated nor understated, and related to the essential functions of the job.)

• Bachelor's or Master's degree in Computer Science, Information Technology, or related fields; or comparable work experience
• 8+ years of related professional experience including 5+ years in data lake development in large reporting environment(s)
• Expert in Azure cloud computing, specializing in Azure data engineering stacks like ADF (Azure Data Factory), ADLS, Event Hubs, Snowflake, Databricks, streaming, Azure PowerShell, and Log Analytics.
• Hands-on development experience with Design and Architecture of big data frameworks/tools: Azure Data Lake, Snowflake, Azure Data Bricks.
• Expert experience with Hadoop based technology (e.g. Spark) and programming (Python, SQL, PySpark)
• Knowledgeable about cloud computing costs and performance and capable of providing ongoing suggestions for cost & performance optimization.
• Solid understanding of Snowflake computing, including its integration with Azure Data Lake, utilizing ADLS as a source for data processing.
• Experience with Design and Architecture of relational SQL and NoSQL databases, including MS SQL Server, Snowflake.
• Experience with Azure DevOps, familiar with CI/CD (Continuous Integration/Continuous Deployment) processes and capable of scaling them across engineering teams, leveraging Azure native resources for data ingestion.
• Experience leading and working with cross-functional teams in a dynamic environment, demonstrated track record of team leadership, technical acumen, innovation, tactical and strategic.
• Proven verbal, communication, and presentation skills, ability to clearly and concisely communicate complex technical concepts to both technical and non-technical audiences.
• Proven ability to work independently.

Skills/Abilities/Competencies: (Must be realistic, neither overstated nor understated, and related to the essential functions of the job.)

• Advanced hands-on SQL, Spark, Python, PySpark knowledge and experience working with relational databases for data querying and retrieval on multiple platform.
• Proficiency in Data Modeling tools (e.g. Erwin, Visio).
• Strong interpersonal and communication skills, both written and verbal.
• Strong Scrum/Agile development experience.
• Excellent organizational skills and attention to detail, manage multiple tasks and projects, meet deadlines, follow through, and manage to schedule.
• Strong innovation capabilities and the ability to think creatively.
• Strong collaboration and team building skills within, across and outside of an organization.
• Maintain and promote a positive team environment.
• Maintains stable performance under pressure, demonstrating sensitivity to diverse organizational culture.
• Ability to effectively cope with change, remain flexible and adaptable within a fast-paced environment with rapidly changing requirements, and ability to negotiate situations when the big picture is not clearly defined.

PREFERRED SKILLS/ABILITIES/COMPETENCIES

• Strong root cause analysis and problem-solving skills
• Ability to juggle multiple projects in a high volume, fast-paced Production environment
• Ability to identify process improve opportunities and areas of potential conflict
• Working knowledge of MGB data products and platforms a plus
• Ability to quickly adapt to new technologies, concepts, and approaches
• Familiar with current healthcare and data management trends and industry practices
• Demonstrated ability to manage multiple priorities
• Microsoft Certified: Azure Solutions Architect Expert ( Nice to Have)
• Microsoft Certified: Azure Data Engineer ( Nice to Have)

For more information please contact Vijay Karney at or

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.

Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.

Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.