The Information Technology Department at NORC is seeking a Database developer for the Application Development team at our Chicago Loop location. This position is responsible for database programming, data file management, and editing tasks for NORC projects. Development and support of systems efforts to extract, transform, and load data to and from NORC custom systems and databases. Programmer I – Database is an entry to mid-level technical position, providing services to various NORC teams by supporting NORC systems and databases.
NORC's Information Technology program provides technology services to our staff and clients. Given the critical role technology plays in our day-to-day lives, we are committed to providing professional, high-quality solutions in order to further our collective goal of advancing social science research.
- Works in a team; receives assignments and moderate supervision from the IT project manager and/or senior database analyst. Will code, unit test, and document source code for NORC databases and systems.
- Under moderate supervision of senior team members perform database setup, execute survey data loads, complete routine maintenance and provide support for NORC databases and systems.
- Create and maintain stored procedures, SQL scripts, triggers and views per project requirements.
- Document changes made on projects as well as updating maintenance procedures carried out to reflect changing database environment.
- Help carry out tasks as requested to meet needs of project manager and the business analyst’s system specifications.
- Contribute to and maintain process improvements.
- Identifies trends and patterns in support requests that indicate a need for code revision.
- Perform other duties as assigned.
- Bachelor's Degree in Information Technology or related field.
- 0 to 2 years relevant experience including programming, testing, and database concepts.
- Strong communication skills. Ability to communicate verbally and in writing with both technical and non-technical staff.
- Strong analytical skills, knowledge of relational databases, SQL language, data manipulation, data analysis, and database design.
- Basic knowledge of relational database systems, design and programming.
- Basic knowledge of Microsoft SQLServer DTS/SSIS, database and development, report development, and systems support, SQLServer, SSIS, Postgres, Access Database and data modeling.
- Knowledge of formal unit and system testing processes, and source code control.
- Ability to balance his/her workload and in determining the means for accomplishing assignments, ability to work independently on some tasks, process-driven approach to work and an ability to work under time pressure and in a dynamic environment.
NICE TO HAVE:
- Basic knowledge of Java and J2EE technologies (JSP, Struts, Hibernate, Spring) a plus.
- A familiarity with customer service and technologies such as C#.Net, Python, Oracle, Windows OS, Eclipse, Git, open source projects.
- Understanding of large scale data collection, knowing buzzwords (CAWI,CATI, CAPI)
- Knowledge of Data Warehousing.
|WHAT WE DO:
NORC at the University of Chicago is an objective, non-partisan research institution that delivers reliable data and rigorous analysis to guide critical programmatic, business, and policy decisions. Since 1941, our teams have conducted groundbreaking studies, created and applied innovative methods and tools, and advanced principles of scientific integrity and collaboration. Today, government, corporate, and nonprofit clients around the world partner with us to transform increasingly complex information into useful knowledge.
|WHO WE ARE:
For over 75 years, NORC has evolved in many ways, moving the needle with research methods, technical applications and groundbreaking research findings. But our tradition of excellence, passion for innovation, and commitment to collegiality have remained constant components of who we are as a brand, and who each of us is as a member of the NORC team. With world-class benefits, a business casual environment, and an emphasis on continuous learning, NORC is a place where people join for the stellar research and analysis work for which we’re known, and stay for the relationships they form with their colleagues who take pride in the impact their work is making on a global scale.
NORC is an affirmative action, equal opportunity employer that values and actively seeks diversity in the workforce. NORC evaluates qualified applicants without regard to race, color, religion, sex, national origin, disability, veteran status, sexual orientation, gender identity, and other legally- protected characteristics.