eCornell Sr. Business Intelligence (Remote)

Department 

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.

The Opportunity:

The Sr. Business Intelligence Engineer is responsible for overall design of data and reporting solutions developed by the software development team in partnership with eCornell’s marketing, operations and finance teams. The BI Engineer is responsible for the design, development, implementation and monitoring of the data transfer / ETL processes from OLTP systems to the warehouse and working with analysts on visualization of the data through Tableau reports. The Sr. BI Engineer will envision and create solutions that meet requirements; model the components of infrastructure and their points of integration; prove the feasibility of a design; create the design artifacts that are required to deliver and to maintain the infrastructure; guide a solution through to its completion; and ultimately to production support.

You are considered competitive for this position if you are:

• Highly organized and detail-oriented with the ability to manage multiple tasks and deadlines efficiently.

• Experienced with AWS services such as AWS Glue, AWS Lambda, S3, and Redshift. The candidate should have hands-on skills in setting up and managing data pipelines, data integration, and ETL tasks using these services.

• Excellent with follow-up and follow-through, ability to work independently, and make decisions with minimal supervision.

• Customer-centric in your approach, with strong interpersonal skills to build effective relationships with faculty, staff, and eCornell departments.

• Adaptable, flexible, and you exercise patience and curiosity in navigating complex issues, with a high level of confidentiality and good judgment.

What you will do:

• Collaborate with business and technical resources to participate in the planning and requirement gathering phases, including estimate, develop, test and deliver quality BI solutions. 

• Design and development of integration architecture for BI and related data analytic solutions. This involves developing robust solutions using eCornell current and future infrastructure in conjunction with vendor based BI tools, using AWS Glue, Lambda, Redshift and Tableau. 

• Own the design, development and maintenance of ongoing data pipelines, metrics, jobs etc. to drive business decisions

• Ensure data quality and integrity during the transformation process

• Collaborate with data analysts and data scientists to understand data requirements

• Monitor and optimize ETL processes for performance and cost efficiency

• Troubleshoot and resolve ETL processes for performance and cost-efficiency

• Maintain proper documentation for ETL processes and data flows

What you will need:

• Experience in and/or demonstrated commitment to supporting diversity, equity, access, inclusion, and wellbeing. 

• Experience working directly with people from diverse racial, ethnic, and socioeconomic backgrounds. 

• Experience incorporating the perspectives of multiple communities, including communities of color.  

• Bachelor’s degree in CS or equivalent and 5-7 years of relevant ETL work experience in a fast-paced development environment, or equivalent combination of education and experience.

• Proven experience with AWS solutions like Glue, Lambda, S3 and Redshift. 

• Experience in data mining, ETL etc. and using databases in a business environment with large-scale, complex datasets.

• 5+ years of experience delivering Business Intelligence solutions. 

• Proficient with SQL and data design. 

• Strong understanding of ETL concepts and data transformation. 

• Proficient in AWS Glue using PySPARK, AWS Lambda, AWS Redshift and Tableau. 

• Proven ability to work, be adaptive, and resourceful, in a dynamic, fast-paced, customer-focused work environment characterized by rapid change, minimal lead times, and multiple competing priorities.

• Excellent analytical, organizational and communication (written and oral) skills; expert interpersonal skills; ability to build and maintain collaborative relationships with customers, stakeholders, and staff at all levels of the organization.

• Self-motivated, ability to work independently and as part of a team, be adaptive to critical needs, and share expertise as needed, demonstrating accountability, openness, and transparency.

• Demonstrated aptitude to stay current on new and emerging technologies.

• Action and results oriented with a positive customer service attitude.

If you have all those things, great! We have a few more things that we would prefer you to have, but it's ok if you don't.

• Bachelor’s/Master's degree in CS or equivalent.

• Experience in education technology.

• Database technology: MS SQL Server, MySQL 

• Experience with Time series analysis and clustering 

**Sponsorship for employment visa is not available for this position**

Rewards and Benefits

• This position is based in Ithaca, New York, however, the successful applicant may perform this role remotely anywhere within the United States. The New York Convenience of employer guidelines require New York State individual tax reporting and withholdings for this position. Additional individual state income tax filings may also be required if working temporarily outside New York State.  

• Cornell receives national recognition as an award-winning workplace for our health, wellbeing, sustainability, and diversity initiatives.

• Our benefits programs include comprehensive health care options, generous retirement contributions, access to wellness programs, and employee discounts with local and national retail brands. We invite you to follow this link to get more information about our benefits: https://hr.cornell.edu/benefits-pay.

• Follow this link to learn more about the Total Rewards of Working at Cornell: https://hr.cornell.edu/jobs/your-total-rewards.

• Our leave provisions include health and personal leave, three weeks of vacation and 13 holidays: Martin Luther King, Jr. Day, Memorial Day, Juneteenth, Independence Day, Labor Day, Thanksgiving and the day after, and an end of the year winter break from December 25-January 1.

• Cornell's impressive educational benefits include tuition-free Extramural Study and Employee Degree Program, tuition aid for external education, and Cornell Children's Tuition Assistance Program

Familiarize yourself with Cornell's COVID-19 workplace guidance as well as the university's COVID-19 services and information.

University Job Title:

Job Family:

Level:

Pay Rate Type:

Pay Range:

Remote Option Availability:

Company:

Contact Name:

Job Titles and Pay Ranges:

Non-Union Positions

Noted pay ranges reflect the potential pay opportunity for each job profile. The hiring rate of pay for the successful candidate will be determined considering the following criteria:

• Prior relevant work or industry experience

• Education level to the extent education is relevant to the position

• Unique applicable skills

• Academic Discipline

To learn more about Cornell’s non-union staff job titles and pay ranges, see Career Navigator.

Union Positions

The hiring rate of pay for the successful candidate will be determined in accordance with the rates in the respective collective bargaining agreement. To learn more about Cornell’s union wages, see Union Pay Rates.

Current Employees:

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.

Employment Assistance:

For general questions about the position or the application process, please contact the Recruiter listed in the job posting or email mycareer@cornell.edu.

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 Office of Institutional Equity and Title IX at voice (607) 255-2242, or email at equity@cornell.edu.

Applicants that do not have internet access are encouraged to visit your local library, or local Department of Labor. You may also request an appointment to use a dedicated workstation in the Office of Talent Attraction and Recruitment, at the Ithaca campus, by emailing mycareer@cornell.edu.

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.

EEO Statement:

Diversity and Inclusion are a part of Cornell University’s heritage. We are a recognized employer and educator valuing AA/EEO, and we do not tolerate discrimination based on any protected characteristic, including race, ethnic or national origin, citizenship and immigration status, color, sex/gender, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual’s genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law. 

Cornell University embraces diversity and seeks candidates who will contribute to a climate that supports students, faculty, and staff to all identities and backgrounds. We encourage individuals from underrepresented and/or marginalized identities to apply.