3Core Systems Inc
Azure Data Modeler
3Core Systems Inc, Deerfield Beach, Florida, United States, 33441
Deerfield Beach, United States
| Posted on 08/23/2024The role's primary focus is to support our Cognos to Power BI Conversion project that's underway which uses data in our Azure Synapse (dedicated SQL pool) warehouse. The data in Synapse is raw, flattened, and has minimal curation. We need to build a semantic layer to support the Power BI solutions that need to be created. Another team is delivering a logical data model to our team, and we need an Azure Data Modeler to convert that to a physical data model.The Data Modeler will be responsible for developing and maintaining the physical model and will partner closely with the team who will deliver the logical model (and potentially provide feedback).Knowledge of Power BI architecture will be helpful to understand performance implications.We don't have an in-house data modeling tool at this time but are exploring tools to procure. Candidate needs Dimensional Data Modeling experience.The Data Modeler will need advanced SQL skills to conduct data analysis. Azure Data Factory knowledge may be helpful as well.Skill set
Business Strategy, Financials, Mergers & Acquisitions, Strategy Consulting, Corporate Strategy, Collecting Data & Documentation, Strategy and Presentations, Building Presentation Materials, Excel and PowerPoint, Analyzing Data/Financials.
#J-18808-Ljbffr
| Posted on 08/23/2024The role's primary focus is to support our Cognos to Power BI Conversion project that's underway which uses data in our Azure Synapse (dedicated SQL pool) warehouse. The data in Synapse is raw, flattened, and has minimal curation. We need to build a semantic layer to support the Power BI solutions that need to be created. Another team is delivering a logical data model to our team, and we need an Azure Data Modeler to convert that to a physical data model.The Data Modeler will be responsible for developing and maintaining the physical model and will partner closely with the team who will deliver the logical model (and potentially provide feedback).Knowledge of Power BI architecture will be helpful to understand performance implications.We don't have an in-house data modeling tool at this time but are exploring tools to procure. Candidate needs Dimensional Data Modeling experience.The Data Modeler will need advanced SQL skills to conduct data analysis. Azure Data Factory knowledge may be helpful as well.Skill set
Business Strategy, Financials, Mergers & Acquisitions, Strategy Consulting, Corporate Strategy, Collecting Data & Documentation, Strategy and Presentations, Building Presentation Materials, Excel and PowerPoint, Analyzing Data/Financials.
#J-18808-Ljbffr