Architect (Power BI Developer)

Hi,

Hope you are doing well

My name is Deepak Yadav and I'm a Recruiter at Prisa Consulting Solutions LLC. Our records show that you are an experienced IT professional with Architect (Power BI Developer). This experience is relevant to one of my current openings.

Job Title: Architect (Power BI Developer)

Location: Dauphin County, PA with Remote

Position: Contract Position

Job Description-

• Experience working in the public health or healthcare industry with various health data sets.BACKGROUND
  position will help manage the design, development and administration of data quality and statistical analysis, reports, and dashboards. This position will support the DOH / DDAP reporting and analysis needs with the Data Warehouse and 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..
  • Manage assignments and track progress against agreed upon timelines.
  • Plan, organize, prioritize, and manage work efforts, coordinating with the EDW and other teams.
  • Participate in status reviews, process reviews, deliverable reviews, and software quality assurance work product reviews with the appropriate stakeholders.
  • Participate in business, functional, quality-of-service, and technical requirements gathering. Assist in developing Stakeholder / User requirements; an important part of the deliverables, the needs of the stakeholders will have to be correctly interpreted.
  • Develop report specifications - define the purpose of a report, its justification, attributes and columns, owners, and runtime parameters.
  • Develop graphic representations of complex business processes. Assist in creating workflows using formal notation such as the Business Process Modeling Notation (BPMN).
  • Develop and implement solutions that meet business and technical requirements.
  • Participate in testing of implemented solutions.
  • Build and maintain relationships with key stakeholders and customer representatives.
  • Give presentations for the EDW, other DOH offices, and agencies involved with this project.
  • Ensure project compliance with relative federal and commonwealth standards and procedures.
  • Complete weekly timesheet reporting in PeopleFluent/VectorVMS by COB each Friday.
  • Complete the weekly project status updates in Daptiv if necessary. This will be dependent on a project being entered into Daptiv.
  • Provide weekly personal status reporting by COB Friday submitted on SharePoint.
  • Utilize a SharePoint site for project and operational documentation; review existing documentation.
  
  
  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
  Advanced expertise with using analytical software, including SAS statistical software and Microsoft Excel, for analytical and reporting purposes
  Experience with data mining architectures, modeling standards, reporting and data analysis methodologies
  Experience with analyzing and translating business requirements and use cases into optimized models, data flows, and developing report solutions
  Experience with and knowledge of relational databases, entity relationships, data warehousing, facts, dimensions, and star schema concepts and terminology
  Strong proficiency with SQL Server, T-SQL, scripts, and complex queries. Experience with SQL Server Reporting Services
  Experience with Azure DevOps and Agile / Scrum development methods
  Demonstrable ability to communicate and document clearly and concisely
  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.
  More than 5 years of relevant experience
  4-year college degree in computer science or related field with advanced
  

  Advanced expertise with Microsoft Power BI software and DAX for the creation, modification, and maintenance of data displays

  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 data mining architectures, modeling standards, reporting and data analysis methodologies

  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

• Demonstrable, advanced experience with data profiling, data formatting, capture, search, retrieval, extraction, classification, aquality analysis,fil

  Required

  5

  Years

• Experience with Azure DevOps and Agile / Scrum development methods

  Required

  5

  Years

• Advanced expertise with using analytical software, including SAS statistical software and Microsoft Excel, for analytical and reporting purposes

  Required

  5

  Years

• REquired Minimum Skills as per below information
• REQUIREMENTS / RESPONSIBILITIES:
• 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.
• Power BI Developer
• The contractor is expected to be in the office at least '1' day per month, subject to additional days in office at Manager discretion.