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

• Partners with clients to define requirements based on business objectives.

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:

• Successful completion of a full 4-year course of study in an accredited college or university leading to a bachelor's or higher degree; OR appropriate combination of education and experience.
• 2 years data analysis/report writing or similar experience required.

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 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 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 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 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