Senior Data Architect

Job Title : Senior Data Architect

Job Type: Contract

Locations: Dallas. TX / NY

Job Description:

Key Responsibilities

• Database & System Architecture

Design and implement scalable, secure database architectures for transactional and analytical use cases.
Define data models, partitioning strategies, indexing, and normalization standards.
Ensure data integrity, reliability, and maintainability across enterprise systems.
Support architectural decisions for high-availability and fault-tolerant systems.

• Performance Tuning & Optimization

Analyze and optimize complex SQL queries and execution plans.
Identify and resolve performance bottlenecks in high-volume environments.
Implement proactive monitoring and alerting strategies.
Improve system reliability and response times for mission-critical workloads.

• Cloud & Distributed Systems

Deploy and manage microservices-based data solutions on Azure Service Fabric.
Design stateful and stateless services for data-intensive and distributed workloads.
Ensure scalability, fault tolerance, and resilience across cloud environments.
Optimize service communication patterns and resource utilization.

• Modern Data Engineering & Analytics

Design and orchestrate batch and streaming pipelines using Azure Data Factory.
Build and optimize big data processing workflows on Azure Databricks using Apache Spark.
Implement Delta Lake and Delta Tables to support ACID transactions, data versioning, and schema evolution.
Enable advanced analytics and machine learning workloads on large-scale data platforms.

• Reporting & Data Consumption

Partner with BI teams to support Power BI semantic models and reporting needs.
Ensure data pipelines deliver clean, consistent, and trusted datasets.
Optimize data structures for analytical and visualization performance.
Support self-service analytics and enterprise reporting initiatives.

• Collaboration & Leadership

Collaborate with architects, DevOps, and business stakeholders to align solutions with strategic goals.
Provide technical guidance and mentorship to junior engineers.
Contribute to engineering best practices, standards, and design reviews.
Act as a subject-matter expert for data platform decisions.

Qualifications:

Advanced SQL expertise, including query optimization and transaction handling.

• Strong experience with performance tuning in complex, high-volume systems.
• Hands-on experience with Azure Service Fabric, Azure Data Factory, Azure Databricks, and Azure Storage.
• Deep knowledge of Apache Spark, Delta Lake, and distributed data processing.
• Familiarity with Power BI and data modeling best practices.

- Preferred

• Experience implementing CI/CD pipelines for data and analytics solutions.
• Knowledge of data governance, security, and compliance frameworks.
• Exposure to machine learning pipelines and real-time streaming architectures.