Crescens
Crescens is hiring: Data Analyst/Architect in Raleigh
Crescens, Raleigh, NC, United States, 27601
Job Title: Data Analyst/Architect
Location: Raleigh, NC
Duration: 12 Months
Job Description:
Required Skills:
Location: Raleigh, NC
Duration: 12 Months
Job 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.
Required Skills:
- Outstanding interpersonal and communication skills and experience collaborating and influencing across all levels of the organization.
- Experience with Azure Data Factory as an ETL tool
- Bachelor's Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structu
- Experience with MS Dataverse is Required
- Experience with MS SSIS
- Proven track record of solving real world problems using data. Excellent critical thinking skills is a must have for this role.
- Understanding of different database platforms: Oracle, SQL Server (On-Prem / Azure), DB2, and MS Access. Cc
- Excellent communication skills including written, verbal, and technology illustrations.
- Understanding of Data Warehousing and data mining.
- Understanding of modeling strategies (dimensional, snowflake, relational, unstructured).
- Experience designing and delivering data mapping specifications for large reporting platforms. Writing and maintaining business rules using SQL logic
- Demonstrated experience in writing ad-hoc SQL statements
- Strong interest in playing a technical data steward role across our business and technology partners to understand and detail our data, appropriate
- Proven experience with ERD/Data Modelling tools (Toad or others).
- Experience in executing projects in an Agile / Hybrid environment
- Demonstrated technical ability in learning new technologies and adapting to frequent changes in the technical environment
- Experience with data reporting tools (Power BI, others)