Department: IT AS Data Mgmt/Analytic Salary/Grade: ITS/78
Develops, codes, tests, and debugs new software or enhancements to existing software. Typically works with senior staff, but may coordinate smaller or less complex projects independently. Designs and implements basic technical solutions ensuring that business needs and requirements are met. Performs basic system integration tasks. Provides estimation for assigned tasks.
Creates ETL processes to load the enterprise data warehouse and other data structures used for reporting and analytics.
Participates in the development of new goals and strategies based on interactions with primary user.
Develops plans for software deployment on heterogeneous systems.
Collaborates with user to develop work flow and best practices.
Partners with user in designing features for technology.
Responds to customer inquiries via phone, online, in-person, etc.
Creates and maintains code documentation.
Evaluates feature/upgrade/change requests and recommends action.
Participates in interview process for new hires.
Identifies database and software performance issues, and makes adjustments.
Researches and develops new algorithms and statistical techniques designed for analyzing data based on customer needs.
Develops and maintains software infrastructure, via patches, bundles, releases and maintenance packs.
Codes software applications adhering to designs supporting internal business requirements or external user.
Completes tier 3 troubleshooting.
Designs databases and data structures.
Prioritizes tasks within project.
Meets with business analyst/stakeholder to determine requirements.
Opens tickets with vendors.
Code reviews of peer developers
Performs other duties as assigned.
Successful completion of a full 4-year course of study in an accredited college or university leading to a bachelor's or higher degree in a major such as computer science, information technology, or related; OR appropriate combination of education and experience.
2 years relevant experience
Please see requirements.
Infrastructure (extends across applications):
Amazon Web Services (AWS)
Code Repositories (Git, Subversion)
Microsoft Office (Word, Excel, Powerpoint, Access, Outlook)
Oracle and Oracle RAC
Service Orienteted Architecture (SOA)
Programming Languages and Frameworks:
Data warehouse design/develop
Database design/ data structure
Read & interpret technical drawings
Collaboration and teamwork
Iterative & incremental development
Workflow development & documentation
Minimum Competencies: (Skills, knowledge, and abilities.)
Deep knowledge of relational databases like Oracle, SQL, PL/SQL, version control with GitHub/subversion, ability to support continuous improvement by investigating alternatives and technologies
Strong understanding of Data Warehouse concepts
Knowledge of relational databases such as Oracle or MS SQL Server
Operating Systems, system architecture, networks
Able to collaborate, adapt and work collegially within a team environment.
Ability to work independently, assuming start-to-finish responsibility for application development and operations.
Strong ability to identify, assess and adapt new technology tools, frameworks and languages.
Ability to critically think and understand projects from business, customer and technical perspectives.
Experience building data warehousing and business intelligence solutions for higher education institutions
Experience with data integration tools such as IBM Datastage
Experience with job monitoring tools such as Autosys
Business Intelligence tools such as Cognos BI or Business Objects
Knowledge of Dev-Ops principles.
Experience in Data and Analytics cloud technologies (Oracle cloud, AWS, Microsoft, Google etc.)
Experience with Higher Education
Preferred Competencies: (Skills, knowledge, and abilities)
Service Oriented Architecture
The ability to be a self-starter and excellent organization.
Internal Number: 39690
About Northwestern University
Northwestern University is a major private research university with 12 academic divisions located on three campuses in Evanston, Chicago, and Education City in Doha, Qatar. We have approximately 2,500 full-time faculty members, 17,000 graduate and undergraduate students, and over 5,700 full and part-time staff. Northwestern University combines innovative teaching and pioneering research in a highly collaborative environment. It provides students and faculty exceptional opportunities for intellectual, personal and professional growth.