Azure Data Architect - freelance

Responsibilities

• Provides a standard common business vocabulary, expresses strategic data requirements, outlines high level integrated designs to meet these requirements.
• Define and implement data governance policies, procedures, and frameworks to ensure data integrity and compliance.
• Collaborate with stakeholders to align data strategy with business goals and objectives, document current and target state in the form of business process and data journey diagrams.
• Design and develop conceptual, logical, and physical data models that meet business requirements and align with the overall data strategy.
• Define data standards, naming conventions, and data classification guidelines. Ensure data models are scalable, efficient, and optimized for performance.
• Evaluate and select appropriate database technologies and solutions based on organizational needs and requirements.
• Optimize database performance, ensure data security, and implement backup and recovery strategies.
• Design data integration solutions, including Extract, Transform, Load (ETL) processes and data pipelines, document source to target mappings.
• Understand and follow data architecture patterns for various types of data systems, e.g. data lake platforms, master data management systems, ML enriched data flows.
• Implement data profiling and data cleansing processes to identify and resolve data quality issues.
• Establish data quality standards and implement processes to measure, monitor, and improve data quality.
• Facilitate discussions and workshops to gather requirements and align data initiatives with business goals, prepare data inventory documentation.
• Communicate complex technical concepts effectively to both technical and non-technical stakeholders.
• Stay abreast of industry trends and emerging technologies in data management, analytics, and security.
• Evaluate and recommend new tools, technologies, and frameworks to enhance data architecture capabilities.
• Provide guidance and support to developers and other team members on data-related topics.
• Conduct knowledge sharing sessions and training programs to promote understanding and adoption of data architecture best practices.

Requirements

• At least 6 years of professional experience in the Data & Analytics area
• Proven experience as a Data Architect or in a similar role, ideally in a complex organizational setting.
• Strong understanding of data management principles, data modeling techniques, database design and data integration flows.
• Experience in developing and implementing data governance policies, procedures, and frameworks to ensure data integrity and compliance.
• Familiarity with industry best practices and emerging trends in data management and governance.
• Ability to design and develop conceptual, logical, and physical data models that meet business requirements and align with the overall data strategy.
• Strong understanding of data modeling best-practices, e.g. data normalization, denormalization, generalization, and performance optimization techniques.
• Expertise in working with various database technologies, such as relational databases (e.g., Oracle, SQL Server, MySQL) and NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB).
• Knowledge of database management systems, data warehousing, data integration technologies, and Big Data solutions.
• Familiarity with cloud-based database, warehouse, and lakehouse platforms.
• Experience in designing and implementing data integration solutions, including Extract,
• Transform, Load (ETL) processes and data pipelines, understanding of data integration patterns and best practices.
• Understanding of Business Intelligence and data analytics requirements, optimization of data storage and processing for reporting needs.
• Excellent communication and presentation skills to effectively articulate complex technical concepts to both technical and non-technical stakeholders.
• Ability to collaborate with cross-functional teams, including business analysts, developers, and data scientists, to understand requirements and drive data-related initiatives.
• Strong analytical and problem-solving abilities to identify data-related issues, propose solutions, and make data-driven decisions.
• Data Management
• Requirement Gathering and Analysis
• Data Processing

Preferred

• CI/CD Automation
• GenAI for Data Engineering
• Missing one or two of these qualifications? We still want to hear from you! If you bring a positive mindset, we'll provide an environment where you feel valued and empowered to learn and grow.

Requirements

• Familiarity with data profiling, data cleansing, data harmonization, and data quality assessment techniques.
• Knowledge of data security and privacy regulations, such as GDPR or CCPA, understanding of data encryption, access controls, and data masking techniques to ensure the security of sensitive data.
• Professional certification in data management or related field would be advantageous.

Must have skills

• Data Modelling and Design
• Technical Leadership
• Data Quality
• Azure Services – Synapse, ADF, ADL

Technical Implementation and Monitoring

One of: Python / Pyspark / R / Scala