Data Architect

Job Purpose

To be responsible for designing, creating, deploying, and managing data architecture and models. deep understanding of data systems, structures, and principles, along with hands-on experience in data modeling. Work with relational, dimensional, and NoSQL databases to design the databases using a mixture of conceptual, physical, and logical data models.

Duties & Responsibilities:

• Design and establish enterprise-level data architecture, ensuring it aligns with the company's business requirements.
• Analyze and translate business needs into long-term solution data models.
  
• Analyze data for source/target mappings. create SQL scripts for data processing.
• Perform data analysis and data modeling for operational applications and analytical databases.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Create and maintain a conformed data warehouse/ data lake/ lakehouse environment (including data marts, data cubes, subject areas, etc.) for performing data analytics.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Collaborate with the data analytics development to implement the data model.
• Develop entity relationships models for normalized and dimensional models.
• Work closely with data engineers, analysts, and stakeholders to determine data requirements for the organization and translate business needs into data solutions.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Design, develop and deploy database models for application development to support business applications, ensuring system scalability, security. performance and reliability.
• Mentor junior data engineers, providing them with training, guidance, and expertise to foster professional growth and uphold team standards.

Qualifications & Experience:

• Bachelor's degree in information technology. software engineering, computer science, or related field.
• 8+ years of hands-on relational. dimensional, and/or analytic experience dimensional, NoSQL data platform technologies, and ETL and data ingestion.
• Experience with data warehouse, data lake, and enterprise big data platforms, across multiple industries and subject areas
• Capable of facilitating data discovery sessions involving business subject matter experts
• Excellent presentation, communication, and organizational skills
  
• Ability to work both independently and as part of a team.