Power BI & Data Pipeline Specialist

i-PRO Americas Inc; Houston (TX); Hybrid; USD 85,000 - 115,000; Full time

Job summary

i-PRO Americas Inc. seeks a mid-level Business Systems Analyst to connect enterprise data sources, build data pipelines, and develop Power BI reports for operational and leadership audiences.

The role leverages REST APIs, Azure Data Factory, SQL, Power Query, and DAX to integrate, validate, transform, and present data, with a path into data engineering or technical project management as opportunities arise.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business, or related field or equivalent practical experience.
• Approximately 3 to 5 years of relevant experience in business intelligence, analytics development, reporting, or related technical role.
• Hands-on experience developing and supporting Power BI reports, dashboards, and semantic models in a business environment.
• Experience gathering requirements and collaborating with technical and nontechnical stakeholders.
• Experience supporting projects through requirements, planning, testing, issue tracking, status reporting, and stakeholder coordination is preferred.
• Power BI development, DAX, Power Query (M), semantic modeling, SQL, dashboards, workspace permissions, refresh schedules, gateways, and Row-Level Security.
• REST API integration, including OAuth 2.0, API keys, pagination, rate limits, JSON handling, and source-system troubleshooting.
• Working knowledge of Azure data services such as Azure Data Factory, Azure PostgreSQL Database, Azure SQL, Microsoft Fabric, or Azure Synapse Analytics.
• Ability to investigate discrepancies, test assumptions, document business rules, explain technical topics clearly, manage multiple assignments, meet commitments, and raise risks early.
• Familiarity with Git, Azure DevOps CI/CD, Python, or PySpark is helpful but not required.
• Microsoft PL-300, DP-600, DP-700, or related certifications are preferred.

Responsibilities

• Design, build, test, publish, and maintain Power BI reports, dashboards, semantic models, DAX measures, calculated columns, and Power Query transformations for operational and leadership audiences.
• Build and support REST API integrations, including authentication, pagination, rate-limit handling, JSON parsing, and connections to ERP, CRM, finance, and third-party SaaS platforms.
• Monitor Azure Data Factory and related data pipelines, troubleshoot failures, configure alerts, and help ensure that trusted data is delivered on schedule.
• Validate data against source systems, reconcile discrepancies, communicate source-data issues to department leaders, and follow through to resolution.
• Maintain documentation for datasets, business rules, measures, refresh schedules, access controls, ownership, testing, deployment, and change management.
• Partner with technical and nontechnical stakeholders to gather requirements, coordinate testing and releases, support users, and provide clear updates on progress, risks, issues, and dependencies.
• Identify opportunities to simplify reporting, reduce manual work, standardize metrics, improve adoption, and expand capabilities in data engineering or technical project delivery with moderate direction from the supervisor.

Skills

Power BI development

Requirements gathering

Stakeholder coordination

Data analysis

Communication of technical concepts

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

DAX

Power Query

SQL

Azure Data Factory

Microsoft Fabric

Azure Synapse Analytics

Git

Azure DevOps CI/CD

Python

PySpark

REST API integrations

Job description

i-PRO Americas Inc. seeks a mid-level Business Systems Analyst to connect enterprise data sources, build data pipelines, and develop Power BI reports for operational and leadership audiences.

The role leverages REST APIs, Azure Data Factory, SQL, Power Query, and DAX to integrate, validate, transform, and present data, with a path into data engineering or technical project management as opportunities arise.