Jobs at Member Institutions & APLU

Position Announcement:

The Nebraska Statewide Workforce & Educational Reporting System (NSWERS) at the University of Nebraska is seeking applications from qualified individuals for the position of Assistant Director, Database/ ETL Development to lead the data architecture, modeling, and management initiatives for the NSWERS organization.

The Assistant Director will work closely with the Executive Director and NSWERS partnering organizations to define, implement, and manage of all data structures created to support the goals and objectives of the organization. This includes ensuring effective and secure data storage, implementation of business intelligence tools, and successful data integration with all partner organizations.

NSWERS Profile

The Nebraska P-20W data initiative, known as NSWERS, is a partnership of the Nebraska prekindergarten, elementary, secondary, and postsecondary educational systems to use data and information to further evidence-based policy and practices. The NSWERS partners also work in collaboration with Nebraska Department of Labor to examine the intersection of education and the workforce with the goal of providing research-based insight into meeting Nebraska’s current and future workforce needs.

Job Responsibilities: (In addition to periodic unique tasks, the following describes major responsibilities)

Database/ETL Development

• Develops conceptual, logical, and physical data models using relational and dimensional data modeling techniques.
• Performs Extract, Transform, and Load (ETL) procedures from source Excel, Flat file, Oracle, and other data structures to MS SQL Server using SSIS and other ETL services.
• Executes processes for data modelling, data warehousing, database programming, job scheduling, and creating ETL package dependencies.
• Designs and implement processes for data replication, clustering, and load balancing.
• Determines database structural requirements by analyzing operations, applications, and programming; reviewing objectives with clients; evaluating current systems.
• Develops database solutions by designing proposed systems, defining database physical structures and functional capabilities, security, back-up, and recovery specifications.
• Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions and related documentation.
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
• Provides database support by coding utilities, responding to user questions, and resolving problems.

Operations & Administration

• Analyzes complex business needs presented by the user community and/or clients and recommends technical solutions. Approving all business requirements prior to the technical implementation.
• Ensures the consistency and maintainability of data structures by creating, maintaining, and enforcing standards/procedures for implementing technical solutions.
• Directs operations in executing production tasks according to a documented schedule that meets or exceeds customer expectations.
• Produces detailed timeline for data structure release and implements effective project control by monitoring the progress of production release and reporting the status.
• Reviews all designs, code, and test plans where applicable.
• Participates on all hardware and software evaluations and maintains vendor contracts.
• Represents the database function at customer review meeting when appropriate.
• Perform liaison duties between users, operations, and programming personnel in the areas of systems design, modifications or trouble shooting.
• Directs implementation and execution of new/upgraded data systems via well-defined plans including procedures, deadlines, and accountability.
• Evaluates and implements data structure procedures and equipment for maximum efficiency and cost containment.
• Ensures users/customers are provided professional, courteous, and timely support and service.
• Develops and maintains technical documentation for data structures.
• Develops, selects, and conducts user training on an as-needed basis.

Leadership/ Professional Accountability

• Stays abreast of technology trends and regulations to ensure effectiveness and data compliance.
• Recommends and plans information technology to support and meet organization objectives using the latest industry-standard technology and practice.
• Performs other related duties as assigned by management.

MINIMUM QUALIFICATIONS:

Bachelor’s degree and eight (8) years of experience designing data architecture, leading and developing ETL/ELT processes, coordinating and analyzing business intelligence objectives, and assessing data extraction and reporting outcomes. Demonstrated competency with Microsoft SQL Server database is required. Excellent oral and written communication skills are essential.

An equivalent combination of education and experience from which comparable knowledge and abilities can be acquired may be considered.

PREFERRED QUALIFICATIONS:

Experience in the education industry; Familiarity with cloud-based database solutions and related security considerations; Experience with data visualization tools; Familiarity with data science principles and research methodology; High tolerance for ambiguity; Demonstrated fluency in one or more data-relevant programming languages/utilities (SQL, PL/SQL, Java, Python, Hadoop, C, C++, etc.) and one or more database management systems.

How to Apply:

This position works in Lincoln, NE.  Applications are processed through the online job posting at http://careers.nebraska.edu/postings/1293. Follow instructions to complete the Applicant Profile. Along with your application, attach a cover letter, resume, and contact information for three professional references. Direct questions about the position to: humanresources@nebraska.edu. Direct questions about the online application process to: (402) 472- 3701.

The University of Nebraska is an Affirmative Action/Equal Opportunity Employer and participates in E-Verify. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, disability, gender identity, sexual orientation or protected veteran status.