Location: Elon University Campus, North Carolina, 27244
Title: Business Intelligence Architect
Position Type: Staff Full-Time
Days Per Week: Monday - Friday
Hours Per Week: 40
VP Area: Finance and Administration
Department: Information Technology
Position Summary
The Business Intelligence (BI) Developer with proven experience providing BI solutions 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.
Benefits of Working at Elon
As an Elon University employee, you'll join an internationally acclaimed university with a commitment to fostering a thriving community. Ranked among the most innovative, creative and best-run universities in the nation, Elon's personal approach to education extends to employees, whose growth, professional development and success is a hallmark of our training and advancement opportunities.
Elon University's home is the charming town of Elon, North Carolina, a small, friendly community located a short distance from the beach and the mountains, and among the vibrant cities of Greensboro, Raleigh and Durham. In addition to the beautiful canopy of historic oak trees iconic to our campus, you'll find boundless opportunities for family-friendly recreation, cultural events and outdoor activities. Hiking, water sports, fine dining and entertainment are just a few of the many happenings in the Elon area, making the region one of the nation's premier travel destinations.
Employees at Elon enjoy a generous and comprehensive benefits package that includes:
28 annual days off, including holidays and vacation.
Immediate tuition remission for undergraduate courses
Tuition remission for approved graduate-level courses after 12 months of employment.
Retirement plan with an 8 percent contribution from the university.
Immediate eligibility for health, dental and vision insurance, along with free acute care and lab services at our onsite Health & Wellness Clinic.
Free use of campus fitness facilities.
Free admission to musical and theater performances, guest speakers, religious and ethnic observances, recitals, art exhibitions, entertainment and our Division I Phoenix athletics.
Eligibility for tuition remission at Elon for spouses, qualifying domestic partners and dependents begins at two years of service. After two years of employment, eligibility begins for participation in the Tuition Exchange, a national scholarship exchange program that enables dependents to enroll in nationally recognized partner colleges and universities.
Elon values and celebrates the diverse backgrounds, cultures, experiences and perspectives of our community members. As an equal opportunity employer, Elon's principles of diversity extend to race and gender identity, age, disability status, veteran status, sexual orientation, religion, and other aspects of one's identity. At Elon, our employees respect human differences, passion for lifelong learning, emphasis on personal integrity and an ethic of service.
Minimum Required Education and Experience
Bachelor's degree in Science, Technology, Engineering, or Math and a minimum of 5 years of experience or an equivalent combination of education and years of experience as a BI Developer.
Preferred Education and Experience
Master's degree in Science, Technology, Engineering, or Math
Strong experience leading BI initiatives
Experience designing and developing data warehouse and reporting architectures
Experience with BI technologies, such as SSAS, MS Power BI, Tableau and other BI applications.
Strong experience gathering requirements and designing and building solutions to meet those requirements.
Strong experience sourcing and integrating data from disparate data sources (Cloud and on-premise relational databases, APIs, files of varying formats)
Strong experience modeling data for both transactional and reporting systems.
Experience using ETL or ELT to transform data into formats appropriate for reporting and analytics
Strong experience creating reports and dashboards.
Experience with software development best practices such as agile methodologies, source code control, prototyping, and testing.
Experience with troubleshooting enterprise Bl systems and processes.
Experience working in a team-oriented, collaborative environment.
Experience training technical and non-technical users on BI tools.
Job Duties
Strategy, Planning & Architecture
Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
Lead BI project planning process to establish business requirements, define deliverables, conduct data analysis, and establish timelines.
Architect Elon's BI implementation and define standards and best practices for development and managing security and access, and administration.
Design the data architecture for Elon's BI implementation (ie. Datasets, Data Lakehouse)
Train and mentor campus BI developers. Serve as the SME for topics related to BI.
Provide consultation, advice, and expertise to distributed BI developers and campus stakeholders regarding BI related endeavors.
Partner with the business areas to identify, audit, and define and execute a plan for addressing data standards and data quality.
Acquisition & Deployment
Lead the research and development of BI products, services, and standards in support of the university to enhance institutional decision making.
Evaluate and select business intelligence components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
Direct, organize, and lead projects in the implementation and use of new and existing BI solutions.
Lead the integration efforts for merging BI platforms with enterprise systems and applications.
Lead the data quality initiatives focused on standardizing and cleaning data needed for reporting / analytics. Requirements Gathering:
Gather user requirements for new BI initiatives and changes to existing solutions Development:
Design, develop, and document new or modified BI data solutions including Data Lakehouse models as well as BI tool metadata models.
Design and develop ETL to transform source data into a format that supports BI. (This is currently done in PBI and on the move to the data lakehouse.)
Design, develop, and document BI user facing solutions including reports, dashboards,
Perform statistical analysis as appropriate for BI related projects that include predictive and prescriptive analytics.
Assist in the design of transactional data and database structures being developed by others in Enterprise Solutions to ensure modeling supports the BI needs. Data:
Collaborate with key functional stakeholders to understand their business domain, processes, and data.
Work with key stakeholders to address new and recurring data clean up items. Training:
Design and deliver end-user training and training materials; provide technical support as necessary.
Design and deliver BI developer training / mentoring (one-on-one and formal sessions) that focuses on strengthening the BI competency Support:
Provide business hours and off-business hours support for all BI solutions. This includes support for scheduled processes, reports, dashboards.
Provide during and after-hours support for BI system maintenance (ie. gateway upgrades) and non-BI system maintenance that impacts BI solutions (ie. Colleague, Etrieve, )
Elon University has built a national reputation as a premier student-centered arts and sciences university that values strong relationships between students and their faculty and staff mentors. Elon is ranked among the top-100 National Universities by U.S. News & World Report, with a No. 1 ranking for excellence in undergraduate teaching and No. 9 for innovation. Global engagement is central to Elon’s experience and the Institute of International Education has ranked the institution No. 1 in the nation for study abroad for 16 straight years.In addition, Elon is the only university in the nation ranked in the top-20 by U.S. News for excellence in all eight academic programs “Focused on Student Success.” Elon’s more than 7,000 students prepare to become the resilient, ambitious and ethical leaders the world needs, putting their knowledge into action on campus, in the community and around the globe.