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.
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; 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 Azure Data & Analytics PaaS Services: Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure Databricks, Azure HDInsight + Spark, Azure Databricks, and Azure SQL DB
- Knowledge of distributed systems and data processing frameworks such as Lambda architecture patterns
- Microsoft Certifications: Power BI Data Analyst Associate, Azure Data Engineer Associate, Azure Enterprise Data Analyst Associate etc.
- 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.
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.
