Senior Data Warehouse Architect w/Data Analytics at Mastech Digital

Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking a Senior Data Warehouse Architect w/Data Analytics for our client in the Healthcare domain. We value our professionals, providing comprehensive benefits and the opportunity for growth. This is a Permanent position, and the client is looking for someone to start immediately.

Duration: Full-time

Location: Remote

Salary: $150,000-$165,000/Annually + Benefits

Role: Senior Data Warehouse Architect w/Data Analytics

Primary Skills: Data Warehouse

Role Description: The Senior Data Warehouse Architect must have at least 8+ years of experience. Senior Data Warehouse Architect is a critical member of the Digital Analytics, Enterprise Data Warehouse Data Architecture team. 

The Data Architecture team works together with other Data and Analytic teams to design, develop, validate, maintain, and support the platform and many different analytic data assets and products. 

Responsibilities: 

- Design, develops and revises conceptual, logical, and physical data models that conform to Data Architecture standards for Digital (i.e., Digital Data Architecture).

- Builds and maintains 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.

- Acts as Technical Lead on data projects and guide and mentor other Data Architects and Data Engineers.

- Determines database structural requirements by analyzing business operations, applications, and programming; reviewing objectives with business partners; evaluating current systems.

- Applies expertise and best practices to the development and revision of data architecture standards and conventions.

- Partners with security architects to ensure compliance with data security and privacy policies and procedures.

- Participates in Architectural strategies on the EDW migration to Cloud platform e.g., integration with Data Lake and other Azure services.

- Interviews business users to obtain requirements for enhancements and/or new analytic assets.

- Understands how data is used to support analytical and/or operational reporting including architectural dependencies, high-volume processing, and enterprise-level integration.

- Works with teams to integrate data across clinical, administrative, and financial source systems including the management of critical master data.

- Follows standards for technology and technical processes.

- Presents technical solutions to stakeholders and end users.

Technical Skills:

- Minimum of 8 years of relevant experience including continuing to innovate data architecture design and deployment, and data modelling especially dimensional data modeling (OLAP), and database development.

- Experience with Cloud Data Warehouse platforms e.g., Snowflake, Azure.

- Experience with the Azure stack (Azure Data Factory, ADLS, Azure Databricks, Azure ML, and Azure SQL) to help build a modern platform for data that will be sourced from a variety of analytic and operational applications.

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

- Experience with SQL Server platform is preferred.

- Healthcare industry experience and Epic data experience is preferred.

- Experience with Tableau reporting tools a plus but not required.

- Experience in agile development data projects a plus but not required.

Skills/Abilities/Competencies: 

- Must possess excellent oral and written communication skills.

- Understands how data is used to support analytical and/or operational reporting.

- Excellent consultative skills, understanding business needs and translating those needs to technical requirements and solutions. 

- Strong creative problem solving with ability to craft 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.

Education: Bachelor’s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field or Equivalent 

Experience: Minimum 8+ years of relevant experience

Relocation: This position will not cover relocation expenses

Travel: No

Local Preferred: Yes

Note: Must be able to work on a W2 basis (No C2C)

Recruiter Name: Vineet Mullick

Recruiter Phone: 412-684-6373

Equal Employment Opportunity