DataStaff, Inc. is seeking a Senior Data Analyst /Architect for a long-term contract opportunity with one of our direct clients in Raleigh, NC
This position is remote. Equipment can be shipped to the candidate.
Responsibilities:
- 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.
- Provide analysis and leadership on data analysis projects across the enterprise.
- Provide insight to other data analysts, data architects, and application developers related to creating an enterprise data model that meets the business and technical requirements.
- Provide subject matter expertise related to Microsoft Dataverse, SQL Server, Azure Data Factory, and SSIS.
- Technologies in use include Oracle, DB2, MySQL, and SQL Server, as well as desktop-based applications such as MS Access and MS Excel
Required Skills:
- 3 Years – Experience with Azure Data Factory as an ETL tool
- 3 Years - Experience with MS Dataverse is Required
- 3 Years – Experience with MS SSIS
- 3 Years – Proven track record of solving real world problems using data. Excellent critical thinking skills is a must have for this role.
- 3 Years – Bachelor’s Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structure
- 3 Years – Outstanding interpersonal and communication skills and experience collaborating and influencing across all levels of the organization.
- 3 Years – Understanding of different database platforms: Oracle, SQL Server (On-Prem / Azure), DB2, and MS Access.
- 3 Years – Excellent communication skills including written, verbal, and technology illustrations.
- 3 Years – Understanding of Data Warehousing and data mining.
- 3 Years – Understanding of modeling strategies (dimensional, snowflake, relational, unstructured).
- 3 Years – Experience designing and delivering data mapping specifications for large reporting platforms. Writing and maintaining business rules using SQL logic
- 3 Years – Demonstrated experience in writing ad-hoc SQL statements
- 3 Years – Strong interest in playing a technical data steward role across our business and technology partners to understand and detail our data, appropriate
- 3 Years – Proven experience with ERD/Data Modelling tools (Toad or others).
- 3 Years – Experience in executing projects in an Agile / Hybrid environment
- 3 Years – Ability to challenge the legacy design and seek opportunities to design better models and better code.
- 3 Years – Demonstrated technical ability in learning new technologies and adapting to frequent changes in the technical environment
- 3 Years – Experience with data reporting tools (Power BI, others)
- 3 Years – Ability to look at data in various formats, organize data for the agency to meet the needs of unique program areas and enable the programs to effect
- 3 Years – Experience conceptualizing and visualizing data structures before they are drawn.
- 3 Years – Experience migrating data from various legacy platforms
This opportunity is available on a corp-to-corp basis or as a W2 position with a competitive benefits package. DataStaff, Inc. offers medical, dental, and vision coverage options as well as paid vacation, sick, and holiday leave. As many of our opportunities are long-term, we also have a 401k program available for employees after 6 months.