Power BI Developer

Job Description: • We utilize the Microsoft BI stack and Tableau as the primary platforms and systems. • The scope of services required for the Business Intelligence developer includes: • Design, create, deploy, and maintain data warehouse and business intelligence solutions • Develop data modeling, ETL solutions, and BI/analytical content using Microsoft SQL Server BI stack (SSRS/SSMS/SSIS), Excel, Tableau. • Respond to ad-hoc data requests for information by writing complex T-SQL. • Collaborate with technical and non-technical stakeholders to solve complex business problems, by gathering requirements, prototyping and testing, or enhancing existing solutions to meet new requirements • This position requires strong technical skills (such as data development, creation of dashboard/reports) and soft skills (such as communication and business knowledge). • Consultant needs to understand how to develop star-schema DataMart’s, optimize data retrieval, and how to develop dashboards, reports and other visualizations for stakeholders. • Develops data platforms to increase data access across the organization. • Provides dashboards/reports for stakeholders to enhance the services we provide clients. • Develops reporting that is integrated into case management systems to provide enhanced intelligence to field staff. • Evaluates process and program performance through research studies that rely heavily on data and statistical analysis. Minimum Qualifications • The minimum skills and experience levels required for a candidate to be considered for this position include: • Minimum of 5 years’ experience in gathering and analyzing business requirements • Thorough understanding of data warehousing concepts, Star Schema design, and slowly changing dimensions • Minimum of 5 years’ experience assembling and validating large datasets for research/analysis • Minimum of 9 years’ experience with MS SQL Server, including SQL programming and scripting • Minimum of 5 years’ experience working with data in Excel • Minimum of 9 years’ experience as a database developer • Minimum of 9 years’ experience designing, troubleshooting and maintaining SSIS packages and Agent jobs. • Minimum of 9 years’ experience designing, troubleshooting and maintaining SSRS reports and dashboards. • Minimum of 2 years’ hands-on experience working in Tableau or equivalent (Tableau certification preferred). • Collaborate with cross-functional teams to ensure data accuracy and usability. • Ability to work with staff of varying skill levels, both technical and non-technical . • Strong communications skills including written, verbal, presentation and interpersonal . • Microsoft BI stack or Tableau certification is preferred.