Data Analyst - Database Design

Stefanini North America and APAC; East Hanover (PA); Hybrid; USD 80,000 - 120,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

Stefanini Group in East Hanover, NJ is seeking a Data Analyst – Database Design with 1+ year in data engineering and 3+ years in database design. Hybrid work arrangement in a collaborative environment using SQL, Python, and data modeling to deliver scalable data products.

You will partner with product owners, BI developers and business leads to design data models, build ETL pipelines, and ensure data quality across sources, dashboards, and reports.

Qualifications

• 1+ years Data Engineering/Modeling.
• 3+ years Database Design.
• Bachelor's degree in a related field.

Responsibilities

• Partner with MDS, BI Developers and Business Leads to gather requirements and drive improvements.
• Develop UAT/SIT test cases based on data product requirements.
• Support scoping, building, testing, and maintaining data pipelines and data models.
• Analyze data sources for integrity and drive continuous improvement.
• Document data governance processes for reusability.

Skills

SQL

Alteryx

Data Modeling

ETL

Python

Power BI

Education

Bachelor's degree

Tools

Azure

Databricks

Power BI

Tableau

Snowflake

Job description

Job Title & Location

Stefanini Group is hiring!

Stefanini is looking for a Data Analyst - Database Design in East Hanover, NJ (Hybrid)

Call: 248-728-6420 / Email: [e-mail]

Open for W2 candidates only!

Work Location

Hybrid: 100 Deforest Ave., East Hanover, NJ 07936

Work Schedule

Monday to Friday, 8:00 AM - 5:00PM (40 hours per week)

Description

Leverage analysis design techniques to solve business problems using information technology to operationalize data and analytical models to drive long-term business results.

You Will

• Partner with MDS in providing accessibility, retrievability, security and protection of data in an ethical manner.
• Partner with Product Owners, BI Developers and Business Leads to conduct business requirement gathering & continuous improvement sessions to support the business and understand requirements for analytical projects and develop necessary requirement documents and acceptance criteria to support their development in line with process guidelines
• Develop UAT (User Acceptance Testing) and SIT (System Integration Testing) test cases based off analytical data product requirements.
• Support for scoping, building, testing, and maintaining transport/data pipelines and retrieving applicable data sets for specific use cases.
• Support building, testing, and maintaining data models with the flexibility to change when business requirements change, while also reconciling multiple logical source models into a single, logically consistent model.
• Analyze the structure, format, and reliability of new and existing data sources, considering factors such as data integrity, completeness, accuracy, and drive continuous improvement.
• Participate in data governance processes to ensure data is properly maintained and document for reusability by the business
• Understand data and metadata to support consistency of information retrieval, combination, analysis, pattern recognition and interpretation.

What You Will Bring

• Understanding of Data Engineering concepts within a business setting, including working with multiple systems such as SAP, internal and external data sources. Experience in developing, enhancing, testing, and maintaining data products.
• Experience in using diverse range of languages and tools, including scripting languages, for data extraction, transformation, storage, processing, and integration.
• Analyze business requirements as a guide for data modeling and apply data analysis, design, modeling, and quality assurance techniques, continuous improvement, based on a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions).
• Ability to simplify complex problems and effectively communicating technical concepts to a diverse audience.

More about this role

• Key Skills: Strong hands-on SQL and Alteryx experience is essential
• Process Analysis & Documentation: Ability to analyze existing processes, identify gaps, and document business/technical requirements
• Backlog Management: Experience breaking down data processes into actionable backlog items and working with Product Owners in ADO
• ETL & Data Model Remediation: Ability to assess and identify remediation needs across ETL pipelines, reporting layers, and data models
• Location/Work Hours: Candidates must be available during Eastern Time (ET) business hours

What Extra Ingredients Will You Bring

• Cloud computing technologies (Azure, GCP)
• Programming Languages: SQL, Python, PySpark (Apache Spark), DAX, etc.
• Analytics platforms: Databricks, Google Cloud Dataproc, etc.
• Experience with CI/CD, DevOps, and DataOps techniques.
• Experience with ETL, Data pipelines and architecture
• Technical Documentation
• Experience in data modelling and wrangling techniques and tools i.e., Star Schema, Snowflake Schema, Data vault, Alteryx, Power BI, Tableau, etc.
• Data quality and profiling methods

Education / Certifications

• Bachelor's degree in a related field. BS Computer Science, Information Systems, etc.

Job Specific Requirements

• 1+ years Data Engineering/Modeling
• 3+ years Database Design

Salary

Listed salary ranges may vary based on experience, qualifications, and local market.

Company Overview

Stefanini takes pride in hiring top talent and developing relationships with our future employees. Our talent acquisition teams will never make an offer of employment without having a phone conversation with you. Those face‑to‑face conversations will involve a description of the job for which you have applied. We also speak with you about the process including interviews and job offers.

The Stefanini Group is a global provider of offshore, onshore, and nearshore outsourcing, IT digital consulting, systems integration, application, and strategic staffing services to Fortune 1000 enterprises around the world. Our presence is in countries like the Americas, Europe, Africa, and Asia, and more than four hundred clients across a broad spectrum of markets, including financial services, manufacturing, telecommunications, chemical services, technology, public sector, and utilities. Stefanini is a CMM level 5, IT consulting company with a global presence. We are a CMM Level 5 company.