NATIONAL GRID CO USA (NE POWER): Etl Architect – Matillion

About usNational Grid is hiring an ETL Matillion Architect for our IT group in Waltham, MA.

This role can also be based in Brooklyn, NY.Every day we deliver safe and secure energy to homes, communities, and businesses.

We are there when people need us the most.

We connect people to the energy they need for the lives they live.

The pace of change in society and our industry is accelerating and our expertise and track record puts us in an unparalleled position to shape the sustainable future of our industry.To be successful we must anticipate the needs of our customers, reducing the cost of energy delivery today and pioneering the flexible energy systems of tomorrow.

This requires us to deliver on our promises and always look for new opportunities to grow, both ourselves and our business.In accordance with guidelines regarding companies classified as Federal contractors and consistent with our core commitment of safety, National Grid has made the decision to require all new hires to be fully COVID-19 vaccinated as a condition of hire.

“Full vaccination” is defined as two weeks after both doses of a two-dose vaccine or two weeks since a single-dose vaccine has been administered.

Anyone unable to be vaccinated, either because of a religious belief or a disability can request a reasonable accommodation.Job PurposeThe Matillion ETL Architect will be working with the Enterprise Data Platform team to maintain and develop data integration solutions to support our Enterprise data platform.

The candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables by working with Snowflake Architect.

The solutions must align with EDW, Data mart and Dimensional modeling, ETL standards and guidelines.

The data modeling and data integration solutions will be based on Matillion with Snowflake data warehouses/databases & Power BI for reporting platform.

The position also requires supporting the Agile process in terms of Development ,testing, deployment and post production support.Key Accountabilities8+ years of experience in implementation of ETL/ELT projects in a large-scale enterprise data warehouse environment and at least one Successful implementation Matillion with Snowflake is must.Handle multiple projects in parallel, Participate and deliver Solution design, working closely with the architecture team Understand business requirements and convert them into detail technical specifications for Data models and ETL programs Design the Logical and Physical data models using the Dimensional modeling techniques.Design and Develop/Review ETL programs primarily using Matillion, Python and R Coach and guide the technical team in terms development of ETL jobs Performance improvement & tuning of Matillion mappings.Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.Create necessary documentation as per the Standards and Update the project documentation.Support QE on End-to-End testing and provide daily/weekly project status to the Project manager Work with deployment team in the code migration across the environments Triage the Production issues and work on the code fixes Experience with Matillion configuration/Administration and Security setup will be an added advantage.Supervisory/Interpersonal Experience Required Good stakeholder management and influencing skills at colleagues, partners / vendors & project sponsors.Qualifications Bachelor’s degree in computer science or related field.

Master’s Degree preferred.

5+ years IT and data experience with a minimum of 2 years of experience with managing an ETL platform Integration product architecture experience with vendor products Technology design experience which includes Performance, Security, Availability, as well as Operations, Monitoring and Support Experience with architecting and enabling capabilities utilizing the following technologies: Linux OS, Cloud based data platforms (e.G., Snowflake) and Microsoft AzureMore InformationThis position has a career path which provides for advancement opportunities within and across bands as you develop and evolve in the position; gaining experience, expertise and acquiring and applying technical skills.

Internal candidates will be assessed and provided offers against the minimum qualifications of this role and their individual experience.National Grid is an equal opportunity employer that values a broad diversity of talent, knowledge, experience and expertise.

We foster a culture of inclusion that drives employee engagement to deliver superior performance to the communities we serve.

National Grid is proud to be an affirmative action employer.

We encourage minorities, women, individuals with disabilities and protected veterans to join the National Grid team.