Consultant, Software Engineering Power BI Architecture Project

Eliassen Group; United States; Remote; USD 96,000 - 110,000; Part time

Job summary

Eliassen Group is seeking a part-time remote consultant to design, develop, and maintain Power BI dashboards and data pipelines for demand and capacity planning in a 4-month initial contract. Remote, 20 hours per week, W2 engagement with potential extension.

The role emphasizes data modeling, automation, and cross-functional collaboration. Responsibilities include building ETL pipelines, designing reporting architecture, and ensuring maintainable data solutions with clear documentation.

Qualifications

• Experience in software/data/BI development with Power BI dashboards.
• Hands-on in building and refining Power BI reports and data models.
• Familiarity with data integration from multiple sources, including SharePoint and Smartsheet.
• Experience designing ETL processes and data pipelines.
• Ability to translate business needs into technical solutions and documentation.
• Proficiency in scripting and API integrations for automation.
• Strong problem solving, communication, and stakeholder collaboration skills.
• Nice to have Pharma or life sciences background and consulting experience.

Responsibilities

• Collaborate with stakeholders to define requirements, scope, and technical specs.
• Design, develop, and enhance Power BI dashboards and reporting architecture.
• Build and maintain ETL pipelines to support reporting and analytics.
• Develop data models and analytical calculations for querying and analysis.
• Enhance dashboards for demand and capacity planning and portfolio management.
• Implement automation for data ingestion and business processes with scripting and API connections.
• Perform data analysis to address business needs and support decision making.
• Create and maintain technical documentation for data architectures and workflows.

Skills

Power BI

ETL pipelines

Data modeling

Automation scripting

API integrations

Stakeholder collaboration

Documentation

SharePoint

Smartsheet

Pharma experience

Education

Degree or equivalent experience

Tools

SharePoint

Smartsheet

Job description

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