Develop and maintain ETL processes to populate the data warehouse
Build and maintain Google BigQuery data warehouse interfaces to house data from various sources such as Oracle, MySQL, and Web APIs, etc.
Building and maintaining production data pipelines for data analytics
Partner cohesively with campus stakeholders to align with their strategic goals and initiatives through the implementation of Campus Data Warehouse
Collaborate with key analytical vendors who can provide specialized expertise to assist with solution development while developing the in-house effort and managing CO interface
Follow project plans, timelines, and vendor relationships to ensure releases are delivered with the highest quality, on-time and within budget
Provide the data analytics infrastructure that supports and achieves operational organization goals and targets
Apply performance tuning techniques to existing and new ETL scripts and analytical reports
Develop efficient database manipulation code to ensure reliable and consistent result sets
Develop appropriate and reusable data validation scripts to ensure the analytical dashboards are meeting the business requirements
Assist the development team in performing the troubleshooting of Campus Data Warehouse components as identified by the Business groups
Develop and deploy ad-hoc query extracts from Campus Data Warehouse as desired by the Business groups
Participate in overall analytics architecture and application roadmap.
Assist in the improvement of organization performance by utilizing not only the data already available to the organization, but also utilizing new and innovative sources of data
Develop custom reports as necessary using visualization tools such as Google Data Studio, Tableau and other visualization tools
Identify, interpret, analyze and address critical business issues, questions and to develop use cases.
Organizing and creating an environment that makes data and information accessible with appropriate channels of access controls.
Requirements :
A bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience
5+ years of experience in business applications analysis, design, and programming for medium or large scale, multi-programmed computers