Data Architect

$65,000 - $65,000/Yr

Wright State University - Dayton, OH

Full-time

Dayton, OH

Educational Services

About the position

The Data Architect at Wright State University plays a crucial role in supporting the institution's reporting and analytic needs, aligning with the university's data governance framework and strategic plan. This position is dedicated to designing and documenting the enterprise's data management framework, which is essential for meeting the business intelligence (BI) requirements of the university. As a key member of the BI team, the Data Architect will focus on the ongoing growth and development of the university's operational data store (ODS) and enterprise data warehouse (EDW) capabilities. In this role, the Data Architect will be responsible for sourcing data, which includes extracting, transforming, and loading data while participating in data quality initiatives. The architect will assist in creating data objects and structures that are vital for forecasting revenues and expenses for the institution. This involves integrating data from various sources, ensuring data consistency and integrity throughout the integration process, and performing necessary data validation and cleaning. The position also entails accessing analytical data, where the Data Architect will design and develop business intelligence solutions to support reporting needs. This includes creating reports and dashboards using Wright State's BI tools, such as Oracle DBMS and Microsoft Power BI. The architect will review and analyze existing analytical systems to enhance their effectiveness and efficiency, developing processes and standards for further leveraging these systems. Additionally, the Data Architect will focus on data architecture by developing high-level enterprise logical and physical data models, as well as documenting the structure and layout of operational data systems. This includes detailing the relationships between databases, the ODS, the EDW, and other related data stores. The role also involves managing analytical data, where the Data Architect will assist in implementing and maintaining BI applications, resolving technical problems, and providing support during ODS/EDW upgrades. Participation in the university's Data Governance program and the management of metadata using tools like Data Cookbook are also key responsibilities. Finally, the Data Architect will serve as a member of the institution's BI team, collaborating with various functional areas to map business processes and continuously improve data structures and reporting sources.

Responsibilities

• Sourcing Data: Extract, transform, and load data; participate in data quality initiatives; assist in creating data objects and structures for forecasting revenues/expenses; integrate data from various sources; ensure data consistency and integrity during integration; perform data validation and cleaning.
• Accessing Analytical Data: Design and develop business intelligence solutions to support reporting needs; create reports and dashboards using Wright State BI tools; review and analyze existing analytical systems; develop and implement processes for improving these systems.
• Data Architecture: Develop high-level enterprise logical and physical data models; document the structure and layout of operational data systems; detail relationships between databases, ODS, EDW, and related data stores.
• Managing Analytical Data: Assist with implementing and maintaining BI applications; identify and resolve technical problems within BI applications; provide technical support for ODS/EDW; participate in Data Governance program; manage metadata using Data Cookbook.
• Institutional Research and Effectiveness Team Member: Collaborate with the BI team under the Director IRE; work with functional area representatives to map business processes; assist in problem resolution and support complex report development.

Requirements

• Bachelor's degree in computer science, data architecture, data/information science, or related field.
• 2 years of relevant experience in data architecture or related roles.
• Strong working knowledge of SQL and relational databases in a data warehousing environment.
• Experience in logical and physical data modeling, including the use of modeling tools such as Erwin.
• Familiarity with analytical data management environments such as data marts, operational data stores, data warehouses, or data lakes.
• Experience in systems development with enterprise systems and third-party applications; proficiency in software applications, technical skills, and business processes.
• Strong organizational and time-management skills.
• Ability to research topics to gain knowledge and understanding when information gaps exist.
• Ability to collaborate effectively with individuals from diverse backgrounds and cultures.

Nice-to-haves

• Experience using Ellucian's Banner enterprise resource planning solution, operational data store, and enterprise data warehouse.
• Experience with Oracle Database Management System.
• Familiarity with Microsoft Power Platform products, particularly Power BI, for reporting and analysis.
• Experience using Oracle Data Integrator or other data sourcing tools for ETL.
• Experience with IData's Data Cookbook or other metadata management tools.
• Experience using a customer relationship management (CRM) system such as Slate.
• Experience working in a higher education environment.