Sr. Business Intelligence Developer

Community Care Plan; Town of Florida (NY); Hybrid; USD 105,000 - 120,000; Full time

Benefits offered by this job

Hybrid work schedule

Equal opportunity employer

Job summary

Community Care Plan seeks a Senior BI Developer to design and implement data solutions using T-SQL, SSIS, SSAS, Power BI, and SSRS. You will build analytics models and dashboards to support critical health decisions for the community.

You will lead BI projects, mentor our BI team, and collaborate with IT and business stakeholders to ensure data quality and insight delivery. Hybrid work is supported in Sunrise, FL.

Qualifications

• Bachelor's degree required; 10+ years IT/BI experience preferred.
• 10+ years hands-on with SQL Server technologies (SSIS/ETL).
• 10+ years developing analytics with SSAS/MDX and reporting with SSRS.

Responsibilities

• Leads BI projects to gather, process, analyze, and publish BI data from multiple sources.
• Mentors BI team and aligns with management to determine needs across departments.
• Develops metrics, reports, dashboards, and visualizations for business users.

Skills

T-SQL

Power BI

SSIS

SSAS

MDX

ETL

Data Warehousing

Education

Bachelor's degree in IT/CS

Tools

SQL Server Data Tools

Job description

Sr. Business Intelligence Developer

Full Time Staff Sunrise, FL, US

Salary Range: $105,000.00 To $120,000.00 Annually

Position Summary

The Senior Business Intelligence Developer (SBID) is responsible for developing projects using complex T-SQL language, complex Microsoft SQL Server Integrated Services, Microsoft SQL Server Analysis Services, Microsoft Power BI and Microsoft SQL Server Reporting Services. They are also responsible for defining, developing, and delivering data and analysis using Business Intelligence best practices, along with Data Warehousing experience, to build Analytics Tabular Models and OLAP Models which will enable various business teams to make critical business decisions. 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

• Leads and implements projects and initiatives to develop new systems, methods and tools to gather, process, analyze, and publish BI data from multiple sources.
• Leads and mentors Business Intelligence team to develop an understanding of each business department's role within the company and works closely with management teams to determine needs.
• Works closely with 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.
• Leads and 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)) and/or Analytics/OLAP Cube and Tabular Model Development (Microsoft SQL Server Analysis Services (SSAS) and MDX)
• Actively leads projects 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 and Business Intelligence 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.

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; and Extraction, Transformation and Loading (ETL) ( Microsoft SQL Server Integrated Services (SSIS)
• Minimum of ten (10) years’ hands on experience development of Analytics/OLAP Cube and Tabular Model Development ( Microsoft SQL Server Analysis Services (SSAS) and MDX)
• Minimum of ten (10) years’ experience in report development using Microsoft SQL Server Reporting Services
• Minimum of five (5) years’ experience in analytical report/dashboard using tools such as Microsoft Power BI

Preferred Qualifications

• Experience with cloud data warehouse platform
• Experience in turning business use cases and requirements into technical solutions.
• Experience in business process mapping of data and analytics solutions
• Experience with preparing data for Data Science and Machine Learning purposes
• Experience with Azure data, Machine Learning and Artificial Intelligence solutions
• Knowledge of distributed systems and data processing frameworks such as Lambda architecture patterns
• EPIC Certifications in Tapestry Modules
• Knowledge of Master Data Management (MDM) and Data Quality tools
• Strong customer service focus and sense of urgency.
• Excellent skills in problem analysis and abstraction.
• Self-motivated and quick learner of new technology.
• Ability to thrive and produce results with little or no supervision in a fast-paced, entrepreneurial environment.

Skills and Abilities

• Proficient in Data Warehouse/Solution Design and Dimensional Modeling (Kimball Methodology)
• Proficient understanding of Business Intelligence best practices; experience with Data Warehousing and OLAP Models; and defining, developing, and delivering data and analysis
• Ability to lead and mentor team members to improve accuracy and quality of projects.
• 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.

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.

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.

Background Screening Notice

In compliance with Florida law, candidates selected for this position must complete a Level 2 background screening through the Florida Care Provider Background Screening Clearinghouse.

The Clearinghouse is a statewide system managed by the Agency for Health Care Administration (AHCA) and is designed to help protect children, seniors, and other vulnerable populations while streamlining the screening process for employers and applicants.

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.