Hi Folks
Job Title: Azure Data Architect (Contract)
Location: Remote (requires attending meetings as needed by the Client)
Key Responsibility:
• Work with stakeholders and the development team to determine the project scope
and vision and gather and prioritize collected requirements.
• Designing and Implementing Data Architectures: Develop comprehensive data
architectures that support the organization’s business goals, using Azure Synapse
Analytics, Azure SQL, and other Azure data services.
• Managing Dedicated SQL Pools: Efficiently manage and optimize Dedicated SQL
Pools in Synapse to handle large-scale data warehousing and analytics workloads.
• Research software solutions to support recommendations, analyzing current and
future technology trends.
• Database Design and Management: Design, implement, and manage databases
using Azure SQL and Azure Managed Instance, ensuring high performance,
availability, and security.
• Data Integration and ETL Processes: Develop and manage ETL (Extract, Transform,
Load) processes using Synapse Pipelines, ensuring efficient data flow from various
sources to the data warehouse.
• Data Governance and Cataloging: Implement data governance practices and
manage the data catalog to ensure data quality, consistency, and accessibility.
• Building and Maintaining Data Models: Create and maintain data models that
accurately represent the data landscape, ensuring they are scalable and optimized
for performance.
• Ensuring Data Security and Compliance: Implement and oversee data security
measures, ensuring compliance with legal and regulatory standards.
• Maintain procedures manuals and system documentation.
Required Skills
• 4+ years of experience in Synapse Analytics, Dedicated SQL Pools, Azure SQL
Database, and Azure Managed Instance.
• 5+ years of experience in DDL, DML T-SQL skills, advanced stored procedure writing
skills, tables, primary keys, foreign keys, constraints, indexes, transactions,
process logging, and error handling. 3. 4+ years of experience in data architecture
design principles, methodologies, and best practices.
• 3+ years of experience in data governance principles and compliance requirements
related to data security and privacy.
• 3+ years of experience in integrating data from various sources and managing large
data pipelines.
• 2+ years of experience in cloud computing concepts, particularly in Microsoft
Azure, including storage solutions and compute capabilities.
• 1+ years of Experience with programming languages such as Python or Scala.
• 1+ years of experience in Salesforce, Message MQ, and MuleSoft
• Strong analytical and problem-solving skills to address complex data challenges.
• Ability to design and implement robust, scalable, and efficient data architectures.
• Ability to provide excellent customer support, meticulous quality of work, and work
product
Education and Certification:
• Bachelor’s or Master’s Degree in Computer Science, Information Systems, or other
related field. Or equivalent work experience is required
• Microsoft Dynamics 365 Certification (Desired) and MS Dynamics Power Platform
Certifications (Desired)
Regards
AJ