What are the responsibilities and job description for the Senior Power BI/ Azure Associate position at SoHo Dragon?
Salary: Position: Senior Power BI/ Azure AssociateLocation:New York City(Hybrid 3x in office)Employment Type: Contract-to-hire in 6 monthsThe 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 & ETLDevelop 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 & WarehousingDesign 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 & VisualizationDevelop 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 & AutomationMonitor data workflows for performance and cost efficiency.Implement automation for recurring processes and ensure high data quality.Collaboration & DocumentationCollaborate with cross-functional teams (Data Engineers, Analysts, Business Users).Maintain clear technical documentation for pipelines, models, and dashboards.QualificationsBachelor'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.
Salary : $86,400