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

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

Duration: 12 months(37.5 hrs per week)

Location: 2 Broadway, NYC - 100% Onsite

Pay rate: $75/hr on C2C

Position Summary

The Application Architect will design and support enterprise data, analytics, and cloud solutions, with a focus on Power BI, Azure Data Factory, Databricks, and cloud platforms. The role provides technical leadership across business intelligence, data engineering, analytics, and AI initiatives.

Required Qualifications

• 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.

Preferred Qualifications

• 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.

Key Responsibilities

Architecture & Design

• 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.

Power BI

• Develop and maintain Power BI dashboards, reports, semantic models, and data models.

• Optimize performance, security, usability, and governance.

• Translate business reporting requirements into scalable BI solutions.

Azure Data Factory / Data Engineering

• 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.

Databricks

• Administer Databricks workspaces, clusters, security, and access controls.

• Support data engineering, analytics, and machine learning workloads.

• Perform troubleshooting and performance tuning.

Cloud

• 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.

AI & Analytics

• Evaluate Machine Learning, Generative AI, and AI technologies.

• Support AI integration into enterprise applications and data platforms.

• Participate in POCs and technology assessments.

• Provide guidance on AI governance, security, and scalability.

Technical Leadership

• Provide technical guidance to developers, engineers, and analysts.

• Review solution designs and code.

• Support enterprise technology initiatives.

• Serve as an SME for cloud, data, analytics, and BI technologies.

Core Skills

• Power BI

• Azure Data Factory

• Databricks

• Azure / AWS / GCP

• SQL

• Data Engineering

• Data Warehousing / Data Lakes

• Solution Architecture

• DevOps / CI/CD

• AI / Machine Learning