Share this Job

Senior Business Intelligence Developer (14582)

Date: Jun 23, 2022

Location: Washington DC, DC, US, 20016

Company: American University

Get to Know American University

At American University we value open and honest inquiry, servant leadership, and the affirmation of the human dignity of all. We envision a thriving AU community where individuals of all identities and experiences are understood, appreciated, and fully included, and where equitable treatment, opportunities, and outcomes prevail. 


Our diverse community of students, faculty, and staff represent every state and more than 150 countries. Our internationally recognized faculty are today's thought leaders in the areas of public policy, law, the arts, communications, international development, and more. Our staff are innovative, service-oriented, and dedicated to moving the university towards achieving its strategic goals. We are committed to an excellent experience for all of our students, faculty and staff and share a passion for creating change through our knowledge and our work. 


Learn more about American University by clicking here.  


The Senior Business Intelligence Developer will be responsible for analyzing user analytical needs; developing system requirements; designing and implementing reporting and analytics solutions to meet requirements and support defined outcomes; and driving expansion of the AU Business Intelligence platform to university’s various business domains. She/he will collaborate with and receive technical guidance from the BI Solutions Architect, as well as with multiple customers/stakeholders as needed.


Essential Functions

  1. Work with business units to understand their reporting and analytical needs, analyze their requirements, develop technical approach and conduct feasibility assessment. Provide level of effort and duration estimates for the recommended reporting and analytics solutions.
  2. Develop information products (reports, documents, dashboards, etc.) and applications that meet defined outcomes. Work with BI and Data Architects to ensure that the most efficient BI solution is implemented. Develop business intelligence semantic layer. Work with extended technology team members to implement any necessary custom solutions. Ensure the integrity, reliability and data quality of the BI products.
  3. Ensure that the developed solution meets business user needs by coordinating user acceptance testing activities. Timely process user input and make technical adjustments, such as bug fixes or addressing enhancement requests. Analyze impact of the enhancement requests on the implementation timeline and either manage user expectations or escalate to the supervisor. Ensure adherence to enterprise standards and processes.
  4. Support AU’s data warehouse, technical architecture, and business intelligence solutions, as assigned, and as needed. Provide technical support and assistance to business intelligence users through training, presentations, documentation and one-on-one help.
  5. Facilitate and support data governance framework implementation at AU.

Position Type/Expected Hours of Work

  • Full time
  • Exempt
  • Team Leader/Consultant A
  • Availability after-hours to support staff as needed.

Salary Range

  • Commensurate with experience 

Required Education and Experience

  • Bachelor's degree or equivalent
  • 4-6 years of relevant experience

Preferred Education and Experience

  • Experience in dimensional data modeling is a plus.
  • Familiarity with SQL Server Integration Services (SSIS) is a plus.
  • Familiarity with best practices in data warehousing is a plus.
  • Familiarity with SQL Server Reporting Services (SSIS) is a plus.
  • Familiarity with Entrinsik’s Informer 5 reporting tool is a plus.
  • Familiarity with SDLC and iterative processes, as well as understanding and participation in change management procedures is a plus.
  • Experience with ERP solutions/ integrating data from ERP solutions is a plus.
  • Experience with Microsoft Dynamics CRM solutions/ integrating data from CRM solutions is a plus.
  • Understanding and experience with web technologies is a plus
  • Understanding and experience with Collibra’s Data Governance Center is a plus

Additional Eligibility Qualifications

  • Developing/ implementing data warehousing and business intelligence solutions and integrating applications in a relational database environment.
  • Knowledge of BI tools and experience implementing solutions with Microstrategy and Microsoft BI tools.
  • Strong experience with SQL.
  • Strong experience with MS Excel.
  • Proven ability to meet deadlines, ability to multi-task effectively and manage priorities across multiple staff and academic units.
  • Excellent communication, analytical skills, as well as the ability to work effectively with all levels of management, customers and vendors.
  • Demonstrated ability to interface with a wide variety of users to determine business requirements.
  • Demonstrated ability to translate business requirements into BI applications.
  • Desire & ability to learn and apply new skills/technologies quickly and efficiently.
  • Proactive, results-oriented and can-do attitude extremely desirable.
  • Demonstrated flexibility, with the ability to work with different business areas and new technologies as the team evolves and matures.


AU offers a competitive benefits package including a 200% matching retirement plan, tuition benefits for full-time staff and their families, several leadership development certificates, and has been recognized by the American Heart Association as a fit-friendly worksite. Click here to learn about American University's unique benefit options.


Current American University Employees

If you are a current employee at American University, please log into AsuccessfulU through the myAU portal. Once in AsuccessfulU, please select the Careers tile which will take you to our internal career page. 


Contact Us

For more information or assistance with the American University careers site, email


American University is an equal opportunity, affirmative action institution that operates in compliance with applicable laws and regulations. The university does not discriminate on the basis of race, color, national origin, religion, sex (including pregnancy), age, sexual orientation, disability, marital status, personal appearance, gender identity and expression, family responsibilities, political affiliation, source of income, veteran status, an individual’s genetic information or any other bases under federal or local laws (collectively "Protected Bases") in its programs and activities.

Nearest Major Market: Washington DC