MS Power BI Developer

In this position qualified candidates will be able to design and develop highly customized MS Power BI reporting solutions for our clients. These applications use very large amounts of data and therefore require in depth optimization skills to ensure excellent performance. Our applications require extensive and complex set analysis logic as well as creativity to meet our users’ exacting requirements. This role will also be required to gather client requirements and write technical BI requirements for a variety of Health Care BI projects. Other responsibilities will include data analysis, requiring strong SQL skills to analyze the quality of the source data to ensure correct modeling and ETL work. Data sources will include Workday, PeopleSoft, Oracle, SQL Server and potentially other databases. Role and Responsibilities

• Design, build and deploy reporting solutions utilizing MS Power BI
• Maintain and support data analytics platforms
• Create visualizations and reports for requested projects
• Interviews end users to determine requirements for data, reports, analyses, metadata, training, service levels, data quality and performance
• Cleary define and document end user requirements
• Provide design advice and user interface advice for optimum performance
• Design and build reports for customer distribution
• Provide data analysis and deliver application to database validation
• Provide customer training
• Strong data analysis and problem solving skills
• Ability to use SQL to analyze source data
• Ability to use SQL to test/verify the ETL work
• Respond to client requests and inquiries, as appropriate
• Execute and Verify testing
• Resolve testing issues and correct defects
• Document any testing issues and resolutions
• Adhere to methodology and process standards
• Ensure systems meet functional and technical standards
• Identify improvements for processes, standards, deliverables, etc.
• Escalate issues when required
• Provide status updates as warranted, once per week

• 2+ years experience as a MS Power BI Developer
• 2+ years with Workday or PeopleSoft preferred
• Proven experience as a BI Developer or Data Scientist
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Background in data warehouse design (e.g. dimensional modeling) and data mining
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Must have strong analytical, troubleshooting, and problem solving abilities in a data warehouse environment
• Experience interacting with business users
• Demonstrated experience with software application lifecycle methods, processes and tools
• Proven ability to cultivate and maintain client relationships
• Proven abilities to take initiative and be innovative
• Health Care experience is preferred
• BS/BA in Computer Science, Engineering or relevant field
• Excellent oral and written communication skills