Lead Azure Solution Architect

Company: College of Charleston
Location: Somerville
Posted on: February 23, 2021

Job Description:

About Us:
As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.

We're focused on a people-first culture for our system's patients and our professional family. That's why we provide our employees with more ways to achieve their potential. Mass General Brigham is committed to aligning our employees' personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal development-and we recognize success at every step.

Our employees use the Mass General Brigham values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.

General Summary
--- We are looking for a self-motivated Big Data Architect to join our data engineering team.
--- We are looking for an accomplished Big Data Architect with strong experience in the Azure, Cloud Data lake architecture and implementation.
--- This role will involve a close collaboration with our team of passionate and innovative big data specialists, application developers and product managers.
--- This is a unique opportunity to be a Lead Architect in our Corporate Data Engineering Team, tackling our toughest and most exiting data lake challenges across multiple divisions in the firm.
--- Design, Develop, construct, test and maintain architectures such as Data Lake, large-scale data processing systems
--- Big data ecosystem related Tool selection and POC analysis
--- Gather and process raw data at scale that meet functional / non-functional business requirements (including writing scripts, REST API calls, SQL Queries, etc.)
--- Develop data set processes for data modeling, mining and production
--- Integrate new data management technologies (Collibra, Informatica DQ..) and software engineering tools into existing structures
--- The candidate will be responsible for leading Architecture for building a new Data Lake, expanding and optimizing our data platform and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams.
--- The ideal candidate is an experienced data pipeline builder who enjoys optimizing data systems and building them from the ground up.
--- The individual will lead solution implementation leading and collaborating with our Software Developers, Database Architects, Data Analysts and Data Scientists on Big data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.
--- They must be self-directed and comfortable leading the architecture needs of Big data eco system and analytics solutions with multiple teams, systems and products.
--- Build the Cloud Big data infrastructure required for optimal extraction, transformation, and loading of data from traditional/legacy data sources.
--- Work with stakeholders including the Management team, Product owners, and Architecture teams to assist with data-related technical issues and support their data infrastructure needs.
--- Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.

Working Conditions

--- Office setting, with some local travel between Partners Healthcare System sites
--- May require occasional travel for training

Supervisory Responsibility

--- The position will manage 5-8 architect and engineering professionals



Qualifications
--- 5-7 Years of experience architecting and building Cloud Data Lake, specifically Azure Data Analytics technologies and architecture is desired, Enterprise Analytics Solutions, and optimizing 'big data' data pipelines, architectures and data sets.
--- 5 years of experience leading Scrum teams, Architects, Technology professionals
--- Advanced hands-on SQL, Spark, Python, Scala, pySpark (2+ of these) knowledge and experience working with relational databases for data querying and retrieval.
--- Experience with Design and Architecture of Azure big data frameworks/tools: Azure Data Lake, Azure Data Factory, Azure Data Bricks, Azure ML, SQL Data Warehouse, Azure Data Bricks..
--- Experience with Design and Architecture of Apache Hadoop big data frameworks/tools: Hadoop, Kafka, Spark, etc.
--- Experience with Design and Architecture of relational SQL and NoSQL databases, including MS SQL Server, Cosmos DB
--- Experience with Design and Architecture of data security and Azure security, VM, Vnet
--- Experience with building processes supporting data transformation, data structures, metadata, dependency and workload management.
--- Experience leading and working with cross-functional teams in a dynamic environment.
--- Experience building Big data pipeline with Spark and/or Data Bricks is a plus.
--- 5-7 Years of Experience with Hadoop based technologies (e.g. hdfs, Spark). Spark Experience desirable
--- Strong SQL skills on multiple platform (preferred MPP systems)
--- Leading development of Data Lake Architectures from scratch
--- Data Modeling tools (e.g. Erwin, Visio)
--- 5+ years of Programming experience in Python, SQL, Spark
--- Experience with Azure DevOps/CI-CD, Continuous integration and deployment
--- Experience with Real time analytics on Spark, Kafka, Event Hub is a plus
--- Experience in petabyte scale data environments and integration of data from multiple diverse sources
--- Cloud advanced analytics - Azure ML, machine learning, text analysis, NLP is a plus
--- Healthcare experience, most notably in Clinical data, Epic, Clarity, Payer data and reference data is a plus but not mandatory

Skills/Abilities/Competencies Required

--- Expertise in the Azure or any other Cloud Data Lake and relational Data Warehouse platforms
--- Demonstrated experience in Azure Analytics and Big Data technologies, Data Lake development
--- Experience with real time data processing and analytics products - Event Hub, Kafka, Spark, Azure Data Bricks
--- Experience with Azure Big data technologies (Azure Data Lake, Azure Data Factory, Azure Data Bricks, Azure ML, SQL Data Warehouse, HDInsight..)
--- Azure certification preferred but not mandatory
--- Any Big Data certification is a plus
--- Experience managing engineering professionals
--- Large data warehousing environments in at least two database platforms (Oracle, SQL Server, DB2, etc)
--- Programming experience in Python, Java, SQL, good to have .Net, C#
--- Data engineering ETL, data processing expertise in Azure (Azure Data Factory, Data Bricks..), Hadoop (map-reduce, spark, sqoop) and SSIS, HealthCatalyst, Informatica - any 2-3 of these would be preferred
--- Familiarity with data governance and data quality principles, good to have experience with data quality tools
--- Ability to independently troubleshoot and performance tune in large scale data lake, enterprise systems
--- Knowledge of data architecture principles, data lake, data warehousing, agile development, DevOps methodologies
--- Understanding of change management techniques, and the ability to apply them
--- Excellent verbal and written communication skills, problem solving and negotiation skills
--- Act as an effective, collaborative team member



EEO Statement
Mass General Brigham is an Equal Opportunity Employer & by embracing diverse skills, perspectives and ideas, we choose to lead. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under law.
Partners Healthcare System Inc. is acting as an Employment Agency in relation to this vacancy. Internal Number: 3136652-1435_1607615369 About MGH Institute of Health Professions MGH Institute of Health Professions, founded by Massachusetts General Hospital in 1977, is an innovative and independent graduate school in Boston that is a member of Partners HealthCare. A progressive leader in developing comprehensive models of health care education, the MGH Institute prepares advanced practice professionals in the fields of nursing, physical therapy, occupational therapy and communication sciences and disorders through a distinctive combination of academic study, clinical practice, and research. More than 1,200 students are enrolled in graduate level and certificate programs, with an increasing number of courses available online. The Institute is accredited by the New England Association of Schools and Colleges (NEASC). 66 George Street
Charleston, South Carolina 29424
843.805.5507

Keywords: College of Charleston, Somerville , Lead Azure Solution Architect, Other , Somerville, Massachusetts