Azure Data Lake Principal Architect/Principal Data Engineer - Somerville, United States - Mastech Digital

Description

TITLE: Azure Data Lake Principal Architect/Principal Data Engineer

LOCATION: Somerville MA (HYBRID): 1-2x a week onsite - Hours: 8:30am-5pm

Type: PERM

Salary range: $140k-$170k (Depending on Exp)

*** 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.***

OVERVIEW

• The Data Lake Team plays a pivotal role in harnessing the power of data to drive innovation, enhance patient care, and advance research initiatives. As a leading integrated health system relies 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 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 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 providing high-quality patient care and advancing medical knowledge.

DESCRIPTION

Seeking a highly skilled and experienced Principal Data Engineer that will play a crucial role in designing, developing, and maintaining data infrastructure and platform integration solutions. The Principal Data Engineer will be responsible for advancing data engineering capabilities, ensuring data quality, and contributing to the success of data-driven initiatives.

RESPONSIBILITIES

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 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/ML 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.

QUALIFICATIONS:

• 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

• 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.

Note: If interested please email me your resume at or call me at .

Best Regards,

Anil Chamoli

Team Lead ( Recruitment & Sales)