Client is looking to implement a new comprehensive child welfare information system (CCWIS) and needs a senior Power BI/SQL Developer to design and develop reports using PowerBI and create complex SQL queries.
Requirements
- Hands on Report Development and SQL Query
- Hands-on skill developing complex reports using PowerBI
- Azure Data Services Experience
- PL/SQL hands on experience
- BUSINESS INTELLIGENCE (CLOUD BASE)
- Software Development Lifecycle experience
- MS Office/PowerPoint experience
Responsibilities
- Conduct analysis of data maintained in multiple different sources and identify processes to validate the information.
- Gather and translate business requirements into detailed, production-level technical specifications, creating robust data models, data analysis features and enhancements.
- Collect requirements for reports from program staff, prototype reports and work with other vendors to deploy reports using the client 365Dynamics platform.
- Write complex data joins to establish data measures across multiple tables.
- Modify existing reports and/or develop new reports by analyzing databases, data sources, and structures for the benefit of Users. Perform QA analysis on reports for accuracy and reports meets the intended business needs.
- Manage Azure Data Services including Synapse/Synapse Links, Azure SQL Pool, Data lake
- Deployment of reports
Other
- Bachelor’s degree in IT or related field or equivalent experience
- Excellent communication skills, both written and verbal
- Flexible work from home options available
- 11-15 yrs. experience
- Agile Process Environment experience
