Power BI Developer W/ SharePoint // Back Fill

Location: Bloomfield Hills, MI
Date Posted: 10-24-2018
Power BI Developer W/ SharePoint // Back Fill
Bloomfield Hills, MI
Multi-Year Contract
Key Skills: Power BI, SQL Server, SharePoint and Business Intelligence.
Need Passport Number
Essential Duties will involve development and maintenance of Sharepoint environment, various SQL based
packaged and custom application and SSRS and excel based reports. Key skills required are expert level
development experience in SQL Server (Including T-SQL, SSRS, SSIS and SSAS), intermediate level knowledge of
Sharepoint development/administration (web parts, site definitions, libraries, PowerShell, etc.) and BI front end
tools (Performance Point Dashboards, power pivot, tableau, or any other reporting tool). Having administration
experience in Active Directory will be a big plus. The ideal candidate should have worked with a combination of these technologies for 4-6 years.
SQL Server:
·         Create data transformation packages to load data from various data sources to populate data-
·         warehouse using integration services (SSIS).
·         Write stored procedures and triggers pull data from SQL Server for reports and other processing.
·         Develop and Implement SQL Server Reporting Services Reports (SSRS
·         Develop and maintain cubes, dimensions and measures using Analysis Services (SSAS).
·         Knowledge of Sharepoint PowerShell, Central Administration, Service Applications, and site collection settings.
·         Design, develop, test, and deploy custom SharePoint web parts, custom features, Workflows.
·         Ability to create custom SharePoint site definitions (publishing, team sites, collaboration), Lists, Libraries, Content Types.
·         Experience in configuring all service applications (2013) and configuring Security.
·         Provide technical leadership and support for SharePoint sites/solutions development, site administration and user access.
·         Establish SharePoint governance and usage standards.
·         Give Training to users on processes and systems.
BI Reporting:
·         Create reporting dashboards in Performance Point, power pivot, or another similar package like Dundas
·         Dashboards, SAP BusinessObjects Xcelsius etc.
·         Create KPIs, Scorecards, and Reports for new measures.
·         Publish BI reports and dashboards through the SharePoint portal.
VBA - Excel/Access: PLUS
·         VBA and Excel Macro programming to develop applications for data collection and reporting.
·         Maintain existing VBA/SQL/Excel applications.
Active Directory Maintenance: PLUS
·         Able to administer user rights and access management.
·         Maintain Quest/Dell Quick Connect
916-646-2080 EXT 222
this job portal is powered by CATS