Business Systems Analyst

i-PRO; Houston (TX); On-site; USD 85,000 - 120,000; Full time

Job summary

i-PRO is seeking a mid-level Business Systems Analyst to connect enterprise data sources, build reliable data pipelines, and develop Power BI reports for operational and leadership decision-makers.

You will work with REST APIs, Azure Data Factory, SQL, Power Query, and DAX, enhancing data integration, validation, and presentation. A development path into data engineering or technical project management is available as opportunities grow.

Qualifications

• Bachelor's degree in a relevant field or equivalent experience.
• 3–5 years in BI, analytics development, or related technical role.
• Hands-on experience building Power BI reports and semantic models.
• Experience gathering requirements with stakeholders.
• Knowledge of data warehousing concepts and ETL/ELT processes.

Responsibilities

• Design, build, test, publish, and maintain Power BI reports and dashboards.
• Develop REST API integrations and data pipelines with Azure Data Factory.
• Monitor data pipelines and troubleshoot failures, ensuring trusted data.
• Validate data against source systems and resolve discrepancies.
• Collaborate with stakeholders to gather requirements and coordinate releases.
• Document datasets, rules, schedules, access, and testing.

Skills

Power BI

DAX

SQL

Data Modeling

Stakeholder Communication

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business, or related field

Tools

Azure Data Factory

Microsoft Fabric

Azure Synapse Analytics

Git

Azure DevOps CI/CD

Python

Power Query (M)

PySpark

Job description

Purpose of the Job

The Business Systems Analyst connects enterprise data sources, builds reliable data pipelines, and develops Power BI reports that enable informed operational and leadership decisions. The role uses REST APIs, Azure Data Factory, SQL, Power Query, DAX, and data warehouse practices to integrate, validate, transform, and present data. This mid-level individual contributor position also offers a development path into data engineering or technical project management as business needs, performance, and opportunities align.

Purpose of the Job

The Business Systems Analyst connects enterprise data sources, builds reliable data pipelines, and develops Power BI reports that enable informed operational and leadership decisions. The role uses REST APIs, Azure Data Factory, SQL, Power Query, DAX, and data warehouse practices to integrate, validate, transform, and present data. This mid-level individual contributor position also offers a development path into data engineering or technical project management as business needs, performance, and opportunities align.

Key Accountabilities

• 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 non-technical 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.

This position requires limited travel based on business needs.

Why You Would Love This Job

You will work across business and technology teams to turn enterprise data into practical insights while developing broader technical capabilities. The role provides hands‑on exposure to Microsoft Fabric, Azure data services, enterprise systems, data governance, integrations, and structured project delivery, without requiring senior‑level architecture ownership on day one. Success can lead to expanded responsibility in data engineering, technical project management, or both.

Qualifications

Education & Experiences

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business, or a related field, or equivalent practical experience.
• Approximately 3 to 5 years of relevant experience in business intelligence, analytics development, reporting, or a 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 non-technical stakeholders.
• Experience supporting projects through requirements, planning, testing, issue tracking, status reporting, and stakeholder coordination is preferred.

Competencies, Skills & Knowledge

• 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.
• Data warehousing concepts, including dimensional modeling, ETL/ELT, slowly changing dimensions, data validation, traceability, governance, and access controls.
• 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.

Physical Requirements

• Prolonged periods of sitting at a desk and working on a computer.
• Reliable internet service and an appropriate workspace when working remotely.
• Ability to travel on a limited basis when required by business needs.

Language

• Professional proficiency in written and spoken English.
• Ability to communicate technical concepts in clear, straightforward language to technical and non-technical audiences.