Data Modeler

DATA MODELER / DIGITAL

CONTRACT TO HIRE 

REMOTE : PREFER : CA, AZ, WA, ID, OR, NV

• Leads the development, validation, publishing, and maintenance of logical and physical data models supporting data lakes and warehouses underpinning enterprise scale transactional and analytical applications in the energy market.   Significant big data expertise using Microsoft Azure  and Snowflake technologies.

PRIMARY FUNCTIONS AND ESSENTIAL RESPONSIBILITIES: 

• Experience in development of the conceptual, logical, and physical data models, the implementation of RDBMS, Data warehouse star-schema models, entity relationships to 3NF, operational data store (ODS), data marts, and data lakes
• Experience in design, implementation of data architecture and data modeling solutions, which include the use of relational, dimensional, hierarchical and NoSQL databases
• Expert in data architecture and the optimization of data query performance via best practices
• Strong knowledge of data modeling principles and best practices including good understanding of canonical data modeling concepts
• Experience working with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
• Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models
• Integrations with Data catalogs (business, functional, technical and operational)
• Work with the business, users, lead architect, and designers to define the data requirements and structure for the application(s)
• Evaluate existing database and create conceptual, logical and physical data models and data flows
• Model and design DW schema for Snowflake based on the current use cases
• Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth
• Translate business functional requirements into data requirements partnering with data engineering team to build supporting data models
• Create conceptual, logical and physical data models using best practices to ensure high data quality and support application, batch and interactive use cases
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
• Establishes and maintains a data modeling repository and ensures it’s implemented according to standards
• Deliver well defined data design documentation and data models for the data warehouse solutions
• Work with technical software development and data engineers to strategize solutions to align with business requirements
• Experience in Azure Cloud Data Solutions

QUALIFICATIONS AND REQUIREMENTS: 

• Education/ Certifications/ Experience
  • Bachelor's Degree required in one of the following fields; information technology, engineering, or similar field
  • Master’s Degree preferred in one of the following fields; information technology, engineering, or similar field
  • 5+ years relevant experience with data modeling experience including conceptual, logical and physical with experience in Big data technologies such as Spark, Data bricks is a plus
  • 7+ years of big data engineering experience
  • 5+ years cloud engineering experience with an emphasis on AWS and Azure technologies
  • Experience modeling big data systems
  • Experience creating data repositories support web applications and REST APIs.
  • Experience with high throughput, big volume, fast response time, scalable systems
  • Energy industry experience a plus
  • Experience with billing and or financial systems useful
  • 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.
    • English required, French a plus
  • Experience with Microsoft Office suite of products
  • Data modelling skills for OLTP and OLAP systems
  • Snowflake
  • Azure Data Factory
  • SQL Server expertise
  • Data lake construction with parquet
  • Experience with Python, Hadoop, and Spark helpful
  • Previous experience working in an Agile environment
  • Strong client relation skills, and ability to work effectively as a contributor in a technical team environment.
• Other
  • Passion to drive Engie Impact’s mission and values

  • At ENGIE,  our Goal is to  promote, and thrive on diversity, equity, and inclusion.  We do so for the benefit of our employees our goal is to support, customers, products and services, and community.  ENGIE is proud to be an equal opportunity workplace, and we are firmly committed to creating an equitable and inclusive environment for all employees.

    We are committed to providing employees with a work environment free of discrimination and harassment.  All employment decisions at ENGIE are based on business needs, job requirements, and individual qualifications.  ENGIE is committed to providing equal employment opportunities regardless of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship, age, sex or gender (including pregnancy, childbirth, and related medical conditions), gender identity, or gender expression (including transgender status), sexual orientation, marital status, civil union, or domestic partnership status, military service or veteran status, physical or mental disability, protected medical condition, genetic information, or any other legally protected category (referred to as “protected characteristics”) as defined by applicable federal, state or local law in the locations where we operate.

    The pay range for this role is: $ 40-60 hourly.

    Pay range is based on several factors and may vary in addition to a full range of medical, financial, and/or other benefits. Final salary and offer will be determined by the applicant’s background, experience, skills, internal equity, and alignment with geographical market data. This position is eligible for our comprehensive and competitive benefits package including medical, dental, vision, and basic life insurance. Additional ENGIE benefits include a 401k plan, paid time off and annual bonus. ENGIE complies with all federal, state, and local minimum wage laws.

     

WORK ENVIRONMENT:

• Work schedules are determined by business need and manager discretion; full time employment is considered 40 hours per week
• 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 rarely but may be required
• Business travel may be required up to 10% of the time

REQUIRED PHYSICAL ACTIVITIES:

• Extended Periods of Sitting: Ability to remain seated for long periods, with regular breaks as needed.
• Visual Acuity: Ability to view computer screens and read documents for extended periods.
• Frequent Use of Hands: Ability to use hands for typing, handling documents, and operating office equipment.
• Communication: Ability to effectively communicate, both verbally and in writing, through various mediums including phone, email, and video conferencing.
• Mobility: Ability to move within an office environment to access files, office machinery, and attend meetings.
• Reaching and Handling: Ability to reach, handle, and manipulate objects and equipment within an office or remote workspace.
• Occasional Lifting: Ability to lift and move items, such as files or office supplies, typically up to 10 pounds.
• Flexibility: Ability to perform tasks that may require bending, twisting, or standing briefly to access materials or equipment.
• Accommodations: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.