Data Architect II (Full-Time, Remote, North Carolina Based) (Healthcare)

The Data Architect II is responsible for the overall design, development, and support of the Alliance Enterprise Data Warehouse, the MicroStrategy Data Analytics project, and other enterprise supported data platforms.  These responsibilities include defining the data requirements driven by business needs and developing the respective data constructs and processes to support our business intelligence and data analytics initiatives. The Data Architect II provides leadership and guidance to other teams in data modeling, data governance and data quality best practices.

This position is fulltime remote. Selected candidate must reside in North Carolina. Some travel for onsite meetings to the Home office at Morrisville may be required. 

Responsibilities & Duties

Assist with Data Strategy

• Support the Data Architecture Manager and area Director defining the overall data strategy and architecture including master data management and data governance activities and initiatives
• Assist in establishing standards and guidelines for the design, development, testing, deployment, and maintenance of enterprise supported data platforms
• Assist in defining and implementing the strategic analytics roadmap for the Enterprise Data Warehouse, MicroStrategy and other enterprise supported data platforms including the overall strategy for data integration and available data sources
• Interpret and deliver impactful plans that support corporate strategy and improve data integration, data quality and data delivery in support of business initiatives and roadmaps

Gather and Analyze Data requirements

• Participate in business analysis activities to elicit data product requirements
• Translate requirements, including high-level requirements, into technical specifications that will be used to develop the required data constructs
• Perform data analysis of healthcare datasets and data constructs to get insights into data availability and usage to determine its relationship with development efforts and its integration into enterprise supported data platforms

Data Modeling

• Design, develop and maintain effective data solutions and models to store, retrieve, report, and analyze healthcare data from multiple data sources
• Design, develop and maintain ETL and ELT processes
• Work with ETL Developers, BI Report Developers, Data Engineers, and other data-based roles as needed in the design, development, testing, and implementation of data products and solutions
• Ensure appropriate quality and consistency of all data
• Monitor our data platforms' performance by executing regular tests, troubleshooting, and integrating new features

QA / Peer Review

Test and review data products, processes, solutions, and models to ensure that requirements are met and that they are developed in line with our development standards and best practices

Documentation

• Following our development standards and best practices, document developed data products. This includes both technical and end-user documentation
• Maintain and update the organization's data catalog as necessary

Data product support

• Provide support on developed data products as required
• Provide technical assistance, collaborate with and exercise cross training opportunities with other team members

Minimum Requirements

Education & Experience

Bachelor's degree in Computer Science or related field and at last 5 (five) years of experience working as a Data Architect in a multi-dimensional data warehouse with direct involvement and responsibilities supporting an enterprise analytics platform, preferably in a healthcare setting

Knowledge, Skills, & Abilities

• SQL, preferably T-SQL
• DW/Multidimensional models and star-join schemas
• Analysis of large and/or complex datasets
• MicroStrategy (or similar BI platform) development
• Communication and organizational skills
• Ability to work independently and in a team setting

Employment for this position is contingent upon a satisfactory background check and credit check, which will be performed after acceptance of an offer of employment and prior to the employee's start date. 

Salary Range 

$105,497-$120,002.52/Annually 

Exact compensation will be determined based on the candidate's education, experience, external market data and consideration of internal equity. 

An excellent fringe benefit package accompanies the salary, which includes:  

• Medical, Dental, Vision, Life, Long Term Disability
• Generous retirement savings plan
• Flexible work schedules including hybrid/remote options
• Paid time off including vacation, sick leave, holiday, management leave
• Dress flexibility

Education

Preferred

• Bachelors or better in Computer Science

Skills

Required

• Analysis
• SQL database design

Preferred

• MicroStrategy

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

See job description