Job description

Job description HiCounselor is assisting one of our clients looking for a proactive and driven Azure Databricks Architect to join our Consulting team for a client in the Midwest. In this role, you will be working on a Databricks Lakehouse Platform modernization / migration. You will work designing the system architecture and solution, ensuring the platform is scalable while performant, and creating automated data pipelines. Visa Sponsorship-: Not Available Responsibilities: Design & Architecture of Scalable Data Platforms o Design, develop, and maintain large-scale data processing architectures on the Databricks Lakehouse Platform to support business needs such as sales forecasting, trade promotions, supply chain optimization etc... o Architect multi-layer data models including Bronze (raw), Silver (cleansed), and Gold (curated) layers for various domains (e.g., Retail Execution, Digital Commerce, Logistics, Category Management). o Leverage Delta Lake, Unity Catalog, and advanced features of Databricks for governed data sharing, versioning, and reproducibility. Client & Business Stakeholder Engagement o Partner with business stakeholders to translate functional requirements into scalable technical solutions. o Conduct architecture workshops and solutioning sessions with enterprise IT and business teams to define data-driven use cases. Data Pipeline Development & Collaboration o Collaborate with data engineers and data scientists to develop end-to-end pipelines using PySpark, SQL, DLT (Delta Live Tables), and Databricks Workflows. o Enable data ingestion from diverse sources such as ERP (SAP), POS data, Syndicated Data, CRM, e-commerce platforms, and third-party datasets. Performance, Scalability, and Reliability o Optimize Spark jobs for performance tuning, cost efficiency, and scalability by configuring appropriate cluster sizing, caching, and query optimization techniques. o Implement monitoring and alerting using Databricks Observability, Ganglia, Cloud-native tools. Security, Compliance & Governance o Design secure architectures using Unity Catalog, role-based access control (RBAC), encryption, token-based access, and data lineage tools to meet compliance policies. o Establish data governance practices including Data Fitness Index, Quality Scores, SLA Monitoring, and Metadata Cataloging. Adoption of AI Copilots & Agentic Development • Utilize GitHub Copilot, Databricks Assistant, and other AI code agents for: • Writing PySpark, SQL, and Python code snippets for data engineering and ML tasks. • Generating documentation and test cases to accelerate pipeline development. • Interactive debugging and iterative code optimization within notebooks. • Advocate for agentic AI workflows that use specialized agents for: • Data profiling and schema inference. • Automated testing and validation. Innovation and Continuous Learning o Stay abreast of emerging trends in Lakehouse architectures, Generative AI, and cloud-native tooling. o Evaluate and pilot new features from Databricks releases and partner integrations for modern data stack improvements. Requirements: • Bachelor’s or master’s degree in computer science, Information Technology, or a related field. • 12-18 years of hands-on experience in data engineering, with at least 5+ years on Databricks Architecture and Apache Spark. • Expertise in building high-throughput, low-latency ETL/ELT pipelines on Azure Databricks using PySpark, SQL, and Databricks-native features. • Familiarity with ingestion frameworks from structured/unstructured data sources including APIs, flat files, RDBMS, and cloud storage (Azure Data Lake Storage Gen2). • Experience designing Lakehouse architectures with bronze, silver, gold layering. • Expertise in optimizing Databricks performance using Delta Lake features such as OPTIMIZE, VACUUM, ZORDER, and Time Travel. • Strong understanding of data modelling concepts, star/snowflake schemas, dimensional modelling, and modern cloud-based data warehousing. • Experience with designing Data marts using Databricks SQL warehouse and integrating with BI tools (Power BI, Tableau, etc.). • Hands-on experience designing solutions using Workflows (Jobs), Delta Lake, Delta Live Tables (DLT), Unity Catalog, and MLflow. • Familiarity with Databricks REST APIs, Notebooks, and cluster configurations for automated provisioning and orchestration. • Experience in integrating Databricks with CI/CD pipelines using tools such as Azure DevOps, GitHub Actions. • Knowledge of infrastructure-as-code (Terraform, ARM templates) for provisioning Databricks workspaces and resources. • In-depth experience with Azure Cloud services such as ADF, Synapse, ADLS, Key Vault, Azure Monitor, and Azure Security Centre. • Strong understanding of data privacy, access controls, and governance best practices. • Experience working with Unity Catalog, RBAC, tokenization, and data classification frameworks. • Excellent communication skills for stakeholder interaction, solution presentations, and team coordination. • Proven experience leading or mentoring global, cross-functional teams across multiple time zones and engagements. • Ability to work independently in agile or hybrid delivery models, while guiding junior engineers and ensuring solution quality. Pay: A reasonable estimate of the current range is: $115,000 - $165,000. In addition, you may be eligible for a discretionary bonus for the current performance period. Benefits: As a full-time employee of the company or as an hourly employee working more than 30 hours per week, you will be eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents, which may be amended from time to time. You will be eligible for benefits on the first day of employment with the Company. In addition, you are eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms. The Company provides for 11 paid holidays and 12 weeks of Parental Leave. We also follow a “free time” PTO policy, allowing you the flexibility to take the time needed for either sick time or vacation. Job Type: Full-time

Requirements