Architect (Power BI Developer)
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.
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 |