Homeoffice Principal Data Warehouse Engineer bei University of Colorado System Administration

%3Cp%3E%3Cstrong%3EJoin Our Team and Make a Difference in Higher Education!%3C/strong%3E%3C/p%3E%3Cp%3EAt the System Administration office at the University of Colorado, we are dedicated to building a workplace where everyone feels valued, supported, and empowered to thrive. Our office is committed to fostering a culture where employees find community, a sense of belonging, and the opportunity to contribute meaningfully to our mission and purpose. %26nbsp;%3C/p%3E%3Cp%3EBy joining our team, you’ll have a direct impact on shaping the future of higher education. In addition to the Office of the Board of Regents, the University of Colorado’s system administration includes 19 units that provide essential services to CU’s campuses in Aurora, Boulder, Colorado Springs, and Denver, as well as the Office of the President. While not a part of any one campus, we are proud to serve in the centralized office for the University system. Together, we ensure CU continues to deliver outstanding education, groundbreaking research, and valuable service to our communities.%3C/p%3E%3Cp%3EWe believe in creating an environment where the unique experiences and perspectives of everyone are embraced, enriching the work we do and the strategic outcomes we pursue. If you’re passionate about making a difference, contributing to a dynamic team, and supporting a mission that matters, we encourage you to apply and be part of our journey.%26nbsp; %3Ca href=%22https://www.cu.edu/cu-careers/cu-system%22 target=%22_blank%22 rel=%22noopener noreferrer%22%3ELearn more about CU System Administration%3C/a%3E.%3C/p%3E%3Ctable class=%22MsoNormalTable%22 style=%22border-collapse:collapse;height:1789.9px;%22 border=%220%22 width=%22944px%22 cellspacing=%220%22 cellpadding=%220%22%3E%3Ctbody%3E%3Ctr style=%22height:48.3949px;%22%3E%3Ctd style=%22height:48.3949px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EPosition Summary:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:48.3949px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3E%3Cp%3EUniversity Information Services (UIS) provides technical services and enterprise applications to the University of Colorado campuses and the Office of the President. UIS is committed to excellence in customer service and technical expertise. Through the development of enterprise applications, UIS supports the University as a whole with systems used by students, faculty, human resources employees, finance employees, and others.%3C/p%3E%3Cp%3EThe Principal Data Warehouse Engineer will support the university’s quickly growing needs and demands to make data driven decisions, using an enterprise data warehouse, data integrations, analytics, and business intelligence initiatives. This role will be a key member of the university’s ETL team and will serve as a Data Warehouse domain expert applying standard processes in the industry. This role requires collaboration with leaders, developers and analysts from the Procurement Services Center, Campus Solutions, Finance, Human Resources, Advancement and Grants and Research departments from all four campuses and UIS departments such as database administrators, system admins, middleware, infrastructure, production services, enterprise data architects, developers, and quality assurance testers.%26nbsp;%3C/p%3E%3Cp%3E%26nbsp;This position reports to the Assistant Director of Data and Business Intelligence and is exempt from the State of Colorado Classified Staff system.%3C/p%3E%3C/td%3E%3C/tr%3E%3Ctr style=%22height:158.963px;%22%3E%3Ctd style=%22height:158.963px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EWhere You Will Work:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:158.963px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3E%3Cp%3E%3Cstrong%3EApplicants must be Colorado residents or able to relocate to Colorado within a month of starting employment with University of Colorado System Administration.%3C/strong%3E%3C/p%3E%3Cp%3ERemote – this role is eligible to work remotely within Colorado.%3C/p%3E%3Cp%3E%3Cstrong%3EPlease note, leadership may adjust in-office work requirements with a minimum of three months%27 notice before any change can be implemented.%3C/strong%3E%3C/p%3E%3C/td%3E%3C/tr%3E%3Ctr style=%22height:88.3807px;%22%3E%3Ctd style=%22height:88.3807px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EEqual Opportunity Statement:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:88.3807px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3ECU is an Equal Opportunity Employer and complies with all applicable federal, state, and local laws governing nondiscrimination in employment. We are committed to creating a workplace where all individuals are treated with respect and dignity, and we encourage individuals from all backgrounds to apply, including protected veterans and individuals with disabilities.%26nbsp;%3C/td%3E%3C/tr%3E%3Ctr style=%22height:73.4375px;%22%3E%3Ctd style=%22height:73.4375px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EDuties %26amp; Responsibilities:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:73.4375px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3E%3Cp%3EDuties and responsibilities of the position include, but are not limited to:%3C/p%3E%3Cul%3E%3Cli%3EConduct data engineering, including requirement gathering, Extract, Transform and Load (ETL) development, system testing, deployments, documentation, and production support with data sources such as CU’s PeopleSoft Student, HCM, Finance, InfoEd, and Advancement systems%26nbsp;%3C/li%3E%3Cli%3EConduct data and BI business/data analyst efforts collaborating with key partners to gathering requirements and assist with User Acceptance Testing (UAT)%3C/li%3E%3Cli%3EDesign supportable solutions to satisfy customer needs and support CU’s long-term business goals via new data warehouse data marts and enhancements to existing data marts and reports%3C/li%3E%3Cli%3EConduct detailed data profiling and data analysis for data modeling and design%26nbsp;%3C/li%3E%3Cli%3ECreate conceptual, logical, and physical data models for simple to medium complexity work efforts%3C/li%3E%3Cli%3ECreate and maintain source to target mappings across multiple domains at the University%3C/li%3E%3Cli%3EUse development tools including IBM DataStage, SAS, shell scripting and Perl. Acts as a domain expert in ETL Development and Solutions Architecture%26nbsp;%3C/li%3E%3Cli%3EPartner with management to allocate responsibilities among ETL developers%26nbsp;%3C/li%3E%3Cli%3EProvide support and guidance to ETL developers, as required for all Software Development Life Cycles (SDLC) phases%3C/li%3E%3Cli%3EPlan and/or conduct system integration test cases (SIT) to ensure solutions are successful throughout the entire system%3C/li%3E%3Cli%3EDeploy code and objects through SDLC environments including Development, QA, and Production along with partnering with production services to ensure the correct job scheduling is in place%3C/li%3E%3Cli%3EInvestigate data, processes, logic, or scheduling issues to identify the root cause, mitigation plans, and resolution plans%3C/li%3E%3Cli%3EParticipate in technology projects and initiatives as a technical lead working with the project manager to identify the technical solutions and track project plans, estimates, cut over plans, resources, and communications. For smaller efforts without a project manager, this position will lead the effort assigning tasks to owners with timeframes identified along with the communication and follow-up required to ensure the work is completed successfully on time.%3C/li%3E%3Cli%3ELead, advise, and mentor team members on data and BI concepts and standard methodologies%3C/li%3E%3Cli%3EProvide recommendations on data strategies, platforms, and application infrastructure required to implement solutions%3C/li%3E%3Cli%3EAssist with design and leading a multi-year data warehouse roadmap, balancing short- and long-term goals and investments to scale and deliver our solutions globally and fulfill the organization%27s high-level reporting %26amp; analytics needs%3C/li%3E%3Cli%3EParticipate in and lead team meetings, peer design and code reviews%3C/li%3E%3Cli%3EETL DataStage administration including tool and Linux structure configuration, setup and monitoring of the health of the environment.%26nbsp;%3C/li%3E%3Cli%3EPartner with BI team to communicate data warehouse enhancements, suggest architecture modifications to Cognos Framework Manager%3C/li%3E%3Cli%3E%3Cp%3EContinue education and professional development including attending trainings and conferences and self-directed learning%26nbsp;%3C/p%3E%3Cp%3E%26nbsp;%3C/p%3E%3C/li%3E%3C/ul%3E%3C/td%3E%3C/tr%3E%3Ctr style=%22height:519.886px;%22%3E%3Ctd style=%22height:519.886px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EWhat We Offer:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:519.886px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3E%3Cp%3E%3Cstrong%3ESalary:%3C/strong%3E The anticipated hiring salary has been established at %3Cstrong%3E%24107,800-%24110,000%3C/strong%3E.%3C/p%3E%3Cp%3ECU System Administration takes into consideration a combination of the selected candidate’s education, training and experience as it relates to the position, as well as the position’s scope and complexity, internal pay equity and external market value when determining a salary level for potential new employees.%3C/p%3E%3Cp%3E%3Cstrong%3EBenefits:%3C/strong%3E With our unparalleled range of benefits, including top-notch healthcare, comprehensive wellness programs, enriching professional development, and a dynamic work-life balance, we ensure your holistic growth and happiness.%3C/p%3E%3Cul%3E%3Cli%3ENo-cost or low-cost medical %26amp; dental plan options, some inclusive of IVF assistance.%3C/li%3E%3Cli%3EDisability, Life, Vision Insurance options.%3C/li%3E%3Cli%3EMultiple retirement planning options including a mandatory 401(a) plan where CU contributes 10% of your gross pay, a 401k or 403b plan and a 457 deferred compensation plan.%3C/li%3E%3Cli%3EPre-tax savings plans, such as Health care and Dependent care flexible spending accounts.%3C/li%3E%3Cli%3EEmbrace a healthy work-life balance with ample sick and vacation leave, along with at least 12 paid holidays. This includes a dedicated week off for winter break.%3C/li%3E%3Cli%3E6 weeks of parental leave to adjust to the joys of parenthood.%3C/li%3E%3Cli%3EA tuition benefit program for you and/or your dependents.%3C/li%3E%3Cli%3EFree RTD EcoPass and Free Onsite Parking at our 1800 Grant Street Office.%3C/li%3E%3Cli%3EMany additional perks %26amp; programs with the %3Ca href=%22https://advantage.cu.edu/%22 target=%22_blank%22 rel=%22noopener noreferrer%22%3ECU Advantage%3C/a%3E.%3C/li%3E%3C/ul%3E%3Cp%3EAdditional taxable fringe benefits may be available.%26nbsp;%3C/p%3E%3Cp%3EFor more information on benefits programs, please review our %3Ca href=%22https://www.cu.edu/node/183087%22 target=%22_blank%22 rel=%22noopener noreferrer%22%3EComprehensive Benefits Guide%3C/a%3E.%26nbsp;%3C/p%3E%3Cp%3EAccess our %3Ca href=%22https://www.cu.edu/node/153125%22 target=%22_blank%22 rel=%22noopener noreferrer%22%3ETotal Compensation Calculator%3C/a%3E to see what your total rewards could be at CU. %26nbsp;(This position is a University Staff position)%3C/p%3E%3C/td%3E%3C/tr%3E%3Ctr style=%22height:284.886px;%22%3E%3Ctd style=%22height:284.886px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EQualifications:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:284.886px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3E%3Cp%3E%3Cstrong%3EMinimum Qualifications:%3C/strong%3E%3C/p%3E%3Cp%3E%3Cstrong%3EPlease ensure your resume includes any and all relevant experience to be accurately assessed against these qualifications.%26nbsp; You must meet all minimum requirements listed at the time of application to be considered for this role.%3C/strong%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22pf0%22%3EBachelor’s degree from an accredited institution of higher education, or equivalent professional experience (professional experience may be substituted for the educational requirement on a year-for-year basis)%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EFour (4) years of experience to include any of the following:%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22pf0%22%3EIBM DataStage or equivalent%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EData modeling or database design or Data Warehouse/Mart design or data architecture%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EKimball methodologies including star schema design, and accumulating and periodic snapshots%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3ESQL, including familiarly with Oracle analytic functions and techniques for tuning large-volume queries%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EAdministration of an ETL or middleware tool (DataStage, ODI, Informatica, OSB, etc.)%3C/p%3E%3C/li%3E%3C/ul%3E%3C/li%3E%3C/ul%3E%3Cp%3E%3Cstrong%3EPreferred Qualifications:%3C/strong%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22pf0%22%3EBachelor’s or post-baccalaureate degree from an accredited institution of higher education in computer science, computer engineering, information systems, information technology, or related field of study%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3ESix (6) years’ equivalent experience to include any of the following:%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22pf0%22%3EIBM DataStage or equivalent%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EKimball methodologies including star schema design, and accumulating and periodic snapshots%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3ESQL, including familiarly with Oracle analytic functions and techniques for tuning large-volume queries%3C/p%3E%3C/li%3E%3C/ul%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EExperience in one or more of the following:%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22pf0%22%3ECommitment SDLC standard processes as they relate to data warehousing%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EExperience working in a Linux environment and with shell scripting (Perl/Korn)%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3ETechnical Lead experience managing a development team responsible for the design, development and implementation of highly sophisticated programs, scripts, data objects resulting in high quality and performance%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EWorking in a University or Higher Education setting%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EJava and PL/SQL programming%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EPeopleSoft data models including Campus Solutions, Finance, and/or HCM version 9.0 or higher%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22pf0%22%3EOne or more projects to implement an ETL or information management tool%3C/p%3E%3C/li%3E%3C/ul%3E%3C/li%3E%3C/ul%3E%3Cp style=%22font-family:Arial;%22%3E%3Cstrong%3EKnowledge, Skills, and Abilities:%3C/strong%3E%3C/p%3E%3Cp%3ETo be successful in this position, employees will need to know the following:%3C/p%3E%3Cul%3E%3Cli%3EKnowledge of ETL Architecture, ETL Tools, Kimball Methodology, and SQL%3C/li%3E%3Cli%3EAbility to use Oracle analytic functions and techniques%3C/li%3E%3Cli%3EAbility to use and understand standard processes regarding data warehousing %26amp; BI SDLC %26nbsp;%3C/li%3E%3Cli%3EAbility to work in a Linux environment with shell scripting%3C/li%3E%3Cli%3EAbility to document, manage, and test multiple projects at once%3C/li%3E%3Cli%3EAbility to manage and develop team skills%3C/li%3E%3Cli%3ECollaboration skills to work with others from different areas and backgrounds to reach a common goal%26nbsp;%3C/li%3E%3Cli%3EDigital literacy to use Microsoft Office programs (i.e., Word, Excel, Outlook, etc.) and learn and experiment with new software and systems%3C/li%3E%3Cli%3EInterpersonal skills to facilitate interaction, communication, and teamwork between others%3C/li%3E%3Cli%3EOral, written, and listening communication skills to accurately interpret what others are saying and convey messages, information, concepts, and details accurately and clearly%3C/li%3E%3Cli%3EOrganizational skills to set and meet goals, manage appointments, create schedules, coordinate and facilitate meetings, and make decisions%26nbsp;%3C/li%3E%3Cli%3EAbility to work under stress, handle multiple concurrent and contending tasks and responsibilities, and adapt to changing priorities while maintaining personal effectiveness%3C/li%3E%3Cli%3EAbility to prioritize work, meet goals, and stay on task when completing special projects and daily assignments%3C/li%3E%3Cli%3EAbility to work independently with minimal direction and reliable professional judgment, as well as collaboratively with a team to achieve desired results%3C/li%3E%3Cli%3EAbility to maintain a good work ethic, positive problem-solving demeanor, and passion for the work performed%3C/li%3E%3Cli%3EAbility to self-start and take initiative in completing daily tasks and special projects%3C/li%3E%3Cli%3EAbility to focus on activities that have the greatest impact on meeting work commitments%3C/li%3E%3Cli%3EAbility to establish and maintain partnerships with a variety of internal and external constituencies%3C/li%3E%3Cli%3EAbility to communicate and work effectively with individuals from a diverse set of backgrounds, cultures, and ages%3C/li%3E%3C/ul%3E%3Cp class=%22MsoNormal%22 style=%22border-style:none;line-height:normal;margin:0in 0in 0in .5in;mso-border-shadow:yes;mso-padding-alt:31.0pt 31.0pt 31.0pt 31.0pt;%22%3E%3Cspan style=%22color:black;%22%3E%3Cstrong style=%22mso-bidi-font-weight:normal;%22%3E%26nbsp;%3C/strong%3E%3C/span%3E%3C/p%3E%3C/td%3E%3C/tr%3E%3Ctr style=%22height:231.349px;%22%3E%3Ctd style=%22height:231.349px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EHow to Apply:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:231.349px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3E%3Cp%3EFor full consideration, please attach the following as separate documents to your application:%3C/p%3E%3Col%3E%3Cli style=%22font-family:Arial;%22%3EA cover letter identifying the job specific minimum qualifications you possess%3C/li%3E%3Cli style=%22font-family:Arial;%22%3EA resume including any and all relevant experience to be accurately assessed against the qualifications listed in the posting.%3C/li%3E%3C/ol%3E%3Cp%3EPlease ensure you check the “Job Specific Attachments” box next to each document on the “Required Documents” page of the application for the appropriate documents to be attached.%3C/p%3E%3Cp%3EPer the Colorado Job Application Fairness Act, you are not required to provide your date of birth, dates of school attendance, or dates of graduation on your resume or cover letter. If an application requires additional materials, such as a transcript or certification, you may redact identifying information relating to your date or birth, dates of school attendance, or dates of graduation.%3C/p%3E%3C/td%3E%3C/tr%3E%3Ctr style=%22height:109.162px;%22%3E%3Ctd style=%22height:109.162px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EWhen to Apply:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:109.162px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3EFor full consideration completed applications must be submitted by%26nbsp;%3Cstrong%3ENovember 11th%3C/strong%3E.%26nbsp; Reference checking is a standard step in our hiring process. You may be asked to provide contact information, including email addresses, for up to five references as part of the search process for this position. *Please note: All application materials must be submitted through CU Careers; emailed materials will not be considered.*%3C/td%3E%3C/tr%3E%3Ctr style=%22height:48.3949px;%22%3E%3Ctd style=%22height:48.3949px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3ESponsorship Statement:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:48.3949px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3EWe are unable to sponsor applicants for work visas for this position.%3C/td%3E%3C/tr%3E%3Ctr style=%22height:129.972px;%22%3E%3Ctd style=%22height:129.972px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EBackground Check Statement:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:129.972px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3EThe University of Colorado is committed to providing a safe and productive learning and living community. To achieve that goal, we conduct background investigations for all final applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial history, motor vehicle history and/or fingerprinting background check. The Immigration Reform and Control Act requires that a verification of employment eligibility be documented for all new employees by the end of the third day of work. The University of Colorado is committed to diversity and equality in education and employment.%3C/td%3E%3C/tr%3E%3Ctr style=%22height:97.0739px;%22%3E%3Ctd style=%22height:97.0739px;padding:0in;vertical-align:top;width:166.491px;%22 width=%22157%22%3E%3Cspan style=%22font-size:14px;%22%3E%3Cstrong%3EADA Statement:%3C/strong%3E%3C/span%3E%3C/td%3E%3Ctd style=%22height:97.0739px;padding:0in 0in 0in 0.1in;vertical-align:top;width:767.912px;%22 width=%22557%22%3EWe are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting.%26nbsp; Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: %3Ca href=%22mailto:[email protected]%22%[email protected]%3C/a%3E.%3C/td%3E%3C/tr%3E%3C/tbody%3E%3C/table%3E%3Cp class=%22MsoNormal%22 style=%22line-height:normal;margin-top:14.0pt;%22%3E%26nbsp;%3C/p%3E Jetzt bewerben