Solution Architect
New York City, New York, United States of America
Contract
8 hours ago
Key skills
SQLETLELTData EngineeringData WarehousingDatabricksSparkApache SparkAzureAzure DevOpsPerformance OptimizationCI/CDCommunicationCloud Security
About this role
We are looking for Solution Architect for our client in New York City, NY
Job Title: Solution Architect
Job Location: New York City, NY
Job Type: Contract
Job Overview:
Pay Range: $70hr - $75hr
Requirement/Must Have:
- Bachelor s degree in Computer Science, Engineering, or related discipline.
- 10 to 15+ years of experience in data engineering and/or data architecture roles.
- Advanced hands-on experience with Databricks, Apache Spark, and the Azure data stack.
- Strong practical knowledge of Lakehouse patterns, Delta Lake, and modern data warehousing.
- Demonstrated background designing resilient ETL/ELT systems with both batch and streaming patterns.
- Proficiency with SQL data stores, schema design, and performance optimization.
- Experience working with structured and semi-structured formats such as Parquet, ORC, and JSON.
- Solid understanding of cloud security, access governance, and metadata/catalog strategies (e.g., Unity Catalog).
- Experience implementing automated build/deploy workflows for data solutions.
- Excellent analytical, problem-solving, and communication skills.
Responsibilities:
- Develop end-to-end architectural patterns leveraging Databricks, Spark, Delta Lake, Unity catalog and Azure Data services.
- Design scalable Lakehouse foundations, ensuring performance, reliability, and maintainability of data layers.
- Establish architectural frameworks and standards for ingestion, curation, storage, and consumption.
- Experience in building a data platform with unity catalog and design the multi-tenant solution with data governance principles.
- Serve as a primary technical advisor for engineering teams, analysts, and data science partners.
- Participate in planning ceremonies, architectural councils, and cross-functional strategy discussions.
- Continuously evaluate emerging tools, Databricks capabilities, and Azure offerings to enhance platform maturity.
- Maintain and refine coding conventions, DevOps standards, and operational playbooks.
- Drive automation across deployment processes using Azure DevOps, or equivalent CI/CD toolchains.
Nice to Have:
- Hands-on experience with data lineage tools, or governance frameworks.
- Exposure to domain-driven design or product-oriented data architecture.