Programmer I
Location
Chicago, IL, USA
Remote/
On-site
On-site
Hybrid
Department
Engineering
Type
Full Time
Salary
$62,000 - $83,000
Job Description
Posted on:
October 9, 2024
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 level technical position, providing services to various NORC teams by supporting NORC systems and databases. Qualified applicants must be eligible to work in the U.S. We regret that we are unable to offer visa sponsorship for this position.
Responsibilities
- Works in a team and 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.
Job Requirements
- 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 SQL Server DTS/SSIS, database and development, report development, and systems support, SQL Server, 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.
- Previous NORC experience in IT.
Nice To Have
- 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.
- Exposure to software development methodologies; Scrum/Agile, Waterfall, Kanban/Lean, XP
