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.