Iberdrola USA Senior Data Engineer (AMC 56456) Orange, CT in Orange, Connecticut
Business and Department
Scope of Work - Main duties, settings, geography, reporting relationships, other relationships:
The purpose of this role is to work closely with the business and other IT team member to develop solutions that help them understand, model and govern the companies data and to ensure best practice is applied in the transit and transformation of data through its journey from creation to actionable information.
This role will also assist the business in the development and management of Enterprise Information Models and best practice Data Modeling and Data Architecture to support Business Intelligence and Data Mining initiatives across AVANGRID.
This role will be able to identify, manage and design requirements for data extractions, data transformations and data loading, to and from various technical platforms; including SAS, Oracle Exadata and Hadoop and other NoSQL ecosystems to ensure business value is delivered in the most efficient way.
MAJOR ROLES AND RESPONSIBILITIES (Scope of work – range of responsibilities):
Analyze the existing data repositories and business processes to derive data profiles and identify data sources.
Identify, design and maintain data models as required.
Assist with the definition of use cases and business use of Big Data Platforms such as Hadoop and other NoSQL platforms describing the advantages and disadvantages of options available
Assist in the design of data acquisition, cleansing, and transformation into target data structures from potentially
multiple sources: SQL and non SQL databases, structured and non-structured files, Hadoop.
Design and develop programs that will run in Big Data infrastructures:
Massive data processing (as smart meter data processing)
Operationalize analytic models to run efficiently (analytics on Hadoop)
Data Provisioning (including ETL/ET)
Present to business, non-technical audience being able to create, prototypes, and demonstrations to help management better understand the work.
Help maintain documentation of data models and/or other reusable knowledge assets regarding data governance.
Support in when and how to leverage new Big Data technologies such as, NoSQL, Hadoop and foster its usage within the AVANGRID organization with clear business outcomes.
Strong familiarity with data management disciplines and tooling.
Strong Knowledge of Big Data methods and tools: Hadoop (MapReduce, Hive, Hbase), Spark…
Knowledge of NoSQL databases (Document databases such as MongoDB, Column databases such as Cassandra)
Working knowledge of BI tools (such as SAP Business Objects, MicroStrategy)
Familiarity with SQL.
Experience working in environments that apply agile development best practices.
Strong commitment to establish Standards of Best Practices.
Knowledge of SAP data structures (CRM and Utilities) would be an advantage.
You will have the opportunity to work on a variety of digital projects.
Working closely with IT technical teams and Business teams.
Work closely with AVANGRID Architecture team to evolve IT standard and architecture models as required.
Engage Applications Managers as needed to gather requirement and manage expectations
Establish and maintain relationships with 3rd party suppliers for researching activities.
Education & Experience Required:
- Bachelors Degree with a minimum of 4 years relevant experience required.
Good oral and written communication skills.
Strong problem solving and analytical skills.
Ability to multi task.
Strong Interpersonal and Communication Skills.
Willingness to travel.
Must be a proven team player to work, promote and consolidate efficient team working relationships.
AVANGRID is an Equal Opportunity / Affirmative Action employer. AVANGRID shall abide by the requirements of41 CFR 60-1.4(a), 60-300.5(a) and 60-741.5(a). These regulations prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities, and prohibit discrimination against all individuals based on their race, color, religion, sex, sexual orientation, gender identity, or national origin. Moreover, these regulations require that covered prime contractors and subcontractors take affirmative action to employ and advance in employment individuals without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin, protected veteran status or any other status protected by federal, state, or local law. The Company is committed to a policy in all of its employment practices of equal opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin, disability, religion, marital status, veteran status, sexual orientation, or other protected status. If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs, you may request a reasonable accommodation by contacting our Human Resources department at 877-387-9061 or email@example.com
Company: Avangrid Management Company (AMC)
Department: INT Contracts Management
Job Title: Senior Data Engineer
Reports to: Executive Director, IOC
Location: Orange, CT
Cross Company Responsibility: Yes
Publication date: 24.04.2018