As Cornell University's online learning unit, eCornell delivers online professional certificate courses to individuals and organizations around the world. Courses are personally developed by Cornell faculty with expertise in a wide range of topics, including data analytics, management, marketing, human resources, leadership, and STEM. Students learn in an interactive, small cohort format to gain skills they can immediately apply in their organizations, while earning a professional certificate from Cornell University. eCornell has offered online learning courses and certificate programs for 15 years to over 130,000 students at more than 2,000 companies.
eCornell embraces diversity and seeks candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. We strongly encourage individuals from underrepresented identities to apply.
eCornell has an exciting opportunity for a BI Architect to join our growing team! We are looking for a hands-on individual who has a passion for data, and excels at designing, implementing, and executing data rich enterprise-wide BI solutions to achieve competitive advantages. The BI Architect will partner directly with business stakeholders to comprehensively understand their processes and build rock solid BI programs designed to drive trusted company metrics and decisions. The key to success is building a BI strategy that ingests data from multiple transactional systems like Destiny SIS, Salesforce, Qualtrics and Adstage and aggregating it into meaningful decision making datastores which can be easily consumed - in a self-service manner - by all functional areas. This is a highly visible key strategic role for the company requiring experience maturing our current analytical capabilities.
Lead the BI journey roadmap in collaboration with business and technical resources to deliver quality BI solutions.
You will also:
Design and develop the architecture and internal integration for BI/data analytic solutions.
Create multiple data marts and visualizations using Tableau for each functional area, building on the existing ETL infrastructure, which is based on PySPARK and Redshift.
Design, develop, manage and update logical and physical data models for the BI data marts.
Formulate and recommend standards for achieving maximum performance and efficiency of the DW ecosystem.
Follow market trends for COTS and open source tools. Provide architectural expertise and thought leadership for tools' evaluation and recommendation.
Resolve system test and production problems (including occurrences after normal working hours as needed), including any necessary documentation or communication to Quickly learn and provide solutions using current and future eCornell BI Toolset(s).
Actively participate in assigned project teams, acting as experts in techniques and methods for producing BI solutions.
Develop and maintain documentation/standards.
What we need:
Bachelor's degree in Computer Science, Engineering or related technical discipline with 5 years experience delivering Business Intelligence solutions or equivalent combination of education and experience.
2-3 years of related experience in one of the following: data collection/aggregation, Dimensional/STAR Data Modeling, ETL development using Glue and Lambda, Dashboard Design & Development using Tableau.
Proficient with SQL and data design.
Proficient in PySpark, Redshift and Tableau.
Experience with Software Development Life Cycle and software engineering methodologies, including requirement gathering and analysis, software development, installation, integration, evaluation, enhancement, maintenance, documentation, testing and knowledge transfer.
Demonstrated proficiency developing technical skills in a rapidly changing, continual learning IT/Business environment conducting data analysis.
Excellent technical, verbal and written communications skills and ability to multi-task.
Ability to problem solve and document solutions, designs, issues, etc.
Possess positive attitude, motivated, and willingness to learn and work well with others in a team-oriented, fast paced, deadline driven, extremely complex, and rapidly changing IT environment.
Understanding of dimensional modeling concepts.
What we prefer:
Master's degree in Computer Science or Statistics; 7-10 years relevant work experience.
Database technology: MS SQL Server, MySQL.
Proficiency in AWS Lambda.
Experience with Time series analysis and clustering.
Experience and knowledge of data warehousing initiatives or decision support systems in a higher education environment.
Participation in design and implementation of data warehouse solutions.
No visa sponsorship or relocation assistance is available for this position. This is a remote position.
What we offer:
The opportunity to work with a dynamic group of people in a high-growth organization.
Employee growth is promoted.
A broad set of competitive benefits, including educational opportunities, access to virtual wellness programs, health care options, 3 weeks of vacation, 13 holidays, and superior retirement contributions.
If you currently work at Cornell University, please exit this website and log in to Workday using your Net ID and password. Select the Career icon on your Home dashboard to view jobs at Cornell.
Online Submission Guidelines:
Most positions at Cornell will require you to apply online and submit both a resume/CV and cover letter. You can upload documents either by "dragging and dropping" them into the dropbox or by using the "upload" icon on the application page. For more detailed instructions on how to apply to a job at Cornell, visit How We Hire on the HR website.
If you require an accommodation for a disability in order to complete an employment application or to participate in the recruiting process, you are encouraged to contact Cornell University's Department of Inclusion and Workforce Diversity at voice (607) 255-3976, fax (607) 255-7481, or email at email@example.com.
For general questions about the position or the application process, please contact the Recruiter listed in the job posting.
Applicants that do not have internet access are encouraged to visit your local library, or local Department of Labor. You may also visit the office of Workforce Recruitment and Retention Monday - Friday between the hours of 8:30 a.m. - 4:30 p.m. to use a dedicated workstation to complete an online application.
Notice to Applicants:
Please read the required Notice to Applicants statement by clicking here. This notice contains important information about applying for a position at Cornell as well as some of your rights and responsibilities as an applicant.
Diversity and Inclusion are a part of Cornell University's heritage. We are a recognized employer and educator valuing AA/EEO, Protected Veterans and Individuals with Disabilities. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations. Cornell University is an innovative Ivy League university and a great place to work. Our inclusive community of scholars, students, and staff impart an uncommon sense of larger purpose, and contribute creative ideas to further the university's mission of teaching, discovery, and engagement.
Internal Number: WDR-00024038
About Cornell University
In 1865, Ezra Cornell founded an institution "where any person can find instruction in any study." From the beginning, all students were welcome, regardless of race, gender, ideology, or socioeconomic status. Today, we invite you to join our talented and diverse students and accessible faculty who, together, form a living and learning community unmatched in its breadth of opportunities.Cornell University's college, schools, and other academic units offer more than 4,000 courses, 70 undergraduate majors, 93 graduate fields of study, undergraduate and advanced degrees, and continuing education and outreach programs.