Data Architect - Bogota, Colombia - Data Meaning

Descripción

DATA ARCHITECT

Position Type:
Long-term Contract


Location:
Latin America, Remote


Data Meaning Services Group is a leading Business Intelligence and Data Analytics consulting firm dedicated to empowering organizations with meaningful data-driven insights. As a company at the forefront of the data revolution, we specialize in transforming raw data into actionable information that drives informed decision-making and business growth. We partner with clients in the USA and LATAM across various industries to unlock the full potential of their data assets and deliver impactful solutions.

We are seeking a skilled and experienced
Data Architect to play a crucial role in designing & developing complex solutions, with a focus on efficient and effective data management.

The Data Architect will join a project working with ERD (Entity Relationship Diagrams), building and optimizing tables in SQL Server.

This person must be bilingual in either Spanish and English OR Portuguese and English.


RESPONSIBILITIES:

• Collaborate with stakeholders, including business analysts, developers, and data engineers to understand data requirements and translate them into scalable database designs
• Developing database solutions to store and retrieve company information
• Develop and maintain ERD diagrams that accurately represent the relationships between entities, attributes, and tables within the data model.
• Design, build, and optimize database tables, views, and indexes using SQL Server to ensure optimal performance, data integrity, and scalability
• Designing data models, database development standards, data warehouses and data analytics systems
• Implement best practices for data modeling, including normalization, denormalization, and indexing strategies, to meet performance and reporting requirements
• Collaborate with development teams to define and enforce data quality standards, data governance policies, and data integration procedures
• Conduct data profiling and analysis to identify data quality issues, anomalies, and inconsistencies, and develop strategies for data cleansing and improvement
• Perform capacity planning and database performance tuning to optimize query execution, minimize response times, and ensure high availability of data

REQUIREMENTS:

• Bachelor's degree in computer science, information systems, or a related field
• Proven experience as a Data Architect, Database Developer, or similar role
• Strong proficiency in designing and developing complex ERD diagrams using industrystandard tools
• Extensive experience in designing, building, and optimizing database tables, views, and indexes using SQL Server
• Solid understanding of data modeling principles, database normalization, denormalization techniques, and indexing strategies
• Proficiency in SQL and ability to write complex queries, stored procedures, and triggers
• Experience with database performance tuning, query optimization, and capacity planning
• Excellent analytical, problemsolving, and troubleshooting skills
• Strong communication and collaboration skills to work effectively with crossfunctional teams
• Detailoriented with a commitment to delivering highquality work within deadlines
• Professionallevel English/Spanish OR English/Portuguese language skills are required

V6mozM0QFA