Logo
SoHo Dragon

Senior Power BI/ Azure Associate

SoHo Dragon, Chicago, Illinois, United States, 60290

Save Job

Join to apply for the

Senior Power BI/ Azure Associate

role at

SoHo Dragon .

Position:

Senior Power BI/ Azure Associate Location:

Chicago (Hybrid 3x in office) Employment Type:

Contract-to-hire in 6 months.

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

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.

#J-18808-Ljbffr