Data Engineer

Here at Ellucian, we are motivated by a mission ~ the power of education to transform lives and change the world. We are the global market leader in EdTech for Higher Education, serving more than 2,700 customers and reaching over 26 million students in 50+ countries. We are dedicated to helping Higher Ed thrive by transforming their institutions to agile, digitally connected campuses that enable student success.

About the Opportunity:

Reporting to a Principal Software Engineer Lead, our Data Warehouse Engineer will manage our buildout of the operations and analytics data warehouse for CampusLogic products. The Data Warehouse Lead’s role is to develop and maintain reporting and analysis databases using the Microsoft stack, primarily in Azure, ensuring high levels of data accessibility and availability. They will also evaluate and advise on database architecture and lead the continued build-out and maintenance of the operations and analytics data warehouses. We’re a fast-paced (understatement) and passionate about how awesome financial success can be. If you love cross-departmental collaboration, data warehouse design, technical execution, and thrive in an environment of project ownership then we want to hear from you.

Where you will make an impact:

• 
  Works closely with IT partners and Business Operation teams to lead and participate in the identification, planning, prioritizing, requirements gathering, design, development and implementation of all Data Warehousing and BI projects
• Architect and maintain data warehouses to support ease of data modeling, reporting, and analysis using dimensional model architecture (such as star schemas and OLAP cubes)
• With support from Business Operations gather requirements to grow and improve the data warehouse for reporting, BI integration, and ad hoc analysis

• Makes recommendations, based on data profiling and data analysis, for changes to existing/legacy systems particularly in the area of data warehouse architecture
• Develop and maintain database stored procedures, views, and functions that support data models
• Works with non-technical, subject matter experts to understand underlying data behavior and characteristics in ways that will be new for such non-technical people.
• Develop and maintain ETL processes, diagnose and resolve database access and performance issues, and plan and coordinate backup and disaster recovery setup
• Provide expert thought leadership in the development and implementation of data governance policies and processes

• Provide data management support and work cooperatively with Business Operations to resolve data and process issues
• Create and maintain technical documentation

What you will bring:

• 
  Bachelor’s degree in Computer Science, Computer Engineering or relevant field.
• At least five years or more of experience in data warehouse architecture and administration within the Microsoft/SQL stack
• Strong familiarity with Kimball methodologies of data warehousing
• Ability to communicate verbally and in writing with end users and technical users to translate requirements from end users into useful visualizations and analysis
• Comprehensive grasp of data visualization methods and data modeling for effective database architecture to streamline business analysis and reporting

• SSMS, ETL (SSIS, C#), Reporting (SSRS & Power BI), SSAS, and DAX Language expertise
• In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)
• Broad business experience with proficient ability to talk in business terms
• Excellent verbal and written communication skills

What makes #Ellucianlife

• 
  Comprehensive health coverage: medical, dental, and vision
• Flexible time off
• Thrive Flex Program that allows you to contribute towards your health, financial or learning interests
• 401k w/ match & Bright Plan - to help you save for the future
• Maternity & Paternity Leave

• Charitable leave – 40 hours/year
• Telemedicine
• Wellness

• Ginger (mental health)
• Wellbeats (virtual fitness classes)

• Rethink – caregiver support
• Diversity and inclusion programs which provide access to 11 internal employee resource groups
• Tuition Reimbursement Assistance
• Professional development opportunities

Additional Information: