Business Intelligence Developer

Responsibilities:

• Creates processes and leads projects / initiatives aimed at developing new data solutions / Operational Data Store.
• Build methods to gather, process, analyze, and publish BI data from multiple sources using Microsoft SQL Server Integrated Services  via Visual Studios Data Tools; Relational Databases and complex T-SQL Language.
• Build ETL processes to convert pre-defined data solutions  into Data Marts for the enhancement of CCP’s Enterprise Data Warehouse using the Kimball methodology  and Go Live Support
• Provides post-Go Live support to proactively identify data quality issues, coordinate root cause analysis, implement required fixes, and perform QA validations to build exception reporting where needed
• Mentors Business Intelligence team to develop an understanding of all stages of project development cycle to identify potential automation solutions to current time intensive process
• Collaborates with Report Developers and Report Liaisons on projects to develop visual representations including self-service reports using various analytical tools.
• Provides management with project status updates, feedback, and appropriate reporting on key responsibilities and objectives, along with preparation of monthly project scorecard reports.

Key Skills:

• Data analysis.
• Statistics.
• Problem solving.
• BI tools.
• Communication skills.
• Azure SQL Data Warehouse.
• Attention to detail.