SUMMARY:

• In this position, you will be responsible for designing, developing, implementing, deploying, documenting, managing, and supporting enterprise cloud ETL processes and environments.

PRIMARY FUNCTIONS AND ESSENTIAL RESPONSIBILITIES:

• Support ENGIE Insight’s computer systems and ETL (“Extract, Transform, Load”) data processes.
• Translate business requirements into data models that drive data lake or mart or warehouse design and configuration.
• Actively participate in estimating the level of effort and documenting the work breakdown.
• Actively participate in team ceremonies (daily stand-up, backlog refinement, review, retrospectives, etc.)
• Work with cross-functional teams to gather, document, and approve business requirements for data analysis and reporting projects.
• Actively participate in translating business requirements into a system design specification to manage Unstructured, Transactional, Hierarchical, Master and metadata.
• Actively participate in designing, developing, and implementing data integration (ETL) processes to transform unstructured and disparate source data into target data stores, lakes, marts, or warehouses.
• Actively participate in designing, developing, and implementing test automation processes.
• Review implementation and maintenance of ETL processes that support feature development and testing.
• Monitor data lake, mart, or warehouse ETL processes and implement tuning to address scalability, recoverability, and performance impediments.
• Provide on-call support to Business Intelligence environments for internal and external users.
• Plan and conduct development work on data integration projects necessitating the origination and application of new and unique approaches.

QUALIFICATIONS AND REQUIREMENTS:

• Education/ Certifications/ Experience
  • Bachelor's Degree required in one of the following fields: Computer Science, Computer Engineering, Electrical & Computer Engineering, Information Systems, or a closely related field
  • 0-2 years of data engineering or software engineering experience preferred
  • Azure or AWS (Amazon Web Services) data engineer certification a plus
  • May consider a combination of relevant experience with educational and other skills and abilities in lieu of educational requirements
• Competencies/ Skills/ Abilities
  • Strong verbal, written and interpersonal skills.
  • Experience with the Microsoft Office suite of products required
  • Familiarity with systems: SQL Server, Snowflake, or other database technology
  • Basic understanding of data modeling preferred
  • Basic understanding of C# or any OOP programming language preferred
  • Basic understanding of SQL query language required
  • Basic understanding of OOP concepts preferred
  • Basic understanding of various data formats (XML, JSON, parquet, etc..) required
  • Azure Data Factory, Informatica, or another cloud ETL tool experience preferred
  • Familiarity or work experience with Azure Data Factory a plus
• Other
  • Passion to drive Engie Impact’s mission and values

WORK ENVIRONMENT:

• Work schedules are determined by business need and manager discretion; full time employment is considered 40 hours per week
• Remote work is permitted from a residence within commuting distance of ENGIE’s Spokane worksite at manager discretion
• Incumbent must be available for on-call responsibilities during scheduled time
• Off-site travel to local events may be required up to 10 days per year.
• Health & Safety Working Requirements
  • Adequate working surface (can fit two monitors, a keyboard, mouse, and docking station)
  • Adjustable ergonomic chair
  • Proper Lighting
  • Heating, air conditioning and ventilation to create a comfortable environment
  • Appropriate internet and bandwidth to conduct business
• Incumbent may be exposed to frequent noise caused by telephones, office machines, and nearby oral communications among fellow employees
• As a global organization, attending meetings and events during early mornings and evenings may be required
• Performing duties and attending events during the evening and on the weekend occurs occasionally and may be required
• Business travel may be required up to 10% of the time

REQUIRED PHYSICAL ACTIVITIES:

• Manual and physical dexterity needed to operate a computer keyboard and handle paper documents
• Adequate hearing and verbal abilities to communicate effectively in person, by telephone, and by video call
• Sufficient near vision acuity to read information appearing on computer display screen, in handwritten forms, and printed on paper
• Entering text or data into a computer or other machine with a traditional keyboard. Traditional Keyboard refers to a panel of keys used as the primary input device on a computer, typographic machine, or 10-Key numeric keypad.
• Clarity of vision at approximately 20 inches or less (i.e., working with small objects or reading small print), including use of computers.