Consultant, Software Engineering Power BI Architecture Project

Description Remote

Our client seeks a consultant to design, develop, and maintain Power BI dashboards and data solutions that enable demand and capacity planning, resource allocation, and strategic portfolio management for Development Sciences. The consultant will develop scalable data pipelines, optimize data models, enhance reporting capabilities, and implement automation solutions to streamline data ingestion and business processes. This is a part-time role at 20 hours per week with an immediate start on a 4-month initial contract and an expectation to extend.

Due to client requirements, applicants must be willing and able to work on a w2 basis. Rate: $70.00 to $80.00/hr. w2

Responsibilities

• Business Requirements and Solution Design: Collaborate with stakeholders to gather requirements, define scope, and translate business processes into technical specifications, data models, reporting requirements, and user-facing solutions.
• Power BI Development and Architecture: Design, develop, and enhance Power BI dashboards and reporting solutions, including data flows, orchestration, semantic models, and reporting architecture.
• Data Engineering and Pipeline Development: Build and maintain ETL pipelines to support reliable and efficient reporting and analytics.
• Data Modeling and Analytics: Develop purpose-built data models and analytical calculations for querying, reporting, and analysis.
• Demand and Capacity Planning: Enhance dashboards and analytics supporting demand and capacity planning, resource allocation, and portfolio management.
• Data Ingestion and Process Automation: Implement automation for data ingestion and business processes, including scripting, API integrations, and connections to sources such as SharePoint and Smartsheet.
• Data Analysis and Business Support: Perform data analysis to address business needs, identify insights, and support decision-making.
• Technical Documentation: Create and maintain documentation for data architecture, ETL processes, pipelines, automation solutions, and related workflows.

Experience Requirements

• Experience in software engineering, data engineering, or business intelligence development.
• Hands-on experience developing and enhancing Power BI dashboards and reports.
• Familiarity with data integration and ingestion from multiple sources, including SharePoint and Smartsheet.
• Experience with data modeling, semantic modeling, and analytical calculations.
• Experience designing, building, and maintaining ETL processes and data pipelines.
• Proficiency in data analysis and translating business requirements into technical solutions.
• Experience developing automation solutions, including scripting and API integrations.
• Strong problem-solving, analytical, communication, and stakeholder collaboration skills.
• Ability to develop clear technical documentation and maintainable data solutions.
• Nice to have: Pharma or life sciences experience and professional consulting experience.

Education Requirements Degree or equivalent experience