Lead Data Engineer, Data Strategy

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, mission and values and rich benefits make us an employer of choice. We are part of the University System of Georgia . Kennesaw State will exemplify the power and promise of a student-centered, research-driven university. Our institutional values are student-inspired, promise-fulfilling, true to ourselves, elevational, open and impact-generating. In addition, we support the University System of Georgia core values of accountability, excellence, integrity and respect. We are searching for talented people to join Kennesaw State University. Come to KSU and find your passion.

Location

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

Job Summary

Leads the creation of logical data models from many systems and processes on Kennesaw State University's campus. Provides support for the Enterprise Data Warehouse and monitors data warehousing system to ensure reliability and accuracy of information loaded into the databases and data lakes. Analyzes the logical and physical database models, and ensure models are in accordance with standards. Generates and prepares reports to support business objectives. Performs analysis and testing of semantic models and investigates any data load failures or data retrieval issues.

Responsibilities

KEY RESPONSIBILITIES: -
1. Develops conceptual, logical, and physical data models for business intelligence efforts. Ensure that all relevant aspects of data model (granularity, etc.) are taken into account
2. Analyzes the logical and physical database models and guarantee models are in accordance with standards
3. Responsible for leading and facilitating communication with campus customers, UITS staff, and other stakeholders, incorporating business requirements into data model design
4. Provides support for data warehousing initiatives and monitor data warehousing system to ensure reliability and accuracy of information loaded into the databases
5. Translates technical aspects of data modeling (facts, dimensions, snowflaking, etc.) into language that non-technical users can understand
6. Works with both technologists as well as non-technical users with ease and approachability
7. Makes recommendations on data maintenance tactics for slowly changing dimensions, data roll-off, archival planning, etc.
8. Designs models optimized for both storage (warehouse) and query and retrieval (end user marts)
9. Performs analysis and testing of relational databases and investigates any data load failures or data retrieval issues
10. Understands and balances business requirements and user expectations

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
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
Data modeling experience
Experience with database management systems (management and query)

Proposed Salary

The budgeted salary range is $ 99,500.00 to $120,000. Offers are based on relevant experience.

Generous benefits to include Medical, Dental, Vision, 13 paid holidays, vacation, great retirement plans, tuition waiver, wellness options, and much more. Visit https://hr.kennesaw.edu/benefits/index.php

Proposed Salary

The budgeted salary range is $99,500 to $120,000. Offers are based on relevant experience.

Comprehensive benefits include Medical, Dental, Vision, 13 paid holidays, vacation, generous retirement plans, tuition waiver, wellness options, and much more!

Visit- https://hr.kennesaw.edu/benefits/index.php

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 handle multiple tasks or projects at one time meeting assigned deadlines

KNOWLEDGE
Conceptual, Logical and Physical Data Modeling
Knowledge and experience in implementing Kimball data warehouse design principals
Demonstrated expertise in the following tools, technologies and methodologies: Data design and 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)
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

USG Core Values

The University System of Georgia is comprised of our 26 institutions of higher education and learning as well as the System Office. Our USG Statement of Core Values are Integrity, Excellence, Accountability, and Respect. These values serve as the foundation for all that we do as an organization, and each USG community member is responsible for demonstrating and upholding these standards. More details on the USG Statement of Core Values and Code of Conduct are available in USG Board Policy 8.2.18.1.2 and can be found on-line at https://www.usg.edu/policymanual/section8/C224/#p8.2.18_personnel_conduct .

Additionally, USG supports Freedom of Expression as stated in Board Policy 6.5 Freedom of Expression and Academic Freedom found on-line at https://www.usg.edu/policymanual/section6/C2653 .

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 225, eeo@kennesaw.edu.

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

Background Check

• Credit Report
• 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