Data Engineer

02 Jul 2024

Vacancy expired!

; Description-

; Requisition Summary This role supports supply chain operations and is embedded within the North American Materials organization. They will work cross functionally with business users from various departments, divisions, and organizations on all phases of assigned projects and be responsible for integrating multiple heterogeneous data sources to build efficient, flexible, and scalable data warehouses and reporting solutions. Must be a be a motivated self-starter that can work independently in a fast-paced, ambiguous environment and have a passion for process improvement. This position can be located in Denton, TX., Renton, WA., Chillicothe, OH., or Ste-Therese QC



; Job Functions / Responsibilities Design, implement, and support data warehouse infrastructure using Snowflake, SQL Server, AWS cloud technology, Teradata, and multiple RDBMS engines.

Create ELT/ETL procedures to take data from various operational systems and integrate into a dimensional or star schema data model for analytics and reporting.Support Data Analysts and Research Scientist in analyzing usage data to derive new insights and fuel customer successUse business intelligence and visualization software (e.g., PowerBI, Tableau Server, Jupyter Notebooks, etc.) to empower non-technical, internal customers to drive their own analytics and reporting.Generates scripts for database deployment.Models physical/application data requirements in a data model tool, such as ERWin data modelerManages data models and related artifacts in a source safe repository such as TFS or GitHub.Analysis and Solution DevelopmentElicits functional & nonfunctional requirements through the use of interviews, workflow analysis, requirements workshops, and surveys to provide business process descriptions, business requirements, use cases, and user stories, with minimal supportDevelops analysis approach and applies various BA techniques with limited guidance from othersCollaborates with technical subject matter experts to identify potential technology/vendor solutions that may meet the business needs and defines pros/cons of each. ; Qualifications

Bachelors degree required. MCSE or related SQL certification preferred2-5 years relevant experience in data modeling and data architect ; Skills Required

Expertise with SQL and relational database systems

Knowledge of data warehousing conceptsExperience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasetsExperience in modeling logical/business data requirements in a data model tool, such as ERWin data modeler.Experience in generating scripts for physical database deployment.Proficiency with ETL tools and techniques.Knowledge of more than one database platform, such as Azure, SQL Server, Snowflake, Oracle and Teradata.Must have knowledge of data normalization and de-normalization techniquesExcellent interpersonal and organizational skills, including active listening, problem solving when under pressure, and facilitation.Strong troubleshooting and problem solving skills.Machine learning model experience a plus.Familiarity with Python, C#, and/or other programming languages.Familiar with project management methodologyFamiliar Lean/Six Sigma ; Education: Bachelors Degree

; Additional client information:

  • ID: #43768997
  • State: Texas Denton 76201 Denton USA
  • City: Denton
  • Salary: DOE
  • Job type: Permanent
  • Showed: 2022-07-02
  • Deadline: 2022-08-31
  • Category: Et cetera