Data Analyst

Ascii Group, LLC

Cary, NC, United States

3 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Starter

Experience required

1 year minimum

Compensation

$104,000.0

Working hours

Regular working hours

Job source

dice.com

Tech stack

Data Analysis Big Data Profiling Data Auditing Data Governance Data Integration Extract Transform Load (ETL) Data Warehousing Distributed Systems High-Level Architecture Microsoft SQL Server Oracle (Applications)

+6 more

Reference Data Standard Sql Unstructured Data Information Technology Data Lineage Data Management

Job description

· Analyze the data in depth, using SQLs and other exploratory tools against various platforms such as Bigdata, Oracle, SQL Server and others.
· Convert business requirements to functional requirements, with detailed transformation rules for ETL team. This is a very technical hands-on role.
· Work closely with the ETL and data science teams to review the requirements and data integrations.
· Understand the requirements from Business and Data Science. Understand the business and business impact on use cases.
· Write validation scripts to validate the data loaded by ETL team.
· Work with IT and business customers to develop and design requirements to formulate technical design.
· Skills to understand the right functional domain knowledge of the business to be able to gather right requirements for the design.
· Capture meta data, data lineage, reference data management and data quality rules as part of data governance.
· Work with team spread across the globe in driving the delivery of projects.

Requirements

· Bachelor’’s degree in computer science, Engineering, or related discipline.
· 5+ years of solutions development experience, including 1-2 years in data management/engineering organization.
· Proficient understanding of distributed computing principles.
· Extensive experience in data analysis and data modeling (table design).
· Proficiency in SQLs and data exploratory tools.
· Extensive experience writing functional requirements and high-level design documents.
· Experience in writing validation scripts to validate the data, data integrations and ETL transformations.
· Analytical skills to analyze situations and come to optimal and efficient solution based on requirements.
· Strong data analysis and profiling skills.
· Data warehouse concepts.
· Strong analytical skills related to working with unstructured datasets.
· SQL knowledge and data analysis skills for data anomaly detection and data quality assurance.
· Excellent communication skills, both written and verbal