ETL Developer

Boston, Massachusetts


Job Overview

The ETL Developer is responsible for end-to-end processes related to the Extraction, Transformation, and Loading of business information from transaction systems into data warehouses and reporting systems.  This includes the design, development, and deployment of batch and near-real-time data load processing, with primary focus on maintaining the back-end components to support our client’s data warehousing and CRM systems.  This position requires demonstrated technical and functional skills in the ETL and data warehousing field, combined with in-depth analytical and production support experience.

Reporting to the Director of Data Architecture, the ETL Developer participates in business requirements review, assists with system specifications, develops technical specifications, develops code changes in Informatica and other ETL tools, performs unit testing and implementation in production. The developer must follow the defined development standards and best practices and attend code reviews to assure compliance.

Essential Functions

Data Integration

  • Design, develop, and test ETL processes to integrate data 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
  • Participate in data modeling design sessions
  • Implement code changes based on system specifications
  • Analyze problems and propose solutions
  • Work with DBAs and Data Architects to implement database changes
  • Support and take direction from Data Architects, Principal and Lead ETL Developers
  • Participate in system and user testing, as well as production launches


Operational Support

  • Monitor batch jobs and resolve any issues in a timely manner
  • Look for opportunities to enhance existing code and processes as well as overall data quality improvements
  • Test and troubleshoot business reporting for end users in 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


  • 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

Minimum Qualifications

  • BA or BS
  • 3+ years of experience in ETL design and 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
  • Analytical, problem solving, and testing skills
  • Effective oral and written communication skills
  • Must have solid understanding of relational database design
  • Experience with BI and reporting platforms such as Business Objects, Crystal Reports, Tableau, PowerBI, and Cognos
  • Entrepreneurial mindset and passion for emerging technologies
  • Ability to collaborate with stakeholders from local, national, and international constituencies
  • Excellent communication and creative-thinking skills, with an ability to use data to inform all decisions
  • Eligible to work and travel in the United States without sponsorship

Preferred Qualifications

  • BA/BS in information systems, information technology, or computer science
  • Knowledge of 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 Education is an Equal Opportunity Employer.