Business Intelligence Developer
Community Care Plan Careers
 Fort Lauderdale, FL

Requisition Number: BUSIN01295

Position Summary:

Business Intelligence Developer (BID) are responsible for developing projects using complex T-SQL language and Microsoft SQL Server Integrated Services, along with building Analytics Tabular Models. They are also responsible for assisting business teams in making critical business decisions using Microsoft SQL Server Integrated Services, 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 process, reports and/or analytic models using various SQL Server technologies such as Visual Studios Data Tools; Relational Database and complex T-SQL Language; Extraction, Transformation and Loading (ETL) (Microsoft SQL Server Integrated Services (SSIS))
  • Designs, develops, modifies, and implements reports, including self-service reports, using Excel and/or SQL Server Reporting Services (SSRS) to meet the reporting needs of the executive team and the organization
  • Creates analytical report/dashboard using tools such as Pyramid Analytics
  • Collaborates with IT Manager, Business Intelligence and Business Reporting team in leading projects and initiatives aimed at developing new systems, methods and tools to gather, process, analyze, and publish BI data from multiple sources
  • Leads projects to develop and deploy new reports and various visual representations including self-service reports using tools such as SSRS, Power BI, Excel, Pyramid Analytics and other BI Tools to meet the reporting needs of the executive team and the organization
  • Mentors Business Reporting team to develop an understanding of each business department's role within the company and work closely with management teams to determine needs
  • Works closely with the IT Manager, Business Intelligence, Data Warehousing team, Business Units and Business Stakeholders to understand their unique analytic and reporting requirements to assist in the development of metrics, reports, dashboards and visualizations
  • Actively leads projects and works closely with BI reporting development life cycle, including identifying Subject Matter Experts; Requirement Gathering; Analysis, Design and Development; and Testing, Implementation and Go Live Support
  • Provides individual contributions after key projects have been implemented and works closely with the IT Manager, Business Intelligence and Business Reporting team to proactively identify data quality issues, coordinate root cause analysis, implement required fixes, and perform QA validations to build exception reporting where needed
  • 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:

  • Bachelor's degree (B. A. / B. S.) from four-year College or university or ten (10) years’ experience in IT field
  • Minimum of ten (10) years’ hands on experience in various SQL Server technologies in Visual Studios Data Tools; Relational Database and complex T-SQL Language; Extraction, Transformation and Loading (ETL) (Microsoft SQL Server Integrated Services (SSIS))
  • Minimum of ten (10) years’ experience in report development using Microsoft SQL Server Reporting Services
  • Experience development of Analytics/OLAP Cube and Tabular Model Development (Microsoft SQL Server Analysis Services (SSAS) and MDX) (preferred)
  • Experience in analytical report/dashboard using tools such as Pyramid Analytics (preferred)
  • Microsoft Certifications (preferred)
  • EPIC Certifications in Tapestry Modules (preferred)

Skills and Abilities:

  • Strong understanding of Data Warehouse/Solution Design and Dimensional Modeling (Kimball Methodology)
  • Strong understanding of Business Intelligence best practices, experience with Data Warehousing and OLAP databases, and defining, developing, and delivering data and analysis
  • Well-organized, action and results oriented team player with exceptional time management skills to support multiple initiatives simultaneously in a fast-paced environment with excellence in planning and execution
  • Proven ability to establish and articulate a vision, set goals, develop and execute strategies, and track and measure results with high attention to detail and the ability to prioritize
  • Ability to combine strong analytical skills with business knowledge to develop rapport with key customers in the business and approach every challenge with a customer-centric view
  • Knowledge of clinical and financial systems within a Healthcare environment desired
  • Ability to adhere to coding standards and participate in peer code reviews
  • Knowledge of project management methodologies and best practices
  • Excellent presentation skills with solid communication capabilities and practices, both oral and written
  • Ensure systems comply with HIPPA regulations
Support