SQL Data Architect

Responsibilities:

  1. Data Architecture:

    • Develop and maintain the overall data architecture strategy in alignment with business goals.
    • Design and implement scalable, efficient, and secure database structures.
  2. Data Modeling:

    • Lead the creation of logical and physical data models using SQL and advanced data modeling tools.
    • Collaborate with business analysts and stakeholders to understand data requirements and translate them into robust data models.
  3. Database Optimization:

    • Implement strategies for optimizing database performance, including indexing, partitioning, and query optimization.
    • Work closely with database administrators to ensure optimal database configuration.
  4. Data Governance:

    • Establish and enforce data governance policies and standards.
    • Ensure compliance with data security and privacy regulations.
  5. Documentation:

    • Create and maintain comprehensive documentation for data models, including entity-relationship diagrams, data dictionaries, and metadata.
  6. Collaboration:

    • Collaborate with cross-functional teams, including software developers, data engineers, and business stakeholders, to align data architecture with application requirements.
    • Provide guidance and support to development teams during the implementation phase.
  7. Emerging Technologies:

    • Stay abreast of industry trends and emerging technologies related to data modeling and architecture.
    • Evaluate and recommend new tools and technologies to enhance data architecture.

Qualifications:

  1. Education:

    • Bachelor’s degree in Computer Science, Information Technology, or a related field. Master’s degree preferred.
  2. Experience:

    • Proven experience as a Data Architect with a focus on data modeling.
    • Extensive experience in designing and implementing complex data models.
    • Proficient in SQL and advanced data modeling tools (e.g., ERwin, PowerDesigner).
  3. Skills:

    • Strong analytical and problem-solving skills.
    • Excellent communication and interpersonal skills.
    • In-depth knowledge of database management systems (e.g., MySQL, PostgreSQL, Oracle).
  4. Certifications:

    • Optional: Relevant certifications in data architecture or database management.

To apply for this job email your details to emma.crabtree@miraitalent.com