Data Engineering Manager
About Us
Shorelight is reinventing the international education experience for students worldwide. Based in Boston, the company works directly with top-ranked, nonprofit American universities to build innovative programs and high-touch, technology-driven services that help talented students thrive and become global citizens.
Job Overview
The Data Engineering Manager leads a team of Data Engineers in all aspects of data warehouse and data integrations. He/She/They design, develop, and deploy solutions that support the company’s data warehousing and CRM system integration. This role reports to the Vice President of Software Engineering.
The Data Engineering Manager has outstanding oral and written communication skills, solid analytical and problem-solving abilities, and excellent testing skills. He/She/They has an entrepreneurial mindset, a passion for emerging technologies, and the ability to collaborate with and address both technical and nontechnical stakeholders at all levels of the organization. The Data Engineering Manager is comfortable multitasking, changing priorities as needed, and using data and creative thinking to inform all decisions.
Essential Functions
Data Warehouse
- Design, develop, and test data warehouse tables and infrastructure
- Work closely with the Data Analytics Team to identify new requirements for the data warehouse
Data Integration
- Design, develop, and test data integration processes among business systems and data warehouses in multiple DBMS environments, including cloud-based systems
- Design, develop, and test system integrations among enterprise front- and back-office applications (ERP, CRM, Financial, Planning, and other systems)
- Prepare documentation and flow charts of systems, business processes, and databases
- Lead solutioning and participate in data modeling design sessions
- Provide guidance to engineers on implementing code changes based on system specifications
- Analyze problems and propose solutions
- Lead DBAs and Data Architects to implement database changes
- Direct, support, and mentor other Data Engineers on the team
- Ensure Data Engineers execute system and user testing and plan production launches
Operational Support
- Monitor daily jobs and take corrective actions for identified errors, ensuring the operation runs smoothly
- Identify opportunities to enhance existing code, processes, and overall data quality improvements
- Test and troubleshoot issues identified and reported by end users of Tableau, Microsoft PowerBI, and other BI tools
- Assist power users in their understanding of the Enterprise Data Model and usage of the Enterprise Data Warehouse
Security
- Comply with Shorelight Written Information Security Policy, and all other Shorelight Information Security Policies and Procedures
- Take responsibility for any Shorelight assets assigned to you
- Promptly report any security events, incidents or weaknesses to Shorelight Security
People Management
- Recruit, develop, and retain team members to ensure productivity and engagement
- Engage in talent management activities such as goal setting, performance evaluations, stay interviews, development planning, and ongoing feedback to develop team members and achieve organization goals
- Provide coaching, counseling, and corrective action (when necessary) to team members
- Foster a culture that reflects Shorelight’s values
Minimum Qualifications
• Bachelor’s degree
- 10+ years of experience in data management and ETL design/development
- Experience in database development using Amazon Redshift, DB2, SQL Server, and/or Oracle
- Strong SQL scripting skills, including procedural languages such as PL/SQL and T-SQL
- Experience with ETL tools such as Informatica, SSIS, and Pentaho PDI
- Experience in working with large-scale data warehousing and complex transformations
- Experience in working with dimensional models
- Experience using a software development lifecycle (SDLC) methodology
- Knowledge of Stored Procedures/Unix scripting knowledge
- Knowledge of implementing adequate controls for balancing
- Must have solid understanding of relational database design
- Experience with BI and reporting platforms such as Business Objects, Crystal Reports, Tableau, PowerBI, and Cognos
- Eligible to work and travel in the United States without sponsorship
Preferred Qualifications
• Bachelor’s degree in information systems, information technology, or computer science
- Knowledge of Salesfoce.com data model
- Experience with Informatica Cloud
Application Process
To apply for this position, please visit the Shorelight Careers page to submit an application with a resume and cover letter.
Background Check Required–Education, Criminal, Identity
Shorelight is an Equal Opportunity Employer.