What are the responsibilities and job description for the Business Intelligence Developer Senior position at AHU Technologies Inc?
Job Description:
Short Description:
Client is looking for a senior Power BI/SQL Developers with extensive experience in designing and developing reports using PowerBI and creating complex SQL queries.
Complete Description:
The Developer will be a member of the DevOps team that will be implementing a new comprehensive child welfare information system (CCWIS). The candidate must have excellent communication skills, both written and verbal. The candidate will work closely with social workers and system developers to identify contributing factors to data quality issues and design processes to eliminate them. The candidate will also be a critical resource for overseeing data conversion from the legacy system to its new system according to the project schedule.
Responsibilities:
• Conduct analysis of data maintained in multiple different sources and identify processes to validate the information.
• Coordinate the client data management governance structure, perform required analysis task and support client staff in implementing recommendations.
• 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
Minimum Education/Certification Requirements:
Bachelor’s degree in IT or related field or equivalent experience
The Developer will be a member of the DevOps team that will be implementing a new comprehensive child welfare information system (CCWIS). The candidate must have excellent communication skills, both written and verbal. The candidate will work closely with social workers and system developers to identify contributing factors to data quality issues and design processes to eliminate them. The candidate will also be a critical resource for overseeing data conversion from the legacy system to its new system according to the project schedule.
Responsibilities:
• Conduct analysis of data maintained in multiple different sources and identify processes to validate the information.
• Coordinate the client data management governance structure, perform required analysis task and support client staff in implementing recommendations.
• 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
Minimum Education/Certification Requirements:
Bachelor’s degree in IT or related field or equivalent experience
Skills Matrix
· Bachelor’s degree in IT or related field or equivalent experience
· Hands on Report Development and SQL Query
· Software Development Lifecycle experience
· 11-15 yrs. MS Office/PowerPoint experience
· Hands-on skill developing complex reports using PowerBI
· Azure Data Services Experience
· Agile Process Environment
· PL/SQL hands on experience
· BUSINESS INTELLIGENCE (CLOUD BASE)
Flexible work from home options available.
Salary : $66 - $74