Brilliant Staffing
35608 | Business Intelligence Developer - SSIS focus
Brilliant Staffing, Fort Lauderdale, Florida, us, 33336
Job DescriptionBusiness Intelligence Developer (BID) are responsible for developing projects using complex T-SQL language and Microsoft SQL Server Integrated Services. They are also responsible for assisting business teams in making critical business decisions through the development of reports/dashboards. Ultimately, their goal is to aid in fulfilling our mission of positively impacting the health and wellness of those we serve in our community.
Essential Duties and Responsibilities:
Creates processes and leads projects / initiatives aimed at developing new data solutions / Operational Data Store (ODS)Build methods to gather, process, analyze, and publish BI data from multiple sources using Microsoft SQL Server Integrated Services (SSIS) via Visual Studios Data Tools; Relational Databases and complex T-SQL LanguageBuild ETL processes to convert pre-defined data solutions (ODS) into Data Marts for the enhancement of CCP's Enterprise Data Warehouse using the Kimball methodology (Fact Tables and Dimensions) and Go Live SupportProvides 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 neededMentors Business Intelligence team to develop an understanding of all stages of project development cycle to identify potential automation solutions to current time intensive processCollaborates with Report Developers and Report Liaisons on projects to develop visual representations including self-service reports using various analytical tools (i.e. SSRS, Power BI, Excel, Pyramid Analytics)Provides management with project status updates, feedback, and appropriate reporting on key responsibilities and objectives, along with preparation of monthly project scorecard reportsMaintains professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, benchmarking state-of-the-art practices, and participating in professional societiesThis job description in no way states or implies that these are the only duties performed by the employee occupying this position. Employees will be required to perform any other job-related duties assigned by their supervisor or management.
Essential Duties and Responsibilities:
Creates processes and leads projects / initiatives aimed at developing new data solutions / Operational Data Store (ODS)Build methods to gather, process, analyze, and publish BI data from multiple sources using Microsoft SQL Server Integrated Services (SSIS) via Visual Studios Data Tools; Relational Databases and complex T-SQL LanguageBuild ETL processes to convert pre-defined data solutions (ODS) into Data Marts for the enhancement of CCP's Enterprise Data Warehouse using the Kimball methodology (Fact Tables and Dimensions) and Go Live SupportProvides 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 neededMentors Business Intelligence team to develop an understanding of all stages of project development cycle to identify potential automation solutions to current time intensive processCollaborates with Report Developers and Report Liaisons on projects to develop visual representations including self-service reports using various analytical tools (i.e. SSRS, Power BI, Excel, Pyramid Analytics)Provides management with project status updates, feedback, and appropriate reporting on key responsibilities and objectives, along with preparation of monthly project scorecard reportsMaintains professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, benchmarking state-of-the-art practices, and participating in professional societiesThis job description in no way states or implies that these are the only duties performed by the employee occupying this position. Employees will be required to perform any other job-related duties assigned by their supervisor or management.