The Data Architect I 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.

This position is full-time remote. Selected candidate must reside in North Carolina and available to travel for onsite meetings to the Home office (Morrisville, NC), as required.

Responsibilities & Duties

Gather requirements and perform data analysis

• 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

Conduct 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

Conduct QA and 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

Maintain 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

Minimum Requirements

Education & Experience

Bachelor’s degree in Computer Science or related field and at least 3 (three) 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
• ETL/ELT development, preferably SSIS
• MicroStrategy (or similar BI platform) development
• Communication and organizational skills
• Ability to work independently and in a team setting
• Experience working with healthcare datasets

Salary Range 

$81,525.00 to $135,875.00/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 and Short-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