Job description

Power BI Developer in Harrisburg PA job at CSZNet Inc. Remote. Architect (Power BI Developer) BACKGROUND This position's scope includes the modernization of DOH operations; plan, coordinate and respond to data reporting needs, set standards and define framework; assist with large volume data processing, statistical analysis of large datasets; revamping the EDW into Microsoft's Azure Cloud utilizing Azure Databricks, Delta Lake and Synapse, including compute, storage and application fabric, as well as services for infrastructure as a service (IaaS), platform as a service (PaaS), software as a service (SaaS) and serverless technologies; create a centralized data model; support for DOH projects like ELC Enhanced Detection Expansion, Data Modernization Initiative, PA NEDSS NextGen, PA LIMS Replacement, Reporting Hub, Verato UMPI, COVID-19 response, and onboarding additional DOH systems into the EDW. REQUIREMENTS / RESPONSIBILITIES: The Power BI Developer is a senior level resource with specialized knowledge and experience in data analysis, data modeling, data cleansing, Power BI software and architecture, and dashboard and report development. The selected contractor must have proven and demonstrated experience in the development, testing, publishing, and maintenance of Power BI data products. The selected contractor will collaborate with EDW team members and DOH program area stakeholders to develop and implement solutions that meet the requirements for using the data. This position will be expected to develop and implement Power BI solutions, and work with business analysts, application developers, and DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, and program area customer satisfaction objectives. The Power BI Developer / Architect can design, develop, and implement data structures, dashboards, reports, and other data products that meet the organization's objectives and requirements. The Power BI Developer / Architect is familiar with a variety of database, applications, and analytic technologies, environments, concepts, methodologies, practices, and procedures. Advanced expertise with Microsoft Power BI software and DAX for the creation, modification, and maintenance of data displays Experience with data mining architectures, modeling standards, reporting and data analysis methodologies Experience with and knowledge of relational databases, entity relationships, data warehousing, facts, dimensions, and star schema concepts and terminology Experience with Azure DevOps and Agile / Scrum development methods Ability to balance work between multiple projects and possess good organizational skills, with minimal or no direct supervision Ability to present complex technical concepts and data to a varied audience effectively. 4-year college degree in computer science or related field with advanced study preferred. PREFERRED EXPERIENCE : Experience working in the public health or healthcare industry with various health data sets. TIMEFRAMES LOCATION: The contractor must reside in PA, and will be permitted to work from home. Office space for the contractor will be provided as needed. The contractor is expected to be in the office at least '1' day per month, subject to additional days in office at Manager discretion. In addition, DOH will supply all necessary hardware and software for daily use that are needed to complete assigned work items. Skill Required /Desired Amount of Experience Advanced expertise with Microsoft Power BI software and DAX for the creation, modification, and maintenance of data displays Required 5 Years Advanced expertise with using analytical software, including SAS statistical software and Microsoft Excel, for analytical and reporting purposes Required 5 Years Strong proficiency with SQL Server, T-SQL, scripts, and complex queries. Experience with SQL Server Reporting Services Required 5 Years Experience with Azure DevOps and Agile / Scrum development methods Required 5 Years Experience with data mining architectures, modeling standards, reporting and data analysis methodologies Required 5 Years Demonstrable, advanced experience with data profiling, data formatting, capture, search, retrieval, extraction, classification, aquality analysis,fil Required 5 Years Knowledge of relational databases, entity relationships, data warehousing, facts, dimensions, and star schema concepts and terminology Required 5 Years 4-year college degree in computer science or related field with advanced study preferred Nice to have 0

Requirements