Talent.com
Data Analyst

Data Analyst

TechnoGenRaleigh, NC, United States
18 days ago
Job type
  • Full-time
Job description

Job Description :

Position : Data Analyst 740356

Location : Remote (Raleigh, NC)

Duration : 12 Months

Description :

Currently, the DEQ enterprise is a complex, multi-platform data environment. Technologies in use include Oracle, DB2, MySQL, and SQL Server, as well as desktop-based applications such as MS Access and MS Excel.

DEQ aims to establish an enterprise data model with a primary goal of standardizing shared data entities and attributes and a secondary goal of standardizing database management systems and tools. Related transactional databases and data warehouses will be hosted in Azure, generally using Microsoft Dataverse and SQL Server.

The Senior Data Analyst / Architect will provide analysis and leadership on data analysis projects across the DEQ enterprise. You will provide insight to other data analysts, data architects, and application developers related to creating an enterprise data model that meets DEQ's business and technical requirements. You will also provide subject matter expertise related to Microsoft Dataverse, SQL Server, Azure Data Factory, and SSIS.

Skill

Required / Desired

Amount

of Experience

Experience with Azure Data Factory as an ETL tool

Required

Years

Experience with MS Dataverse is Required

Required

Years

Experience with MS SSIS

Required

Years

Proven track record of solving real world problems using data. Excellent critical thinking skills is a must have for this role.

Required

Years

Bachelor's Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structu

Required

Years

Outstanding interpersonal and communication skills and experience collaborating and influencing across all levels of the organization.

Required

Years

Understanding of different database platforms : Oracle, SQL Server (On-Prem / Azure), DB2, and MS Access.

Required

Years

Excellent communication skills including written, verbal, and technology illustrations.

Required

Years

Understanding of Data Warehousing and data mining.

Required

Years

Understanding of modeling strategies (dimensional, snowflake, relational, unstructured).

Required

Years

Experience designing and delivering data mapping specifications for large reporting platforms. Writing and maintaining business rules using SQL logic

Required

Years