United States onlyThe 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
