Find A Job  ▶
Find Talent  ▶


Data Warehouse Architect

Somerville, Massachusetts - Posted on October 14, 2021
Published By Dede Nickerson

Now hiring a Data Warehouse Architect for direct-hire!

Job Description

Trillium Technical is now seeking a Data Warehouse Architect (Enterprise Data & Digital Health) for direct-hire!

As a Senior Data Architect, you are a critical member of the 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 Data Architect reporting directly to the Manager of Enterprise Data Architecture will specifically be responsible to:
• Develop and revise conceptual, logical, and physical data models for an Enterprise (i.e. Enterprise Data
• Build and maintain a deep understanding of the data and analytic landscape including data sources, data and analytic assets and products, analytic tools and software, and master data
• Determine database structural requirements by analyzing business operations, applications, and programming; reviewing objectives with business partners; evaluating current systems;
• 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
• Develop and revise data dictionary definitions, governance practices, and standards;
• Partner with security architects to ensure compliance with data security and privacy policies and
• Participate in Architectural strategies on the EDW migration to Cloud platform e.g. integration with Data Lake and other Azure services

Principal Duties & Responsibilities
• Understands how data is used to support analytical and/or operational reporting
• 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
• 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 • Follows standards for technology and technical processes
• Presents technical solutions to stakeholders and end users

If interested, please apply today!


• Minimum of 5 years of relevant experience including continuing to innovate data architecture design and
deployment, and data modelling especially dimensional data modeling (OLAP)
• Must possess excellent oral and written communication skills
• Must possess strong data modeling skills
• Must possess experience using Erwin or similar tools for developing and maintaining data models
• Must possess strong data analysis skills into source systems to profile source system data
• Must have strong experience with SQL
Preferred Skills, Abilities and Competencies
• Experience with SQL Server platform is preferred
• Healthcare industry experience and Epic data experience is preferred
• Experience with Health Catalyst a plus but not required
• Experience with Tableau reporting tools a plus but not required
• Experience in agile development data projects a plus but not required
• Excellent consultative skills, understanding business needs and translating those needs to technical
requirements and solutions.
• Strong creative problem solving with ability to craft specific solutions to meet the wide range of business needs across the organization
• Adept at establishing trusted relationships at all levels across the organization and collaborating across multi-functional teams
• Relational and dimensional data modeling and database design skills
• Knowledge of data warehousing architectural approaches
• Understanding of SQL and relational and multidimensional designs
• Ability to construct queries using a supported query tool
• Understands BI tool architecture, functions, features
• Flexibility, diplomacy, and problem-solving
• Ability to communicate effectively with all levels of the organization including senior business and clinical leaders and executives
• Experience with Cloud Data Warehouse platforms e.g. Snowflake, Azure Synapse
• Experience with the Azure stack (Azure Data Factory, ADLS, Azure Databricks, Azure ML, 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

Trillium has been recruiting and placing professionals for over 30 years. From Fortune 100 companies to small businesses, our philosophy remains the same: to achieve excellence by providing quality employees and an uncompromising level of service. We believe in honesty, integrity, and a simple philosophy of providing value to our customers and our employees. We strive to be unsurpassed in the recruitment and placement of quality and skilled professionals. Trillium is an Equal Opportunity Employer.

Want to apply for Data Warehouse Architect?

  • To apply for Data Warehouse Architect enter your email address below.

  • If you have an account with, you can also


      Contact Us if you have any questions


      Similar Jobs

      Nearby Jobs

      The quickness of your response to our needs is unparalleled by any other source.