Senior Power BI/ Azure Associate

Position: Senior Power BI/ Azure Associate
Location: Boston(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.