Job Description for the Business Intelligence Architect position. Review job description, requirements, and qualifications. Apply or register interest for the position.

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.
• Operational Management Project Management / Initiative Management
• 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, …)