What are the responsibilities and job description for the Senior Power BI/ Azure Associate position at SoHo Dragon?
Position: Senior Power BI/ Azure Associate
Location:New York City(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.
- 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.