Job Title

This role is Contract to hire (Hybrid)Scroll down the page to see all associated job requirements, and any responsibilities successful candidates can expect.Business Intelligence Developer (BID) are 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 LanguageBuild 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 SupportProvides 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 neededMentors Business Intelligence team to develop an understanding of all stages of project development cycle to identify potential automation solutions to current time intensive processCollaborates 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 reportsMaintains professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, benchmarking state-of-the-art practices, and participating in professional societiesThis 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 7-10 years experience in IT fieldMinimum of 7-10 years hands on experience inMicrosoft SQL Server Integrated Services (SSIS)Visual Studios Data ToolsRelational DatabaseComplex T-SQL LanguageMinimum of five (5) years' hands on experience inMicrosoft SQL Server Reporting Services (SSRS)Experience in one of these analytical report/dashboard tools (preferred)Pyramid AnalyticsPower BITableauKnowledge of Analytics/OLAP Cube and Tabular Models tools (preferred)Microsoft SQL Server Analysis Services (SSAS)MDX query languageExperience participating in all stages of project development cycle (planning, design, implementation, and testing)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 analysisWell-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 executionProven 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 prioritizeAbility 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 viewKnowledge of clinical and financial systems within a Healthcare environment desiredAbility to adhere to coding standards and participate in peer code reviewsKnowledge of project management methodologies and best practicesExcellent presentation skills with solid communication capabilities and practices, both oral and writtenEnsure systems comply with HIPPA regulationsPreferred Qualifications:Experience with cloud data warehouse platformsExperience in turning business use cases and requirements into technical solutions.Experience in business processing mapping of data and analytics solutionsKnowledge 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 DBEPIC Certifications in Tapestry ModulesKnowledge of Master Data Management (MDM) and Data Quality toolsStrong 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.