Grand Circle Corporation Lead ETL Developer in Boston, Massachusetts

Responsibilities:

Provide architectural & technical insight for successful development of data integration & data warehouse projects Create processes to hold the dev team accountable for following best standards & practices for all development activities Help & advise in roadmap strategy for data warehouse modernization efforts – moving to Big data platforms, cloud data storage, transformation & visualization, Predictive analytics etc. Clearly communicate both verbally & written on issues & blockers with recommended approaches & options to solve them Resolve technical blockers and manage day to day workload & also work with the department leader in resource planning Work closely with Data Quality team to ensure the quality of the developed product is of high standards Performance management of direct reports (Offshore co-ordination required)

Requirements

Requirements:

10+ years of Datawarehouse & ETL Architecture & Design experience 10+ years of hands on experience with Informatica PowerCenter , SQL Query Editor tools, Data modeling and managing database 5+ Experience in converting business requirements to relational & Dimensional data models using Erwin or similar tools 5+ Years of leading project deliveries, project teams & resources 2+ years’ experience working in implementations of modern data architecture platforms in the following areas Cloud DW (AWS Redshift, S3/Azure), Hadoop, Predictive analytics using Python etc. Hands on experience with data warehousing design & implementation, data modelling, logical and physical database design, data architecture, ETL Architecture, Performance tuning & Root cause analysis Ability to troubleshoot problems and solve blockers on a day to day basis Experience working with XML data sources, Web Services, Shell scripting in Unix & Linux Experience in identifying & fixing performance bottle necks in ETL & Database processes Bachelor’s Degree or higher plus required experience

Preferred:

  • Consulting experience of implementing various arrays of data solutions for difference clients from inception/design phase.

  • Implementation experience in moving from a traditional datawarehouse to modern data foundations using Big data technologies, Cloud Data technologies & Data visualization tools is a big plus

  • Worked in Agile environment using TFS or Similar tools

  • Proactive & Fast moving team players who has worked in a highly changing environment

  • Strong oral and written communication skills, including presentation skills (MS Visio, MS PowerPoint)

Benefits

Benefits

  • Significant personal travel discounts & deals

  • MBTA T pass subsidy of 75% or Parking subsidy of 25%

  • Generous Paid Time Off program & 9 company holidays

  • Flexible work options to support work life balance

  • Maternity and Paternity leave

  • Paid Sabbatical at 5 years and 10 years

  • Wellness program with on-site Health Coach, fitness center & complimentary fitness classes

  • Weekly complimentary chair massages

  • Casual Dress code every day!