Azure Data Analytics Architect

Artifintech; Houston (TX); On-site; USD 120,000 - 190,000; Full time

Job summary

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC in Houston, TX seeks an experienced Data Engineering Architect to lead the design and implementation of advanced analytics solutions using Azure Databricks and Fabric. You will drive end-to-end data pipelines, collaborate with stakeholders, and guide a team of data engineers.

The role requires deep Azure data services expertise, strong SQL, and a track record of delivering scalable data platforms.

Qualifications

• 8+ years of data engineering / analytics experience.
• Deep expertise with Databricks, Synapse, and Azure data services.
• Strong SQL and experience with data warehousing and data lakes.

Responsibilities

• Lead architecture, design, and implementation of advanced analytics solutions using Azure Databricks / Fabric.
• Collaborate with stakeholders and IT teams to gather requirements and deliver solutions.
• Oversee end-to-end data solutions and ensure alignment with business needs and best practices.
• Develop data pipelines and ETL processes with Databricks, PySpark, and related tools.
• Integrate Databricks with Azure services and on-prem systems.
• Provide technical leadership and mentorship to the data engineering team.
• Document architecture, data flows, and processes with governance and security in mind.
• Ensure code quality, data security, and scalability best practices.
• Stay updated with Databricks and related technologies to drive innovation.

Skills

Leadership

Communication

Problem solving

Tools

Azure Databricks

Delta Lake

PySpark

Hadoop

Spark

Azure Data Lake

Azure Synapse

Azure Data Factory

Delta Live Tables

Auto Loader

Databricks SQL

CI/CD

Git

ARM templates

Power BI

Job description

Responsibilities

• 1. Lead the architecture, design, and implementation of advanced analytics solutions using Azure Databricks / Fabric. The ideal candidate will have a deep understanding of big data technologies, data engineering, and cloud computing, with a strong focus on Azure Databricks along with Strong SQL.
• 2. Work closely with business stakeholders and other IT teams to understand requirements and deliver effective solutions.
• 3. Oversee the end-to-end implementation of data solutions, ensuring alignment with business requirements and best practices.
• 4. Lead the development of data pipelines and ETL processes using Azure Databricks , PySpark, and other relevant tools.
• 5. Integrate Azure Databricks with other Azure services (e.g., Azure Data Lake, Azure Synapse, Azure Data Factory) and on-premise systems.
• 6. Provide technical leadership and mentorship to the data engineering team, fostering a culture of continuous learning and improvement.
• 7. Ensure proper documentation of architecture, processes, and data flows, while ensuring compliance with security and governance standards.
• 8. Ensure best practices are followed in terms of code quality, data security, and scalability.
• 9. Stay updated with the latest developments in Databricks and associated technologies to drive innovation.

Essential Skills

• Strong experience with Azure Databricks , including cluster management, notebook development, and Delta Lake.
• Proficiency in big data technologies (e.g., Hadoop, Spark) and data processing frameworks (e.g., PySpark).
• Deep understanding of Azure services like Azure Data Lake, Azure Synapse, and Azure Data Factory.
• Experience with ETL/ELT processes, data warehousing, and building data lakes.
• Strong SQL skills and familiarity with NoSQL databases.
• Experience with CI/CD pipelines and version control systems like Git.
• Knowledge of cloud security best practices.

Soft Skills

• Excellent communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
• Strong problem-solving skills and a proactive approach to identifying and resolving issues.
• Leadership skills with the ability to manage and mentor a team of data engineers.

Nice to have Skills

• Power BI for dashboarding and reporting.
• Microsoft Fabric for analytics and integration tasks.
• Spark Streaming for processing real-time data streams.
• Familiarity with Azure Resource Manager (ARM) templates for infrastructure as code (IaC) practices.

Experience

1. Demonstrated expertise of 8+ years in developing data ingestion and transformation pipelines using Databricks /Synapse notebooks and Azure Data Factory.
2. Solid understanding and hands-on experience with Delta tables, Delta Lake, and Azure Data Lake Storage Gen2.
3. Experience in efficiently using Auto Loader and Delta Live tables for seamless data ingestion and transformation.
4. Proficiency in building and optimizing query layers using Databricks SQL.
5. Demonstrated experience integrating Databricks with Azure Synapse, ADLS Gen2, and Power BI for end-to-end analytics solutions.
6. Prior experience in developing, optimizing, and deploying Power BI reports.
7. Familiarity with modern CI/CD practices, especially in the context of Databricks and cloud-native solutions.

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract