Skip to main content

This job has expired

Data Modeler/ETL Developer

Employer
The University of Kansas
Location
Lawrence, KS

View more

Job Details

Position OverviewAnalytics, Institutional Research & Effectiveness (AIRE) at the University of Kansas brings analytical and technical staff together to rapidly make progress in Data Warehousing, Business Intelligence, Official Reporting & Institutional Effectiveness. AIRE is charged with modeling university’s data and supporting BI toolsets that empower campus users to make data-driven decisions in a self-service fashion.

Data Modeler/ETL Developer will work in the Data Management team to extract data from source systems, transform data as necessary, and ultimately load data into the university’s Data Warehouse. These extracts must be modeled into dimension and fact tables (i.e. STAR Schema) that ultimately support end user requirements. The developer will work closely with other teams of BI Analysts in identifying requirements and ensuring quality of data. The developer will also monitor daily jobs to ensure they were successful and troubleshoot any issues that arise from jobs failing, loading data incorrectly, etc.

KU is a Research 1 institution, the flagship of the Kansas system, and a member of the Association of American Universities (AAU). It is located in Lawrence, a thriving and progressive community, which lies close to Kansas City. The successful candidate must have appropriate authorization to work in the U.S. before employment begins and no employment sponsorship will be provided. Job DescriptionDevelopment (60%)
  • Develop and maintain ETL processes and/or SQL queries from various source systems.
  • Assist the Data Architect with developing a Dimensional Fact Model (i.e. STAR Schema).
  • Work on the design and implementation of data integrations.
  • Work on web services to extract data from various source systems.
  • Work with BI analysts, functional users, and data scientists to develop and further enhance data models.
  • Participate in an Agile environment and complete assigned sprint tasks.
  • Adhere to basic development principles (e.g. change control, separation of duties, etc.)
  • Provide feedback from a technical perspective on requirements documents. Additionally, create technical design document with data flows, process models, etc. to help document the technical approach to meeting end user needs.
Application/Integration Support (20%)
  • Support a complex Data Integration environment.
  • Assist with ETL Application Tool/Server system and database upgrades/maintenance.
  • Work with the Network Operations Center (NOC) to ensure extract jobs are monitored.
  • Troubleshoot issues as they arise (e.g. failed jobs, data errors, etc.).
  • Assist with Modeling and BI Tool/Server upgrades.
Testing and Validation (15%)
  • Determining data sourcing strategies and data validation approaches.
  • Defining test conditions and test scripts to ensure system stability and validity.
Other projects as assigned (5%)
Position Requirements
  1. This position works remotely from home.
Required Qualifications
    Bachelor’s degree and 3 years of relevant professional experience.Advanced SQL skills, as evidenced by application materials. Minimum 1 year of experience with data modeling or BI practices.
Preferred Qualifications
    BI and/or data warehousing experience.Experience working with databases.Experience working with web services.Prior work experience that required exceptional time management skills and adapting quickly to shifting priorities.Experience working at an institution of high learning.Prior work experience working in an agile team environment.Demonstrable troubleshooting skills.Experience fine tuning the performance of long running queries.
Additional Candidate InstructionsIn addition to the online application, the following documents are required to be considered for this position:
  • A cover letter (addressing how required are met)
  • Resume or curriculum vitae.
  • Contact information for three professional references.
  • Incomplete applications will not be considered.

    Application review begins Monday, November 29, 2021 and continues until a pool of qualified applicants is identified.
    Contact Information to ApplicantsPrasanna Tadimeti , prasanna @ku.edu Advertised Salary Range$70,000 - $75,000 Work ScheduleMonday - Friday, 8am - 5pm Application Review Begins29-Nov-2021 Anticipated Start Date10-Jan-2022

    Organization

    Working at the University of Kansas 

    Join the University of Kansas, and you’ll become part of a Jayhawk family that spans the globe. Wear your KU shirt in London, Istanbul, Buenos Aires, Nairobi or anywhere else, and you will likely hear a resounding “Rock Chalk!” from a stranger. Of course, the appropriate response is an enthusiastic “Jayhawk!” Because, after all, they’re not really strangers, they’re family.

    The Jayhawk community is united by more than 150 years of tradition and by our commitment to pushing the boundaries of knowledge, transforming the academic experience, and creating solutions through innovative research. KU’s mission is to lift students and society by educating leaders, building healthy communities and making discoveries that change the world.  

    The University of Kansas is the state’s flagship university and one of just 66 invited members of the prestigious Association of American Universities (AAU). We consistently earn high rankings for academics and recognition as a premier research university.

    KU faculty and staff embrace our role as the state’s flagship university, AAU member and R1 institution that serves the state, nation and world. We celebrate the energy and compassion that infuse the Jayhawk spirit; and, we remain true to KU’s historic values: the elevating force of education, the transformative power of research and the healing power of service.

    Diversity, Equity, Inclusion, and Belonging 

    The University of Kansas is committed to a learning and workplace environment that is representative of our nation and global society, accepts and values everyone, appreciates our common humanity and understands that our multiple differences are the cornerstone of academic preparation, professional excellence and distinction. KU must be a place where all people feel they belong and have access to resources and support that help them attain their educational and professional goals.

    We recognize there are inequalities and privileges generated by historical and persistent intersecting differences by race, ethnicity, gender identities, gender expressions, sexual orientation, socio-economic status, age, abilities, religion, regional background, veteran status, citizenship status and nationality. And we hold ourselves accountable for policies, processes and programs that appreciate these and other differences and create more fair, safe and just learning, working and living environments for KU students, faculty and staff.

    Instruction 

    KU offers a broad array of undergraduate and graduate study programs, and we fulfill our mission through academic and research programs of international distinction, coupled with outstanding libraries, teaching museums and information technology. These resources enrich the academic experience for students from all 50 states and 112 countries, and provide enrichment resources for KU faculty and staff.

    Research 

    The university attains high levels of research productivity and recognizes that faculty are part of a network of scholars and academicians that shape a discipline as well as teach it. KU staff are integral to our research success, participating in and supporting discoveries that expand knowledge and improve lives.

    Service 

    The university and our employees serve society through research, teaching and the preservation and dissemination of knowledge. KU's academic programs, arts facilities and public programs provide cultural enrichment opportunities for the larger community. And, KU offers educational, research and service programs throughout the state. KU employees are encouraged to participate in and serve the campus and surrounding communities in a way that is meaningful to them.

    International Dimension 

    KU offers more than 100 programs of international study and cooperative research for KU students and faculty at sites around the world. The university offers teaching and research that draw upon and contribute to the most advanced developments throughout the United States and abroad. At the same time, KU's extensive international ties support economic development in Kansas.

    Values 

    The University of Kansas, our students and employees are committed to excellence. We foster a multicultural, inclusive environment in which the dignity and rights of individuals are respected. Intellectual diversity, integrity and disciplined inquiry in the search for knowledge are of paramount importance.

    Our City and State 

    KU sits atop Mt. Oread in the center of Lawrence, a town full of natural beauty and culture. In fact, Rolling Stone magazine named Lawrence one of the best college towns in the United States. Lawrence is home to more than 100,000 people, and has a charming, Midwestern friendliness that welcomes visitors and celebrates diversity. In addition to KU, Lawrence is home to Haskell Indian Nations University, the premiere tribal university in the United States.

    Lawrence’s historic and thriving downtown features restaurants, nightlife and local shops offering unique finds that you won’t find anywhere else. The town has more than 50 parks, an encompassing mixed-use trail, and quick access to biking/hiking trails along the Kansas River and around Clinton Lake. A five-minute drive from Lawrence, Clinton Lake offers fishing, boating, beaches, camping and other outdoor activities.

    Located just 40 minutes west of Kansas City, Lawrence offers the appeal of a mid-size, suburban town with quick access to the amenities of a large city, including an international airport. The Kansas City metro area is home to world-class museums and cultural activities, Jazz clubs and other nightlife venues, expansive shopping options, and exciting professional sports with the Kansas City Chiefs, Kansas City Royals and Sporting KC.

    Kansas is in the center of the country, making it convenient and cost effective to fly or drive to destinations throughout the United States. Far from flat, the Flint Hills, just 90 minutes from Lawrence, offer panoramic vistas that showcase the breathtaking beauty of America.

    Making KU Your Home 

    Something about Lawrence is magnetic. Long-time residents are never surprised when a KU student or employee from out of state decides to make Lawrence their permanent home. And, even those who do leave often find themselves returning to “the nest” at some point in the future. In fact, Lawrence has been named by several publications as one of the best places to retire.

    At the University of Kansas, you’ll join a global Jayhawk family and find a place to call home.

    Get job alerts

    Create a job alert and receive personalized job recommendations straight to your inbox.

    Create alert