Job Description We are seeking a highly skilled Data Modeler/ Data Analyst to join our team at Capgemini Engineering in Colombia. The ideal candidate will have strong experience in SQL and a deep knowledge of database management systems like Oracle and SQL Server. Key Responsibilities: - Analyze and translate business needs into long-term solution data models, ensuring a thorough understanding of the requirements. - Evaluate existing data systems to identify areas for improvement and optimize their performance. - Collaborate with the development team to create conceptual, logical, and physical data models and data flows, aligning with industry best practices. - Develop best practices for data coding to ensure consistency within the system, promoting efficient data management. - Review modifications of existing systems for cross-compatibility, minimizing disruption to operations. - Understand data warehousing concepts, including data extraction, transformation, and loading (ETL) processes. - Familiarize with cloud-based data services like Azure, staying up-to-date with emerging technologies. - Locate data sources for business requirements, leveraging expertise to extract relevant information. - Gather data from various sources and structure it for analysis, applying data quality techniques to ensure accuracy. - Ensure data quality by removing duplicates, handling missing values, and transforming data into a usable format, maintaining data integrity. - Explore data to gain insights, identify anomalies, and formulate hypotheses, driving informed decision-making. Requirements: - Strong experience in SQL and knowledge of database management systems like Oracle and SQL Server. - Understanding of data warehousing concepts, including ETL processes. - Familiarity with cloud-based data services like Azure, staying up-to-date with emerging technologies. - Excellent communication skills and stakeholder management skills, facilitating collaboration across teams. Seniority Level: Entry-level position, suitable for recent graduates or individuals looking to transition into a career in data modeling and analysis.