Business Intelligence Developer

Job Description

Job Description

Hybrid-Sunrise, Florida

Position Summary :

The Business Intelligence Developer (BID) is 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 Language
• Build 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 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 (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 reports
• Maintains professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, benchmarking state-of-the-art practices, and participating in professional societies

This 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.

Qualifications :

Microsoft SQL Server Integrated Services (SSIS)

Microsoft SQL Server Reporting Services (SSRS)

Preferred Qualifications :

Pyramid Analytics

Microsoft SQL Server Analysis Services (SSAS)

Skills and Abilities :

Work Schedule :

Community Care Plan is currently following a hybrid work schedule. The company reserves the right to change the work schedules based on the company needs

Physical Demands :

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit, use hands, reach with hands and arms, and talk or hear. The employee is frequently required to stand, walk, and sit. The employee is occasionally required to stoop, kneel, crouch or crawl. The employee may occasionally lift and / or move up to 15 pounds.

Work Environment :

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job. The environment includes work inside / outside the office, travel to other offices, as well as domestic travel. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.

We are an equal opportunity employer who recruits, employs, trains, compensates and promotes regardless of age, color, disability, ethnicity, family or marital status, gender identity or expression, language, national origin, physical and mental ability, political affiliation, race, religion, sexual orientation, socio-economic status, veteran status, and other characteristics that make our employees unique. We are committed to fostering, cultivating and preserving a culture of diversity, equity and inclusion.