Application Architect – Data & Analytics (Power BI, Azure Data Factory & Databricks)

SoHo Dragon•New York, NY

1d•Onsite

About The Position

The Application Architect will design and support enterprise data, analytics, and cloud solutions, focusing on Power BI, Azure Data Factory, Databricks, and cloud platforms. The role provides technical leadership across business intelligence, data engineering, analytics, and AI initiatives. The architect designs scalable enterprise data and analytics architectures, defines technical standards and best practices, creates solution designs and implementation roadmaps, and evaluates technologies. The position develops and maintains Power BI reports and models, Azure Data Factory pipelines, and Databricks environments; supports data warehouses, data lakes, and machine learning workloads; and deploys and manages cloud services across Azure, AWS, and GCP. The role also supports AI integration and technology assessments, provides guidance on AI governance and security, and offers technical leadership to developers, engineers, and analysts. The position is a 12-month engagement, 37.5 hours per week, onsite at 2 Broadway in New York City, with a pay rate of $75 per hour on C2C.

Requirements

10+ years of experience in enterprise applications, data, analytics, or solution architecture.
Strong hands-on Power BI experience, including dashboards, DAX, semantic models, and workspace administration.
Strong experience with Azure Data Factory, including ETL/ELT pipelines and data integration.
Hands-on experience administering and supporting Databricks.
Experience managing cloud resources in Azure, AWS, and GCP.
Strong 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.
Strong analytical, communication, and problem-solving skills.
Bachelor's degree in a related field or equivalent experience.

Nice To Haves

Azure, AWS, and/or GCP certifications.
Databricks certification or equivalent experience.
Experience with Machine Learning, Generative AI, and AI platforms.
Knowledge of data governance, metadata management, and data quality.
Large enterprise or public-sector 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, semantic models, and data models.
Optimize Power BI performance, security, usability, and governance.
Translate business reporting requirements into scalable BI solutions.
Develop and maintain Azure Data Factory pipelines.
Build data ingestion, transformation, and orchestration processes.
Support enterprise data warehouses and data lakes.
Ensure data quality, scalability, reliability, monitoring, and recovery.
Administer Databricks workspaces, clusters, security, and access controls.
Support data engineering, analytics, and machine learning workloads in Databricks.
Troubleshoot and tune performance.
Deploy and manage services across Azure, AWS, and GCP.
Design secure, highly available, and cost-effective cloud solutions.
Support infrastructure automation and DevOps practices.
Monitor cloud performance, security, and resource utilization.
Evaluate Machine Learning, Generative AI, and AI technologies.
Support AI integration into enterprise applications and data platforms.
Participate in proofs of concept and technology assessments.
Provide guidance on AI governance, security, and scalability.
Provide technical guidance to developers, engineers, and analysts.
Review solution designs and code.
Support enterprise technology initiatives.
Serve as a subject matter expert for cloud, data, analytics, and BI technologies.