Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via email
We strive to be Your Future Your Solution to accelerate your career!
Contact Shawn Recker at or to learn more about this opportunity!
Summary:
We are looking for a Senior Data Engineer specializing in Supply Chain data within our Data and Analytics team. This is an exciting opportunity to help grow and modernize analytics in our organization! Individuals interested in this position will need strong communication skills with the ability to collaborate across all levels of the organization. You will be responsible for managing a team and simultaneous initiatives that require innovative problem-solving and technical expertise.
You will use tools such as Google Cloud Platform SQL Python Incorta Oracle Business Intelligence Tableau and Informatica ETL to engineer data pipelines and data models that enhance enterprise reporting and analytics. Additionally you will design and develop reports dashboards and visualizations using enterprise business intelligence tools (Oracle and Tableau).
Specific competencies include:
Data Structures and Models - Designs develops and scales the overall database/data warehouse structure based on functional and technical requirements. Designs develops and scales data collection frameworks for structured and unstructured data.
Data Pipelines and ELT - Designs applies and scales data extraction loading and transformation techniques in order to connect large data sets from a variety of sources.
Data Performance - In complete autonomy troubleshoots and fixes for data performance issues that come with querying and combining large volumes of data. Accounts for scaled performance in initial design.
Visualizations and Dashboards - Gathers requirements designs and develops reports dashboards and visualizations with multiple sources that meet business needs. Understands data and ideates ways for business to leverage data in innovative ways.
RESPONSIBILITIES:
**Works directly with the Sales and Marketing business unit to understand their analytics needs and gather requirements for analytics solutions
**Design and implement physical and logical data models for dimensions and facts across staging warehouse and semantic layers of enterprise data platforms.
**Develop and optimize SQL Python Incorta or Informatica ETLs and pipelines including Google BigQuery Dataprocs to ingest and transform data from diverse sources into dimensional models.
**Utilize SQL within Google BigQuery Informatica ETLs Incorta pipelines or Oracle SQL Views to derive metrics and dimension attributes.
**Engineer and orchestrate batch and mini-batch data loads into enterprise data platforms.
**Provide ongoing support and maintenance for existing Supply Chain data solutions within enterprise data warehouses.
**Use tools such as SQL Oracle Business Intelligence Tableau Google Cloud Platform Python Incorta and Informatica ETL to build robust data pipelines and models that support enterprise analytics.
**Design and develop dashboards and reports with intuitive user interfaces and optimized performance for Supply Chain operations.
QUALIFICATIONS:
Required
**A bachelors degree in Computer Science MIS or related area and significant experience with business intelligence data engineering and data modeling.
**Proven ability to gather detailed technical requirements to design and develop data structures supporting business intelligence report solutions from beginning to end.
**7 years of experience with reading and writing SQL.
**7 years of experience engineering within a data warehouse or related experience with dimensional data modeling.
**7 years of experience designing and developing ETLs/pipelines in Python Google BigQuery Dataprocs and/or Informatica ETL.
**Experience with Supply Chain data including logistics inventory procurement and manufacturing.
**Excellent written and verbal communication skills.
**Strong organizational and time management skills.
**Tested problem-solving and decision-making skills.
**A strong pattern of initiative.
**Highly developed interpersonal and leadership skills.
**Demonstrated success in leading cross-functional data projects.
**Must be a Citizen or National of the United States a lawful permanent resident or have authorization to work in the United States.
**Applicants must not now or in the future require sponsorship for an employment visa.
Preferred
**5 years of experience designing and developing within a business intelligence/reporting tool like Oracle Business Intelligence Tableau or Google Cloud Platform.
**Experience with data enablement for O9 Solutions.
**Familiarity with ERP systems and supply chain planning tools.
**Experience working within Google Cloud Platform with services like Dataflow Datafusion Pub/Sub Cloud SQL Cloud Storage
**Advanced Oracle SQL including advanced functions like analytical functions.
**Experience in tuning complex SQL and ETLs.
**Experience within a core metadata model (RPD) including the physical logical and presentation layers for the enterprise business intelligence platform (OBIEE Oracle Business Intelligence Enterprise Edition.)
Saige Partners one of the fastest growing technology and talent companies in the Midwest believes in people with a passion to help them succeed. We are in the business of helping professionals Build Careers Not Jobs. Saige Partners believes employees are the most valuable asset to building a thriving and successful company culture. Contact us to learn more about the opportunity below or check out other opportunities at Experience:
Senior IC
Full-Time