Data Architect

Job Title:Data Architect
Location: Kennesaw, Georgia
Regular/Temporary: Regular
Full/Part Time: Full-Time
Job ID: 264397
About Us

Are you ready to join a community leading in innovative teaching and learning? Kennesaw State University is one of the 50 largest public institutions in the country. With our growing enrollment and global reach, we are enjoying increased prominence among Georgia¿s colleges. We offer more than 150 undergraduate, graduate, and doctoral degrees to over 43,000 students. Our entrepreneurial spirit, high-impact research, and Division I athletics also draw students from throughout the region and from 92 countries across the globe. Our university¿s vibrant culture, career opportunities, and rich benefits make us an employer of choice. We are searching for talented people to join our mission. Come to KSU and find your passion.

Location

Our Kennesaw campus is located at 1000 Chastain Road NW, Kennesaw, GA 30144.

Job Summary

Responsible for the design and full lifecycle of the University's Data Architecture in matters related to delivering a platform and tool set for master data management and supporting enterprise data warehouse management across the institution. Works with technical and business experts that support source systems to extract and transform institutional data from systems of record to build an environment that allows accurate, timely, reliable, repeatable and relatable institutional reporting, data mining, online analytical processing, market research, and decision support.

Responsibilities

KEY RESPONSIBILITIES*: -
1. Responsible for the design and full lifecycle of information systems used in support of institutional research, reporting, data analysis, strategic information requests and decision making and support needs
2. Responsible for the design, planning, implementation, and support of enterprise data warehousing, operational data stores, data marts, data modeling, ETL/data integration, and operational reporting capabilities
3. Responsible for maintaining documentation of data lineage and an inventory of data sources
4. Responsible for partnering with all areas of the institution to discover and develop data systems to use for reports to meet their information and analytics needs
5. Participates, as directed, in data governance activities and is responsible for ensuring adherence to data governance policies, processes, and procedures
6. Responsible for the security, stability, integrity, and recoverability of information systems in support of institutional reporting, analysis, and decision making
7. Responsible for forecasting infrastructure needs to keep pace with institutional research and data needs

Required Qualifications

Educational Requirements
Bachelor's degree from an accredited institution of higher education in Computer Science, Information Systems, Business Administration or related field
Required Experience
Seven (7) years of related IT experience demonstrating a progression of increasing responsibility experience including data modeling and database management

Preferred Qualifications

Preferred Educational Qualifications
An advanced degree from an accredited institution of higher education in a related field
Preferred Experience
Experience with Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, PySpark, Tableau
Experience working with Power BI, including: report development, modeling, administration, role-based security, dataflows, Power Query, and DAX
Previous experience working in higher education and/or institutional research
Experience working with Ellucian's Banner, PeopleSoft, Oracle, etc.
Experience designing and managing enterprise data warehouses and information systems
Experience with database management systems (management and query)

Knowledge, Skills, & Abilities

ABILITIES
Able to lead large projects that require strong partnerships and coordination with multiple institutional units
Able to translate between technical and business teams
Able to develop and execute information systems strategy
Able to anticipate problems and proactively develop appropriate solutions
Able to handle multiple tasks or projects at one time meeting assigned deadlines
KNOWLEDGE
Demonstrated expertise in the following tools, technologies and methodologies: Data design/modeling, Data warehousing, Operational data stores, Relational databases (e.g., Microsoft SQL Server, Oracle RDBMS), Data Integration/ETL tools (e.g., Oracle Data Integrator, SSIS), SQL (PL/SQL, T-SQL), Business analytics and reporting tools (e.g., Tableau, Power BI, Argos, SAS)
Expertise in data warehouse architecture, including ETL/ELT and data mart design patterns, as well as experience with cloud data warehousing solutions, data lakes, and data lakehouses
Proven experience in data modeling, with focus on techniques such as star-schema, snowflake schema, normalized/denormalized models, and materialized view patterns
Extensive knowledge of master data management, enterprise data management, information systems, business analytics and reporting tools, planning, operations, and lifecycle management
SKILLS
Excellent interpersonal, initiative, teamwork, problem solving, independent judgment, organization, communication (verbal and written), time management, project management and presentation skills
Proficient with computer applications and programs associated with the position (i.e., Microsoft Office suite)
Strong attention to detail and follow up skills
Strong customer service skills and phone and e-mail etiquette

Equal Employment Opportunity Kennesaw State University is an Equal Employment Opportunity Employer. The University is committed to maintaining a fair and respectful environment for living, work and study. To that end, and in accordance with federal and state law, Board of Regents policy, and University policy, the University prohibits harassment of or discrimination against any person because of race, color, sex (including sexual harassment, pregnancy, and medical conditions related to pregnancy), sexual orientation, gender identity, gender expression, ethnicity or national origin, religion, age, genetic information, disability, or veteran or military status by any member of the KSU Community on campus, in connection with a University program or activity, or in a manner that creates a hostile environment for members of the KSU community. For additional information or to file a complaint under the provisions of this policy, students, employees, applicants for employment or admission or other third parties should contact the Office of Institutional Equity at English Building, Suite 202, eeo@kennesaw.edu, or by making a report here.

Other Information

This is not a supervisory position.
This position does not have any financial responsibilities.
This position will not be required to drive.
This role is considered a position of trust.
This position does not require a purchasing card (P-Card).
This position may travel 1% - 24% of the time
This position does not require security clearance.

Background Check

• Standard Enhanced
• Education

Per the University System of Georgia background check policy, all final candidates will be required to consent to a criminal background investigation. Final candidates may be asked to disclose criminal record history during the initial screening process and prior to a conditional offer of employment. Applicants for positions of trust with screening results which confirm a disqualifying criminal history will be immediately disqualified from employment eligibility.

All applicants are required to include professional references as part of their application process. Some positions may require additional job-based screenings such as motor vehicle report, credit check, pre-employment drug screening and/or verification of academic credentials.

https://www.usg.edu/hr/assets/hr/hrap_manual/HRAP_Background_Investigation_Employment.pdf