Remote Data Analyst II: ETL & Data Modeling

The Fountain Group; East Hanover (NJ); On-site; USD 52,000 - 56,000; Full time

Benefits offered by this job

Health insurance

Vision insurance

Dental insurance

Life insurance

Disability insurance

Job summary

The Fountain Group is seeking a data engineer/analyst to analyze business requirements and design robust data models and pipelines. You will work with Product Owners, BI Developers, and Business Leads to gather requirements, write acceptance criteria, and develop tests for analytical products.

Responsibilities include building and validating transport/data pipelines, maintaining data models, and ensuring data quality for reporting and analytics.

Qualifications

• Bachelor’s degree in CS/IS or related field.
• 1+ year Data Engineering/Modeling experience.
• 3+ years Database Design experience.
• Strong SQL and ETL experience with data pipelines.
• Familiarity with SAP and multiple data sources.

Responsibilities

• Analyze business requirements to guide data modeling and maintain data structures and metadata.
• Partner with Product Owners and BI teams to gather requirements and document acceptance criteria.
• Develop UAT and SIT test cases based on analytical data product requirements.
• Support scoping, building, testing, and maintaining data pipelines and datasets for use cases.
• Create and maintain data models, reconciling multiple source models into a single logical view.
• Assess data source structure, reliability, and quality for continuous improvement.
• Participate in data governance to document data usage for reusability.

Skills

SQL

Alteryx

Backlog management

Data modeling

ETL

Education

Bachelor's degree in CS/IS

Tools

Databricks

Google Cloud Dataproc

PySpark

Python

Job description

The Fountain Group is seeking a data engineer/analyst to analyze business requirements and design robust data models and pipelines. You will work with Product Owners, BI Developers, and Business Leads to gather requirements, write acceptance criteria, and develop tests for analytical products.

Responsibilities include building and validating transport/data pipelines, maintaining data models, and ensuring data quality for reporting and analytics.