Data Analyst II #26-21265

Us Tech Solutions; East Hanover (NJ); On-site; USD 48,000 - 56,000; Full time

Job summary

US Tech Solutions in East Hanover, NJ is seeking a data engineer for a 3-month contract to design and operationalize data and analytic models for long-term business results.

You will partner with MDS, Product Owners and BI developers to gather requirements, build data pipelines, and develop data models while ensuring quality, governance and security across the analytics stack.

Qualifications

• Bachelor’s degree in a related field (CS/IS).
• Experience with data engineering concepts and modeling.
• Ability to work with SAP, pipes and data integration tools.

Responsibilities

• Leverage analysis design techniques to solve business problems with IT.
• Partner to provide accessibility, retrievability, security and data protection.
• Gather requirements with Product Owners, BI Developers and Business Leads.
• Develop UAT/SIT test cases from data product requirements.
• Support scoping, building, testing, and maintaining data pipelines.
• Analyze data sources for integrity, accuracy and improvements.
• Contribute to data governance and metadata management.
• Understand data and metadata for consistent retrieval and analysis.

Skills

Data engineering concepts

Data modeling

SQL

Python scripting

Communication

Education

Bachelor's degree

Tools

SAP

Databricks

Dataproc

Power BI

Tableau

CI/CD

DevOps

ETL

Alteryx

PySpark

Job description

$35-$41 per hour

East Hanover, NJ

Contract

Duration: 3 Months Contract with Possible Extension

Job Description

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


• Partner with MDS in providing accessibility, retrievability, security and protection of data in an ethical manner.


• Parter 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.

Experience

• 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

• 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

US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

AI Statement:

By applying, you acknowledge that AI-assisted tools may be used during hiring.