BUSINESS SYSTEMS ANALYST

Duke University:

Duke University was created in 1924 through an indenture of trust by James Buchanan Duke. Today, Duke is regarded as one of America’s leading research universities. Located in Durham, North Carolina, Duke is positioned in the heart of the Research Triangle, which is ranked annually as one of the best places in the country to work and live. Duke has more than 15,000 students who study and conduct research in its 10 undergraduate, graduate and professional schools. With about 40,000 employees, Duke is the third largest private employer in North Carolina, and it now has international programs in more than 150 countries.

POSITION DESCRIPTION

The intent of this job description is to provide a representative and level of the types of duties and responsibilities that will be required of positions given this title and shall not be construed as a declaration of the total of the specific duties and responsibilities of any particular position. Employees may be directed to perform job-related tasks other than those specifically presented in this description.

Minimum Education Required:

Bachelor’s Degree in Computer Information Systems, Computer Science, Data Analytics, Business Administration, Economics, Statistics, or a related field.

Experience:

Required:

• Work requires two years’ experience in report writing and data analytics.
• Hands-on experience with various Business Intelligence technologies.
• Experience working with large data warehouses and data marts.
• Experience required in data analysis and report development in a language such as SQL or similar experience in a leading,
• recognized analytics toolset, such as Cognos, Tableau, Microsoft BI, Hyperion.
• Strong project management skills.
• Experience translating end-user requirements into effective reporting solutions.
• Understanding of data analytics methodology.

Preferred:

• Experience working with various relational database design concepts including relational and dimensional.
• Experience in a Higher Education environment working with PeopleSoft Campus Solutions data.
• Experience eliciting end-user requirements.
• Experience establishing and maintaining partnerships with internal and external (college, department) customers to understand
• and prioritize their Business Intelligence needs, keeping our capabilities and constraints in mind.

Knowledge, Skills, Abilities:

• Knowledge of Data Modeling and Data Architecture.
• Basic understanding of row-level security in systems such as PeopleSoft and/or Tableau.
• Analytical and problem-solving skills.
• Excellent oral and written communication skills.
• Ability to work in a collaborative team environment developing creative data-drive solutions.
• Ability to effectively document, review, and revise business and data processes (independently and collaboratively).
• Ability to implement processes that ensure data quality and consistency.
• Ability to identify and analyze data integrity issues with an aim toward continuous improvement.

Position Summary:

The staff of the Office of the University Registrar work as a unit to support the academic mission of the University. The incumbent in this position is an integral OUR team member and works to provide data to select members of the Duke community in support of administrative, research and/or educational activities.  The Business Intelligence Analyst will have detailed knowledge and understanding of business intelligence functions including but not limited to analytics, data mining, data warehouse, reporting and visualization dashboards. This analyst will assist senior report writers to utilize a consistent architecture and deliver on business demands. The analyst will also support the enforcing of academic structure, BI, and data governance best practices within the academic community.

Responsibilities Include (but are not limited to):

Business Intelligence and Reporting (40%)

• Use the BI infrastructure, source data, and toolsets to analyze, design, develop, test, and deliver prepared reports, queries, dashboards, or other appropriate medium meeting business requirements.
• Assist with various data processing activities.
• Assist with responses to ad-hoc data requests, using PeopleSoft query and other statistical software as needed, for information from campus constituencies by producing specialized reports, files, and other data as needed.
• Remain current with industry trends within the business intelligence continuum.

Data Integration (35%)

• Assist with the creation of extracts, webservices, and APIs available for upload into appropriate databases and applications in accurate and timely manner.
• Uphold quality standards to ensure data quality and integrity across various databases and applications.
• Work with analysts and business users to translate functional specifications into technical designs for implementation and deployment.
• Ensure high quality and optimum performance of data integration systems in order to meet business objectives.

Data Integrity (20%)

• Adhere to data integrity strategy and best practices, both institution- and industry-wide.
• Participate in operational meetings and support appropriate reporting solutions.
• Perform functional testing, as advised, to ensure the completeness and accuracy of data.

Miscellaneous Duties (5%)

• Assist in PeopleSoft upgrade and performance testing.
• Assist in Tableau server testing.
• Edit current procedure documents that reflect tasks performed and data processing operations.
• Other duties as assigned.

Work requires a Bachelor's degree.

3 years combined business/work analyst, software QA, or user OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR EXPERIENCE. support/training experience,

Duke is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or veteran status.

Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.

Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essentialjob functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.