The Business Intelligence Architect is responsible for providing BI solutions as well as experience with data modeling, data mart and data warehouse architecture. This individual will have an immediate impact on enhancing operational and strategic data informed decision-making for the University. Through this role, this position would have the opportunity to provide insights that impact policy, practice and outcomes at Elon University working in a team environment to design, develop, and deliver enterprise business intelligence and analytic solutions. Ideal candidates will have excellent technical and interpersonal skills as well as a strong commitment to supporting our values that include team focus, creative problem solving, and technical curiosity. This individual will have the opportunity to grow technically and professionally while working on an energetic and collaborative team. Elon University offers an engaging work environment at a premier higher education institution. Exceptional benefits package and many other support resources to help employees balance their professional and personal lives are also available.
Bachelor's degree in the field of computer science, information systems, or computer engineering. Master’s preferred.
Special Skills Or Experience:
Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
Demonstrated experience with enterprise scale databases and environments such as MS SQL Server, Cloud DBs or Oracle.
Experience with BI technologies, such as SSAS, MS Power BI, Tableau and other BI applications.
Demonstrated ability with SSIS or other related ETL tools.
Strong ability to analyze user requirements and build front-end BI applications according to specifications.
Strong understanding of relational database structures, theories, principles, and practices.
Experience with BI development best practices such as agile methodologies, source code control, prototyping, and testing.
Experience with troubleshooting enterprise BI systems and processes.
Good knowledge of applicable data privacy practices and laws.
Strong written and oral communication skills.
Strong presentation and interpersonal skills.
Exceptional analytical, conceptual, and problem-solving abilities.
Able to prioritize and execute tasks in a high-pressure environment.
Experience working in a team-oriented, collaborative environment.
Preferred Qualifications: Knowledge of industry trends including data mining, visualization and predictive modeling.
Supporting BI technology in a higher educational setting.
Working knowledge of cloud infrastructure (AWS, Azure, GCP).
Knowledge of Ellucian Colleague data structure.
Full Time/Part Time: Full-Time Regular
Degree/Major: Computer science, information systems, or computer engineering
Length Of Experience:
Minimum of 3 years direct work experience developing business intelligence solutions.
Essential Duties and Responsibilities:
Strategy & Planning
Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
Participate in BI project planning process to establish business requirements, define deliverables, conduct data analysis, and establish timelines.
Provide guidance and mentoring for the campus BI Community.
Acquisition & Deployment
Conduct research and make recommendations on BI products, services, and standards in support of the university to enhance institutional decision making.
Evaluate and select database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.Operational Management
Direct, organize, and lead projects in the implementation and use of new BI software tools and systems.
Lead the integration efforts for merging BI platforms with enterprise systems and applications.
Design, code, test, and document all new or modified BI systems, applications, and programs.
Develop the semantic layer, metadata, reports, and report definitions.
Develop graphs and portal interfaces.
Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.
Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.
Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
Collaborate with key functional stakeholders to better understand their business domain, processes and data.
Design and deliver end-user training and training materials; provide technical support as necessary.
Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.
Other duties as assigned.
Elon University has built a national reputation as the premier student-centered university that values experiential learning and strong relationships between students and their faculty and staff mentors. Elon's 7,000 students prepare to become the ethical leaders the world needs, putting their knowledge into action on campus, in the community and around the globe. Elon is known for academic excellence across the curriculum, and for engaged learning programs in study abroad, internships, undergraduate research, leadership and community service. Elon is ranked the nation's #1 master's-level university for study abroad and is a top-producer of Fulbright Student Scholars and Peace Corps volunteers. Elon leads the nation in the annual U.S. News & World Report recognition for academic programs that
Elon University has built a national reputation as the premier student-centered university that values experiential learning and strong relationships between students and their faculty and staff mentors. Elon’s 7,000 students prepare to become the ethical leaders the world needs, putting their knowledge into action on campus, in the community and around the globe. Elon is known for academic excellence across the curriculum, and for engaged learning programs in study abroad, internships, undergraduate research, leadership and community service. Elon is ranked the nation’s #1 master’s-level university for study abroad and is a top-producer of Fulbright Student Scholars and Peace Corps volunteers. Elon leads the nation in the annual U.S. News & World Report recognition for academic programs that “Focus on Student Success.” More than 435 full-time faculty members teach in six academic units: Elon College, the College of Arts and Sciences; the Martha and Spencer Love School of Business; the School of Communications; the School of Education; the School of Health Sciences; and the School of Law. Elon’s four-year graduation rate of 79 percent ranks in the top 10 percent of U.S. private uni...versities. The student-faculty ratio is 12-1, and the average class size is 20. The university’s 656-acre residential campus in the Town of Elon, N.C., is consistently recognized as one of the nation’s finest environments for learning. The Elon Phoenix NCAA Division I athletic program is a member of the Colonial Athletic Association.