Senior Power BI/ Azure Associate

Job Description

Salary:

Position: Senior Power BI/ Azure Associate

Location: Irving, TX(Hybrid 3x in office)

Employment Type: Contract-to-hire in 6 months

The ideal candidate will have extensive experience with Power BI, Azure Data Factory or Synapse Pipelines solutions and eco-system. The Senior Technical person will play a critical role in analyzing business requirements, designing and implementing solutions, and providing insights to drive business decisions. It will also include engaging with Finance & other domain users and owners, and collaborate with the rest of the IT team to deliver business insights leveraging available Analytics tools including Power BI for a global multinational organization.

Responsibilities:

Data Integration & ETL

Develop and maintain data pipelines using Azure Data Factory (ADF) or Synapse for ingesting, transforming, and loading data from multiple sources.

Implement data orchestration, parameterized pipelines, and monitoring for reliability and performance.

Data Modeling & Warehousing

Design and optimize data models in Azure Synapse Analytics or Azure Databricks to support analytics and reporting.

Work on star schema, data lakehouse structures, and performance tuning for large datasets.

Collaborate with data architects to maintain data governance and security standards.

Reporting & Visualization

Develop interactive Power BI dashboards and reports that translate complex data into actionable insights.

Build and manage Power BI datasets, measures (DAX), and row-level security (RLS).

Work closely with business stakeholders to understand reporting needs and deliver user-friendly solutions.

Optimization & Automation

Monitor data workflows for performance and cost efficiency.

Implement automation for recurring processes and ensure high data quality.

Collaboration & Documentation

Collaborate with cross-functional teams (Data Engineers, Analysts, Business Users).

Maintain clear technical documentation for pipelines, models, and dashboards.

Qualifications

Bachelor's degree in IT or related field.

Must be able to work in the US. SoHo Dragon does not provide visa sponsorship.

6-10 years of hands-on experience in data development and analytics.

Strong expertise in:

Microsoft Power BI (DAX, Power Query, data modeling, and visualization).

Azure Synapse Analytics (SQL, dedicated SQL pools, serverless queries).

Azure Data Factory (pipelines, linked services, dataflows).

Solid understanding of SQL, data warehousing principles, and ETL concepts.

Experience with Azure Data Lake, Azure Blob Storage, or similar cloud storage systems.

Strong analytical and problem-solving skills.

Ability to work in an agile, fast-paced environment.

Hybrid remote