Senior Data Architect Healthcare Somerville, MA 02145(100% Remote) tg Job Type: Full-time Salary: $160k/Annum Job Description As a Senior Data Architect, you are a critical member of the our client 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. Role Summary The Senior Data Architect reporting directly to the Manager of the Enterprise Data Warehouse will specifically be responsible to: 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 our client 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 Principal Duties and Responsibilities 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 our client 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 Qualifications 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 Preferred Skills/Abilities/Competencies 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 our client-specific solutions to meet the wide range of business needs across the organization #J-18808-Ljbffr
Azure SQL Database data-security Data Engineering Azure ADLS snowflake-cloud-data-platform Writing reports and proposals Communication cloud-computing data-modeling data governance azure-databricks Business Intelligence (BI) Azure Data Factory Natural language processing (NLP) Data Analyst azure-stack Data Projects data-warehouse azure-synapse Data lake Data Architect data-visualization erwin ETL Healthcare industry Leadership