- Power BI
- Microsoft SQL Server
The Business Intelligence developer will architect, develop, implement and maintain business intelligence, data warehouse and analytics solutions using the Microsoft technology stack. They may design and develop ETL (Extract, Transform, Load) routines, perform data profiling and data cleansing and create BI dashboards and reports. They will work within application development teams to integrate analytic solutions into enterprise applications following an Agile development methodology.
At least 3 years of experience designing and implementing data warehouses and multidimensional database solutions
Experience with analytical, report and dashboard creation using Power BI
Experience developing ETL solutions for BI / DW environments
Strong experience with relational and multidimensional database platforms
Knowledge of data warehouse philosophies such as the Kimball Method
Familiarity with cloud data warehouse software and tools included in platforms such as Microsoft Azure or Amazon Web Services
Knowledge of COTS (Commercial off the Shelf) software as data sources such as Microsoft SharePoint or Microsoft Dynamics CRM are a plus
Experience with multidimensional query languages including MDX or DAX are strongly desired.
Experience supporting Federal Government Customers
Active Federal Government Public Trust clearance
Microsoft certifications Experience with SSIS or other ETL tools.