Data Analyst - MS Dataverse 8-11

Focused HR Solutions; Raleigh (NC); Remote; USD 80,000 - 110,000; Full time

Job summary

Focused HR Solutions is seeking a Data Analyst experienced in Microsoft Dataverse and Azure Data Factory for a long-term remote role. This position involves providing crucial analysis and leading efforts to establish an enterprise data model in a complex technology environment. Ideal candidates will possess outstanding communication skills, a solid foundation in data analysis, and experience with various database systems. This opportunity offers the chance to work on significant data projects while collaborating with diverse teams.

Qualifications

• Experience with MS Dataverse, SQL Server, Azure Data Factory and SSIS required.
• Strong analytic and problem-solving skills are essential.
• Bachelor's degree or equivalent in a technology-related field.

Responsibilities

• Provide analysis and leadership on data analysis projects.
• Collaborate with other analysts, architects, and developers.
• Help create an enterprise data model to meet business requirements.

Skills

Communication Skills

Critical Thinking

Technical Data Stewardship

Ad-hoc SQL

Data Warehousing

Data Mapping Specifications

Education

Bachelor’s Degree in Computer Science, Engineering, or similar

Tools

Azure Data Factory

MS Dataverse

MS SSIS

Power BI

Job description

Position Overview:

• Candidates will be allowed to work remotely. Candidate must work EST Business Hours.
• Our direct client has an opening for a Data Analyst w/ MS Dataverse Exp position # 686457.
• This position is for 12+ months, with the option of extension, and will be worked remotely must work EST business hours).

If you are interested, please submit the following:

• YOUR CURRENT RESUME

Below is the job description – Resumes due ASAP –

Description:

• Currently, the client 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 client’s 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/Desired Skills:

• Outstanding interpersonal and communication skills and experience collaborating and influencing across all levels of the organization. - Required - 3 Years
• Experience with Azure Data Factory as an ETL tool - Required - 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 structures – Required – 3 Years
• Experience with MS Dataverse – Required - 3 Years
• Experience with MS SSIS - Required - 3 Years
• Proven track record of solving real world problems using data. Excellent critical thinking skills is a must have for this role. - Required - 3 Years
• Understanding of different database platforms: Oracle, SQL Server (On-Prem / Azure), DB2, and MS Access. - Required - 3 Years
• Excellent communication skills including written, verbal, and technology illustrations. - Required - 3 Years
• Understanding of Data Warehousing and data mining. - Required - 3 Years
• Understanding of modeling strategies (dimensional, snowflake, relational, unstructured). - Required - 3 Years
• Experience designing and delivering data mapping specifications for large reporting platforms. Writing and maintaining business rules using SQL logic - Required - 3 Years
• Demonstrated experience in writing ad-hoc SQL statements - Required - 3 Years
• Strong interest in playing a technical data steward role across our business and technology partners to understand and detail our data, appropriate - Required - 3 Years
• Proven experience with ERD/Data Modelling tools (Toad or others). - Required - 3 Years
• Experience in executing projects in an Agile / Hybrid environment - Required - 3 Years
• Demonstrated technical ability in learning new technologies and adapting to frequent changes in the technical environment - Required - 3 Years
• Experience with data reporting tools (Power BI, others) - Required - 3 Years

By replying to this job advertisement, I agree I want to receive additional job advertisements from Focused HR Solutions, including email, phone and mail to the contact information I am submitting. I consent to Focused HR Solutions, its affiliates, third parties and partners processing my personal data for these purposes and as described in the Privacy Policy. I understand that I can withdraw my consent at anytime.

FHR