Client-Facing, BI/Data Architect - Direct Hire - Open to Remote - Greensboro, NC - $90k-$120k/yr
*Candidate must be able to work on the client's W2 without an employer or vendor*
*Highly prefer someone in North Carolina (Huge Plus) but open to remote candidates*
Candidate needs to be highly technical but also have experience working with business units, stakeholders and building relationships
Position Summary
BI/Data Architect 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 with the client 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 with Us
As a Permanent employee for our client, 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, Our client's personal approach to education extends to employees, whose growth, professional development and success is a hallmark of our training and advancement opportunities.
Our client's home is the charming town of Greensboro, 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 of our client 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 fitness facilities.
Free admission to musical and theater performances, guest speakers, religious and ethnic observances, recitals, art exhibitions, entertainment and our Division I athletics.
Eligibility for tuition remission from client 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.
Our client values and celebrates the diverse backgrounds, cultures, experiences and perspectives of our community members. As an equal opportunity employer, our client'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. Our client's 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 our client's BI implementation and define standards and best practices for development and managing security and access, and administration.
- Design the data architecture for our client's BI implementation (ie. Datasets, Data Lakehouse)
- Train and mentor 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, …)
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystems.com or 844-463-6178.
