Analysis Skills, Business Processes, Business Solutions, Data Analysis, Data Mart, Data Modeling, Debugging Skills, Dimensional Modeling, Microsoft SQL Server, Performance Tuning/Optimization, Power BI, Reporting Dashboards, Reporting Skills, SQL (Structured Query Language), SQL Server Analysis Services (SSAS), Systems Analysis, Test Plan/Schedule, United States Department of Energy (DOE)
Position: Power BI Data Modeler
Location: Jupiter, FL
Duration: Contract
Rate: DOE
(USC and GC Holders are only preferred)
Must-have skills:
Power BI Data Modelling
SQL Server Analysis Services (SSAS)
AWS
DAX
PREFERRED: DataMart, Experience in Cube and Energy
Requirements:
Availability to work 100% on Client's site in Jupiter, FL (required);
Experience with Power BI Data Modelling;
Experience customizing, building data model regions;
Experience in Cube by creating Actions, Perspective, and Hierarchies using SQL Server; Analysis Services (SSAS) and Dimensional/Tabular Modeling Techniques;
Experience in developing reports, visualizations, dashboards;
Experience with DAX (Data Analysis Expressions);
Experience in performance tuning of long-running SQL queries using SQL server built-in tools like SQL Server profiler, Execution plan and creating indexes;
Experience with Power BI Incremental refresh;
Experience with DataMart (preferred);
Experience working in energy industry (preferred)
Responsibilities :
Be responsible for the development and integration of new or existing applications into the technical infrastructure and existing business processes;
Provide technical or functional guidance to project or work teams as needed within a specific discipline;
Collaborates on an on-going basis with the Business Systems Analyst. Analyzes, designs, develops, tests, debugs, implements, maintains and/or enhances existing or new systems that are reliable and efficient.