Before u proceed below to check the jobs/CVs, please select your favorite job categories, whose top job alerts you want in your email & Subscribe to our Email Job Alert Service For FREE
Job Location: Manhattan, KS
Department: 3670003050 Institutional Research
Job no: 513975
Employment type: Staff Full Time (Unclassified – Regular)
Location: Manhattan, Kansas
Worksite: Remote eligible (must reside in US)
Categories: Administrative / Professional, Computer Science / Information Technology, Office / Clerical
Pay Grade: 11A
About This Role:
The Office of Institutional Research and Assessment (OIRA) is seeking to hire a Data Warehouse and Business Analytics Developer. The primary purpose of this position is to provide data warehouse and data analytics development in support of K-State’s strategic efforts, including enrollment management, online learning, accreditation and compliance, and other emergent areas of need. This position will also assist in the design, development and implementation of dimensional models, or other data structures as needed for the enterprise data warehouse (EDW). We are transitioning from an on-prem data warehouse to a cloud based platform (Snowflake) and building our enterprise data warehouse from the ground up. This is an exciting time to join our team. The position provides capacity to strengthen the user service capacity for BI tool/dashboards, data requests, as well as some external surveys. Some responsibilities include, but are not not limited to:
50% Enterprise Data Warehouse Development
Work under the guidance of the Director of DW for the following tasks.
Collaborate with Data Architects in designing data structures to support OIRA reporting.
Work with business users and OIRA staff to understand needs and build the semantic layer and curated data sets (KPIs, summary metrics, labels, etc.) by merging data sets from disparate sources.
Write complex queries to retrieve data from the EDW.
Work with Division of IT colleagues in a fusion style team environment.
Work on identifying and resolving data quality issues.
Additional duties may include gathering and analyzing business, data and reporting requirements, documentation and specification of requirements, working with users to understand and document data definitions and maintaining the data dictionary.
30% Business Analytics
Develop BI tools/dashboards, conduct data analyses, and prepare reports to support K-State’s strategic efforts.
Collaborate with key stakeholder groups across campus to understand data needs and ensure requirements are met.
Find, gather, and organize data from multiple sources.
Perform moderately complex queries of databases.
Serve as a member of the core BI development team within OIRA.
Participate in meetings to stay up to date on available data, systems, and processes.
Respond to ad hoc data requests.
Perform technical data support duties as assigned.
20% Reporting
Access and perform complex query functions of databases to complete critical reports for external (governmental, public, and private) agencies, such as certain reports for the State of Kansas, consortium-based data reports, and institutional rankings.
Provide data analysis and data reports to support specialized accreditations and/or ranking, such as AACSB (Business), CAEP (Education), ABET (Engineering
Respond to different ad hoc data requests.
Perform technical data support and other duties as assigned
Why Join Us:
Kansas State University offers a comprehensive benefits package that includes health insurance, life insurance, retirement plans, paid time off – vacation, sick, and holidays. To see what benefits are available, please visit: https://www.k-state.edu/hcs/benefits
We Support Diversity and Inclusion:
Worksite Options:
Kansas State University embraces diversity and inclusion. The university actively seeks individuals who foster a collegial environment and cooperative interactions with coworkers, students, and others. The University is dedicated to promoting the Principles of Community .
This position is eligible for hybrid worksite. Work is performed partially remote and partially on employer premises or designated assignment location. An employee who is working remotely must reside within the United States in order to comply with all federal and state laws, filings, or tax requirements.
Should the candidate selected for this position work remotely, it will be subject to an approved telecommuting agreement, which is reviewed and approved annually. Candidate may, on occasion, be required to report on campus due to operational needs for meetings, training, or other activities. Remote work requires successful candidates to possess their own high speed internet and phone to perform the work on a university provided computer.
Visit this link for K-State’s guidance and policies on remote work and flexible work arrangements. Remote work agreements are required for all flexible work arrangements and are subject to review.
What You’ll Need to Succeed:Minimum Qualifications:
Requires a bachelor’s degree and five years of relevant experience.
Preferred Qualifications:
Master’s degree
Deep knowledge of SQL
Knowledge of databases, data mining, and/or data warehousing systems
Knowledge of database modeling techniques such as star schema, snowflake schema, 3NF, etc.
Ability to communicate effectively with users across campus, translate business requirements and carry out the full cycle of BI development
Excellent organization and project management skills with attention to detail
Experience with Snowflake
Experience with Power BI, Tableau, or other BI/Dashboard creation tools
Experience in higher education setting
Data retrieval and analytical skills
Experience with SAS, R, Python, or other data analysis tools
Other Requirements:
Applicants must be currently authorized to work in the United States at the time of employment.
How to Apply:Please submit the following documents:
Cover Letter
Resume
3 professional references with contact information
Screening of Applications Begins:
Immediately and continues until position is filled.
Anticipated Hiring Pay Range:
$65,000 to $72,000
Equal Employment Opportunity:
Kansas State University is an Equal Opportunity Employer. All applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, gender identity, age, national origin, disability or status as a protected veteran.
Background Screening Statement:
In connection with your application for employment, Kansas State University will procure a Background Screen on you as part of the process of considering your candidacy as an employee.
Advertised: Oct 10, 2022
Application Closes: Open until filled
Submit CV To All Data Science Job Consultants Across United States For Free