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