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