Overview
On Site
Full Time
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Skills
Employment Authorization
Data Modeling
Requirements Elicitation
Data Marts
Clarity
SQL
Data Profiling
Cloud Computing
Extract
Transform
Load
ADF
Data Analysis
Database
Microsoft Azure
Dimensional Modeling
Star Schema
Snow Flake Schema
OLAP
OLTP
Data Warehouse
Customer Facing
Communication
Presentations
Agile
SANS
Design Patterns
Semantics
Machine Learning (ML)
Job Details
Hiring: W2 Candidates Only
Visa: Open to any visa type with valid work authorization in the USA
Responsibilities
- Define, review and document data modeling and design standards
- Experienced in gathering requirements from Business users for creating and modifying existing Data marts and Reports for various Projects and Departments.
- Engage with business and technology stakeholders to gather the required information, understand the client expectations, get clarity through workshops, suggest/deliberate on the right data models that meet business requirements.
- Ability to write complex SQL statements to validate data profiling and transformations.
- Provide subject matter as a Data Modeler to resolve and address business issues and priorities
- Designing enterprise data models on cloud (Azure) including services like ETL pipelines, ADF, Synapse etc.
Job Description -
- 9+ years of experience delivering data and data analytics solutions in Azure Ecosystem
- 8+ years of experience in building OLTP and OLAP database models
- Strong work experience as a Data Modeler working in Azure Ecosystem.
- Expertise in Ralph Kimball/Inmon Dimensional Data Modeling, Star schema, Snow-Flake schema, creation of Fact and Dimension Tables, OLAP, OLTP and thorough understanding of Data-Warehousing concepts.
- Good experience of implementing Enterprise data models on a Data Medallion architecture
- Experienced in performing customer-facing roles
- Good communication and presentation skills and ability to understand the business priorities and how Technology can support these initiatives.
- Understanding of the Agile based development and execution approach
- Well versed with data consumption design patterns like semantic layers, visualizations, ML models, Data Medallion and Data-mesh architectures.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.