The Data Management Analyst Consultant plays an important role in the implementation of Enterprise Data Management (EDM) Solutions for EXL Data Management. Consultants will work on a variety of tasks ranging from requirements gathering/analysis, data profiling, preparing functional and technical documentation, and deployment tasks. This is a business-facing role that works independently and collaboratively with internal and client teams to ensure project success. The Data Management Analyst Consultant drives and participates in discovery and design sessions and is involved in all aspects of data management implementations, including translation of architecture and design documentation into configured solution components, including data models, mappings, rules, reports, and more. The Data Management Analyst Consultant should have practical experience extracting and analyzing large amounts of data using SQL queries from a data warehouse environment. This position will have the opportunity to engage with clients utilizing all aspects of a Data Management organization, including Data Governance, Data Quality, MDM, and Business Intelligence. You will also be working closely with Cloud, Big Data, Data Modeling, Data Engineering, and Project Management consultants. They must be able to work well in multi-functional and multi-shore project teams.

60% Analysis/Development/Testing

- Gathers business and technical requirements utilizing interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, tasks, and workflow analysis.
- Documents business and technical specifications, ensuring documentation is kept up to date and relevant.




- Assists in source definition for the data warehouse attributes. Maps attributes to source, including identification and documentation of transformation algorithms as necessary.
- Generates cohesive documentation of: Business processes/process maps (As Is – To Be), functional and technical specifications, and use cases.
- Identifies instances where existing data management processes may be streamlined or improved.
- Performs gap analysis of policies, processes, and capabilities against frameworks or desired target states.
- Develops data dictionaries, source to target data mappings, and business glossary by working with the Data SME and Business stakeholders.
- Develops business rules to assist with data acquisition, data integration, and data quality monitoring.
- Gathers and documents existing reports, analysis, and data access requirements
- Performs data collection, profiling, validation, cleansing, analysis, and reporting from various sources, including databases and flat files.
- Analyzes data volumes, data types, and content to support the design of data architecture solutions.
- Assesses and documents the structure, quality, and conformance of source data
- Initiates analysis to identify data inconsistencies and resolve in order to raise the level of data integrity.
- Identifies, analyzes,



and interprets trends or patterns found within data and makes recommendations for business and process improvement.
- Tests and documents ETL processes, SQL queries, and stored procedures.

30% Communication/Organization/Documentation/Leadership

- Communicates consistently with other team members, leadership, and clients, outlining status, risks, issues, and key decisions.
- Assist tech lead and developers with addressing business and data-related questions and concerns.
- Coordinates with Project Managers and participates in project planning.
- Participates in feasibility analysis, scopes projects, and works with the project manager to prioritize deliverables.
- Acts as the liaison between the business units, technology teams, and support teams.
- Creates reports as required to support stakeholders and project team.

10% Other duties as assigned or identified

Education & Experience

- 4+ years of experience in an Analyst role.
- 2+ years of consulting experience strongly preferred.
- Practical experience in at least 2 of the following areas:
- Data Integration/Movement.
- Data Quality.
- Master Data Management.
- Data Governance.
- Business and Data Analysis.
- Data Modeling.
- Experience in identifying and documenting business requirements in a data management environment, including the use of joint application design facilitation or other requirements gathering techniques.
- Experience working with business and IT functions in a variety of corporate cultures, as both an employee and consultant, is preferred.
- Strong verbal and written communication skills, with an ability to express complex technical concepts in business t

📌 Analista de datos (Bogotá, D.C.)
🏢 EXL
📍 Bogotá, D.C.