Data & Analytics Architect – Power BI & Cloud (Onsite)

SoHo Dragon; New York (NY); On-site; USD 85,000 - 121,000; Full time

Job summary

SoHo Dragon in New York City seeks an Application Architect – Data & Analytics with deep expertise in Power BI, Azure Data Factory, and Databricks to design enterprise data solutions.

You will lead BI and data engineering initiatives, develop scalable architectures, and guide cloud deployments across Azure, AWS, and GCP. This 12-month, on-site engagement requires strong communication and hands-on leadership.

Qualifications

• 10+ years of experience in enterprise data, analytics, or solution architecture.
• Strong hands-on Power BI experience including dashboards, DAX, and semantic models.
• Strong experience with Azure Data Factory pipelines and data integration.
• Hands-on experience administering and supporting Databricks.
• Experience managing cloud resources across Azure, AWS, and GCP.
• Knowledge of data warehouses, data lakes, dimensional modeling, and analytics architecture.
• Strong SQL, data integration, and performance optimization experience.
• Knowledge of DevOps, CI/CD, infrastructure automation, and cloud security.
• Excellent communication and problem-solving skills.
• Bachelor's degree in a related field or equivalent experience.

Responsibilities

• Design scalable enterprise data and analytics architectures.
• Define technical standards and best practices for data, reporting, analytics, and AI.
• Create solution designs, architecture diagrams, and implementation roadmaps.
• Evaluate new technologies and platforms.
• Develop and maintain Power BI dashboards, reports, and data models.
• Optimize performance, security, usability, and governance of BI solutions.
• Translate business reporting requirements into scalable BI solutions.
• Develop and maintain Azure Data Factory pipelines.
• Build data ingestion, transformation, and orchestration processes.
• Support data warehouses and data lakes and ensure data quality.
• Deploy and manage Databricks workspaces, clusters, and access controls.
• Support cloud deployments across Azure, AWS, and GCP.
• Design secure, highly available cloud solutions and enable DevOps practices.
• Evaluate AI technologies and integrate AI into data platforms.
• Provide technical leadership and review designs and code.

Skills

Analytical thinking

Communication

Problem solving

Leadership

Cloud experience

Education

Bachelor's degree or equivalent

Tools

Power BI

Azure Data Factory

Databricks

SQL

Azure/AWS/GCP

Job description

SoHo Dragon in New York City seeks an Application Architect – Data & Analytics with deep expertise in Power BI, Azure Data Factory, and Databricks to design enterprise data solutions.

You will lead BI and data engineering initiatives, develop scalable architectures, and guide cloud deployments across Azure, AWS, and GCP. This 12-month, on-site engagement requires strong communication and hands-on leadership.