Who are we?
For the past 20 years, we have powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various Digital Modernization. For a brief 1 minute video about us, you can check https://youtu.be/uJWBWQZEA6o.
What will you do? What are we looking for?
Job Title: Senior ETL Developer – Data Services Team
Key Duties
• Plays a lead role in the areas of ETL design, data modeling, and ETL development.
• Facilitates best practice guidelines around all stages of development.
• Provides technical leadership to serve as point of escalation, review, and approval for key issues, significant projects, and decisions.
• Able to work with stakeholders, and translate requirements to design and build a solution that will meet Business needs and integrate seamlessly with the EDW.
• Gain team and stakeholder approval for all designs, and effort estimates.
• Research and analyze current systems, subsystems and interfaces to understand the current or new process flow.
• Document work via Functional and Tech Specs.
• Develop unit tests, performance tests, and take into account security requirements.
• Prepare and participate in design and code reviews.
• Analyzes processes for gaps and weaknesses, building future state models and creating the roadmaps and migration plans to get there.
• Communicate progress and work using the Agile Methodology.
Job-Specific Skills
• Required:
- 5+ years of experience of with Oracle
- 5+ years of experience with Data Warehousing: building relational databases, star schemas
- 5+ years of experience with Data Modeling
- 4+ years of experience with ODI (Oracle Data Integrator Tool) or Informatica IDMC.
- 3+ years of experience with Databricks Lakehouse and/or Delta tables.
- 2+ years of experience in the design, implementation, and support of a Kimball method data warehouse on SQL Server or Oracle
- Strong SQL reading and writing skills
- Business and/or technical background in the areas of Data Integration (ETL), Data Security, and Enterprise Data Warehouse development
- Experience in Change Management, Release Management, and Source Code control practices
Education
• High school diploma or equivalent is required.
• A Bachelor of Arts or a Bachelor of Science degree, with a focus in computer science, systems analysis, or a related area, is
preferred.
Similar Jobs
What you need to know about the Boston Tech Scene
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
