Sr. Business Intelligence Developer

**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 analyti…