Senior Power BI/ Azure Associate

SoHo Dragon•New York, NY

19d•Hybrid

About The Position

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.

Requirements

Bachelor's degree in IT or related field.
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.

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.