Data LakeHouse Specialist - Easton, United States - AB2 Consulting, Inc.

Description

Job Description

Data LakeHouse Specialist

Position Type: Full-Time

Location: Easton PA (2 days a week in office)

Work Authorization: USC/GC

PRINCIPAL DUTIES & RESPONSIBILITIES:

• Experience designing and implementing a Data LakeHouse.
• Ensure data quality and accuracy by implementing validation checks and error-handling mechanisms.
• Experience designing and implementing BI data visualizations and interactive dashboards using Microsoft Power BI.
• Familiarity with SAP and SAP data in a manufacturing setting.
• Participate in the design and development of the data LakeHouse, as well as creation of user and SOP documentation.
• Experience with IDMC Catalog and Data Governance a plus.

JOB SPECIFICATIONS:

• Bachelor's degree in computer science, information systems field with 3+ years of experience working with Data LakeHouses.
• Understand and perform basic Snowflake DBA functionality including but not limited to
  • Stored Procedures,
  • JavaScript
  • User Defined Functions
  • Stages
  • Data Pipelines
  • Strong data modeling skills (normalized and multidimensional).
• Understanding of business data and its various sources including but not limited to SAP, both ECC and S4/Hana
• Understanding of database technologies and data warehouse methodologies.
• Strong business and communication skills.
• Ability to present ideas in user-friendly language.
• Maintain a high level of customer service to both internal and external clients.
• Must exhibit proficiency in using Microsoft Office Suite.
• Must have excellent problem-solving and analytical skills.
• High initiative and ability to prioritize in a high-pressure environment.
• Must be able to work on simultaneous projects.