Vacancy expired!
Senior Data Warehouse Architect (Data & Analytics Organization)PERM POSTIONOpen to: Remote, on-site or hybridMUST HAVES:
- HealthCare experience (at least 3-4 years for Senior DA and 2-3 years for DA)
- Deep Dimensional modeling experience
- Leadership skills
- Good understanding of overall data architecture
- Experience in SQL Programming
- Strong Communication skills
- Self Motivated
- Team Player
- Are you comfortable with technical interviews to explain dimensional modeling in detail with the hiring manager?
- We seek employees who bring passion, are highly collaborative, and thrive in a dynamic, diverse, and inclusive team. We work in a highly agile environment with a focus on quality and achieving real impact with our work. We are excited to have a team with a rich mix of experiences, with people who bring innovative approaches to their work, an excitement for looking at things from new angles, and a spirit of continuous improvement. Finally, we seek employees who embrace and live our core values of respect, recognition, communication, commitment, trust, innovation, and service. If this sounds like you, we invite you to apply.
- Mass General Brigham s main office is in Somerville, MA. We are currently working as a fully-remote team due to COVID-19 and encourage applications from across the US as telecommuting becomes part of our new normal. We are committed to building an engaged, inclusive community and offer a variety of opportunities to come together virtually and facilitate learning and collaboration.
- Mass General Brigham s board and system-wide executive leadership are making significant investments in enterprise data and digital health, enabling innovation and transformation in the delivery of health care, research and discovery. By building out core digital and data capabilities, we are supporting the achievement of Mass General Brigham s mission to drive growth and innovation in inpatient, ambulatory, and digital care. We are at the start of this journey and we are looking for talented individuals from across the nation to join us in transforming healthcare and in achieving the expected outcomes of this strategy: improved patient care, quality of care, patient engagement, and efficiency in the delivery of healthcare with excellence. In the achievement of these goals, Mass General Brigham s data and analytic teams are working together to build a system-wide data ecosystem. We are both leveraging current assets and building new, integrated solutions to provide a holistic set of industry-leading data and analytic capabilities, supporting Artificial Intelligence (AI), Machine Learning (Client), and real-time insights. Teams from Data and Analytics, Research Analytics, Clinical Data Science, and Information Systems are collaborating to build this new data and analytic ecosystem. To ensure success of this effort, Mass General Brigham is standing up a new Data and Analytics operating model with a goal of driving a level of standardization for data and analytic operations across the teams involved.
- The value of investments in data and analytics were proven out during our response to COVID-19 as these investments were leveraged to stand up new reporting and analytic capabilities to support executive and clinical leadership on managing the pandemic. Our broad data and analytic community has come together across Mass General Brigham s 14 healthcare sites with shared urgency, delivering analytic tools to our system that drove timely insights in both clinical and operational domains, resultingin effective delivery of critical care and in organizational efficiencies during a time of reduced resources.
- As a Senior Data Architect, you are a critical member of the Mass General Brigham Data & Analytics Organization (DAO) Enterprise Data Warehouse Data Architecture team. The Data Architecture team works together with other DAO teams to design, develop, validate, maintain, and support the EDW platform and many different analytic data assets and products. The EDW team is in process of migrating to a Cloud Data platform and looking for a Cloud enthusiast as we move to Azure Cloud. The ideal candidate will have a strong data architecture pedigree, enjoys working with new data technologies and excellent communication and leadership skills. If you are seeking a new challenge and are motivated by transformations we encourage you to apply.
- Develop and revise the most complex conceptual, logical, and physical data models for an Enterprise (i.e. Enterprise Data Architecture)
- Build and maintain a deep understanding of the data and analytic landscape at Mass General Brigham including data sources, data and analytic assets and products, analytic tools and software, and master data
- Act as Technical Lead on data projects and guide and mentor other Data Architects and Data Engineers Determine database structural requirements by analyzing business operations, applications and data, evaluating current systems, and reviewing objectives with business partners
- Create data models that conform to current standards and conventions
- Apply expertise and best practices to the development and revision of data architecture standards and conventions as well as development processes and procedures
- Develop and revise data dictionary definitions and provide input to data governance practices and standards
- Partner with security architects to ensure compliance with data security and privacy policies and procedures
- Participate in Architectural strategies on the EDW migration to Cloud platform e.g. integration with Data Lake, other Azure services
- Understands how data is used to support analytical and/or operational reporting including architectural dependencies, high-volume processing, and enterprise-level integration
- Interviews business users to obtain requirements for enhancements and/or new analytic assets
- Maps source system data to data warehouse models
- Assists in the Development of data asset training and documentation
- Helps business users select the appropriate BI tool(s)
- Works with teams to integrate data across clinical, administrative, and financial source systems including the management of critical master data
- Develops and tests extraction, transformation, and load (ETL) processes
- Recommends standards for technology and technical processes
- Present best practices and provide feedback to other Data Architects at the Data Architecture
- Quality Circle workgroup
- Presents technical solutions to stakeholders and end users
- Use/s 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
- Minimum of 10 years of relevant hands on experience including data architecture design and
- deployment, data modeling especially dimensional data modeling (OLAP), and database
- development
- A strong foundation and experience in working with complex healthcare data is required,
- experience with Epic clinical or financial data a plus
- Excellent oral and written communication skills
- Experience using Erwin or similar tools for developing and maintaining data models
- Expert data analysis skills to profile and understand source system data
- Strong experience with SQL querying and programming
- Deep technical hands-on expertise in data warehousing, master data, big data analytics, realtime analytics, data visualization, business intelligence, NLP, and reporting
- Experience with Cloud Data Warehouse platforms e.g. Snowflake, Azure Synapse
- Experience with the Azure stack (Azure Data Factory, ADLS, Azure Databricks, Azure Client, Azure
- Synapse, and Azure SQL) to help build a modern platform for data that will be sourced from a variety of analytic and operational application
- Excellent consultative skills, ability to understand business needs and translate into technical requirements and automated solutions
- Strong creative problem solving with ability to craft Mass General Brigham-specific solutions to meet the wide range of business needs across the organization
Vacancy expired!