Business Data Analyst

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.
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.
• Other duties as assigned.
Minimum Qualifications: (Education, experience, and any other certifications or clearances) • 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.
• Adobe Creative Cloud Suite • PeopleSoft Financials/SCM (NU Financials) • PeopleSoft HRMS (FASIS) • PeopleTools • Information Security • Microsoft Exchange • Microsoft Lync • Microsoft Office (Word, Excel, PowerPoint, Access, Outlook) • Java • JavaScript • SQL/MySQL/Postgres • Windows Operating System • Business intelligence application design • Data mining • Data modeling • Data warehouse design/develop • Database design/ data structure • Debugging • Enterprise architecture • Enterprise directory services • Use-case analysis • agile environment • Code documentation • Collaboration and teamwork • Evaluate resources • Facilitate collaboration • Functional documentation • Iterative & incremental development • Organizational skills • Scrum project framework Minimum Competencies: (Skills, knowledge, and abilities.
) • Experience using query building tools • 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: (Education and experience) • Background in data quality assurance • Project management experience Preferred Competencies: (Skills, knowledge, and abilities) • Experience with Tableau Desktop and Tableau Prep • 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.