Position Information Position Information (Default Section)

EEO Statement Wright State University, an equal opportunity/affirmative action employer. Faculty Rank or Job Title Data Architect Job Category: Administrative (exempt/non-exempt) Department Institutional Research EEO number: 24P286 Position FTE 100% Minimum Annual or Hourly Rate $65,000 Salary Band: S05 Job Summary/Basic Function: The Data Architect supports Wright State University’s reporting and analytic needs, guided by the institution’s data governance framework and strategic plan, by designing and documenting the enterprise’s data management framework to support business intelligence (BI) needs. The Data Architect will be a dedicated member of the BI team responsible for ongoing growth and development of the University’s operational data store (ODS) and enterprise data warehouse (EDW) capabilities. Minimum Qualifications Bachelor’s degree in computer science, data architecture, data/information science or related field and 2 years of relevant experience Strong working knowledge of SQL and relational databases in a data warehousing environment Logical and physical data modeling experience and use of a modeling tool such as Erwin Working knowledge of analytical data management environments such as data marts, operational data stores, data warehouses or data lakes Experience in systems development working with enterprise systems and third-party applications or demonstrated proficiency with software applications, technical skills and business processes Strong organizational and time-management skills Experience researching topics to gain knowledge and understanding when information gaps exist Ability to collaborate effectively with others from wide variety of backgrounds and cultures Preferred Qualifications Experience using Ellucian’s Banner enterprise resource planning solution, operational data store, and enterprise data warehouse Experience using the Oracle Database Management System Experience using Microsoft Power Platform products, namely Power BI or other data access tool for reporting and analysis Experience using Oracle Data Integrator or other data sourcing tool for ETL Experience using IData’s Data Cookbook or other metadata management tool for metadata management Experience using a customer relationship management (CRM) system such as Slate Experience working in a higher education environment Essential Functions and percent of time: 30% Sourcing Data Extract, transform, and load data and participate in data quality initiatives. Assist in the creation of data objects and structures, such as those used to forecast revenues/expenses for the institution. Integrate data from different sources, including databases, data warehouses, application programming interfaces (APIs), and external systems. Ensure data consistency and integrity during the integration process, performing data validation and cleaning as needed.

30% Accessing Analytical Data Design and develop business intelligence solutions to support business and reporting needs (i.e., reports, dashboards) using Wright State BI tools including Oracle DBMS, Microsoft Power BI, SQL, and tools associated with individual applications. Review and analyze the effectiveness and efficiency of existing analytical systems and develop/implement processes and standards for improving or further leveraging these systems.
20% Data Architecture Develop a high-level enterprise logical data model, physical data model, and views of related data sub-architectures such as database, data integration, data warehouse/BI, reporting metadata, and content management architectures. Design/document the structure and layout of operational data systems and their relationship to the analytical data management environment including databases, the operational data store (ODS), the enterprise data warehouse (EDW), and related data stores. Essential Functions and percent of time (cont'd): 10% Managing Analytical Data Assist with implementing and maintaining BI applications. Identify, research, and resolve technical problems within BI applications. Provide technical support for the ODS/EDW and work closely with database administrators during ODS/EDW upgrades. Participate in the implementation of Wright State’s Data Governance program. Support the definition and management of metadata including the use of Data Cookbook.

10% Institutional Research and Effectiveness Team Member Serve as a member of the institution’s BI team under the leadership of the Director IRE. Work with representatives from functional areas and CaTS to map business processes/requirements and to continuously improve data structures and reporting data sources. Assist in problem resolution and support of complex report development. Other duties as assigned. Non-Essential Functions and percent of time: Working Conditions Distributed office-like environment. Work may be required outside of typical hours or in excess of typical hours. Position requires the ability to work remotely and employee must provide their own internet and phone connection.

To preserve the safety and security of the campus community and to maintain the integrity of university operations, it is the policy of Wright State University before making an employment offer conduct various background checks, such as a criminal record, credit history when job related and/or education verifications. Additionally, an administrative review shall be conducted whenever the university learns that an employee is charged with or convicted of a crime (except for minor vehicle violations). Frequently asked questions related to background checks may be found on the Human resources website at http://www.wright.edu/human-resources.

Effective July 1, 2017, per Policy 7230 Wright State University is tobacco-free. Tobacco use, including the sale, advertising sampling and distribution of tobacco products and tobacco related items is prohibited in all university facilities, on all university owned or leased grounds, university owned or operated residence halls and apartments, and at all university sponsored events regardless of location. Tobacco use is also prohibited in all university vehicles or on any equipment owned, leased or operated by Wright State University. This policy applies to anyone on campus including students, faculty, staff, visitors, consultants, vendors, patients, volunteers, and contractor employees. Special Instructions to Applicants Posting Date 07/24/2024 First Consideration Date: 07/30/2024 Closing Date Open Until Filled Yes Supplemental Questions

Required fields are indicated with an asterisk (*).

* Do you have a bachelor’s degree in computer science, data architecture, data/information science or related field? yes no * Do you have at least 2 years of experience in database development, design, management, and/or warehousing? yes no * Do you have strong working knowledge of SQL and relational databases in a data warehousing environment? yes no * Do you have experience designing logical and physical data models and using a modeling tool? yes no * How did you hear about this position at Wright State University? Please check all that apply. WSU Careers website Academic Careers Academic Keys Chronicle Diversity in Higher Ed Diverse Issues in Higher Ed Facebook HBCU Higher Ed Jobs Inside Higher Ed LinkedIn Social Media Personal referral Women in Higher Ed Other Job Fair or Hiring Event Required Documents Required Documents Cover Letter Resume/CV References Optional Documents