Northwestern University Evanston , IL 60201
Posted 3 weeks ago
Department: Innovation and New Ventures
Salary/Grade: EXS/8
Job Summary:
Provides expertise in data management, quality assurance, analysis and reporting. Establishes data accuracy and validity derived from a variety of systems. Performs data analysis using statistical techniques. Researches and analyzes information using multiple databases and creates reports of data and results. Assists in the preparation and delivery of decision support reports to both internal and external customers.
Under the direction of the Director Business Intelligence, the Business Data Analyst role is to ensure the quality and completeness of the intellectual property data across the various life cycles as they are managed in our IP Management system. This position will help identify data quality issues, investigate and research issues identified by others, suggest and implement solutions to correct problems, develop alert reports and monitor processes/programs, and help execute data quality initiatives. This includes implementing data quality improvements and initiatives to enhance data quality, performance levels, and the quality of analytics and reporting. This position analyzes and troubleshoots software problems and provides solutions to overcome those problems. This position will maintain various websites and recommend data-driven solutions to optimize traffic. The Business Data Analyst should have a strong customer focus and attention to detail to update and maintain the data on an ongoing basis. Build visualizations, interactive reports, and conduct analyses via Tableau and advanced Excel functions. This position must be able to think strategically, with a solid grasp of INVO's focuses and objectives, the implications of different solutions, and the identification of the optimal solution given the current software environments constraints.
Specific Responsibilities:
Strategic Planning
Administration
Develop standardized templates, policies, and procedures for internal and external reporting.
Designs and prepares documentation for qualitative and quantitative data analysis.
Discuss findings with senior management.
Development
Develop queries and quality metrics.
Interprets results using a variety of techniques, ranging from simple data aggregation to more complex statistical analysis.
Manages complex databases.
Performance
Completes data cleaning and organizes data files for analysis.
Reviews data and identifies quality issues.
Presents findings in an appropriate manner.
Miscellaneous
Performs other duties as assigned.
Minimum Qualifications:
Enterprise Applications
PeopleSoft Financials/SCM (NU Financials)
PeopleSoft HRMS (FASIS)
PeopleTools
Other: Tableau
Infrastructure (extends across applications)
Adobe Creative Cloud Suite
information security
Microsoft Lync
Microsoft Office (Word, Excel, Powerpoint, Access, Outlook)
SQL/MySQL/Postgres
Windows Operating System
Programming Languages and Frameworks
Java
JavaScript
Analytical
critical thinking
business intelligence application design
data mining
data modeling
data warehouse design/develop
database design/ data structure
Debugging
decision making
enterprise architecture
enterprise directory services
judgment
Troubleshooting
use-case analysis
Project
agile environment
Code documentation
collaboration and teamwork
evaluate resources
facilitate collaboration
functional documentation
iterative & incremental development
organizational skills
planning
Scrum project framework
Minimum Competencies: (Skills, knowledge, and abilities.)
Experience using query building tools
Experience with Tableau Desktop and Tableau Prep
Experience using MS Excel functions including the vLookup, IF and INDEX functions, Pivot Tables and Charts
Experience creating MS Word and Adobe PDF forms
Understanding of relational database concepts
Knowledge of web-based applications and media flash
Preferred Qualifications:
Background in data quality assurance
Project management experience
Preferred Competencies: (Skills, knowledge, and abilities)
Understanding of data visualization principles
Experience in writing or editing structured query language (SQL)
Experience with editing HTML and CSS.
MS Azure - OpenAI/GenAI tenant development.
Target hiring range for this position will be between $77,000 -$90,000 per year. Offered salary will be determined by the applicant's education, experience, knowledge, skills and abilities, as well as internal equity and alignment with market data
Benefits:
At Northwestern, we are proud to provide meaningful, competitive, high-quality health care plans, retirement benefits, tuition discounts and more! Visit us at https://www.northwestern.edu/hr/benefits/index.html to learn more.
Work-Life and Wellness:
Northwestern offers comprehensive programs and services to help you and your family navigate life's challenges and opportunities, and adopt and maintain healthy lifestyles.
We support flexible work arrangements where possible and programs to help you locate and pay for quality, affordable childcare and senior/adult care. Visit us at https://www.northwestern.edu/hr/benefits/work-life/index.html to learn more.
Professional Growth & Development:
Northwestern supports employee career development in all circumstances whether your workspace is on campus or at home. If you're interested in developing your professional potential or continuing your formal education, we offer a variety of tools and resources. Visit us at https://www.northwestern.edu/hr/learning/index.html to learn more.
Northwestern strongly recommends COVID-19 vaccinations and boosters for people who can obtain them as a critical tool for minimizing severe illness. More information can be found on the COVID-19 and Campus Updates webpage.
The Northwestern campus sits on the traditional homelands of the people of the Council of Three Fires, the Ojibwe, Potawatomi, and Odawa as well as the Menominee, Miami and Ho-Chunk nations. We acknowledge and honor the original people of the land upon which Northwestern University stands, and the Native people who remain on this land today.
Northwestern University is an Equal Opportunity, Affirmative Action Employer of all protected classes, including veterans and individuals with disabilities. Women, racial and ethnic minorities, individuals with disabilities, and veterans are encouraged to apply. Click for information on EEO is the Law.
#LI-EN1
Northwestern University