Data LakeHouse Specialist

Position Type: Full-Time

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

Work Authorization: USC/GC

Salary: $95,000 per year with full benefits + 6% yearly bonus (depends on company performance)

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.

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.