Analista de datos

EXL; Bogotá ciudad; Presencial; COP 60 000 000 - 120 000 000; Tempo integral

Resumo da oferta

EXL is seeking a Data Management Analyst Consultant in Bogotá to contribute to EDM implementations. You will gather requirements, document specifications, and design data mappings and rules while collaborating with client teams and various data management domains.

You will work with SQL in data warehouse environments, engage with Data Governance, Data Quality, MDM, and BI teams, and participate in discovery, design, and deployment activities across multi-shore projects.

Qualificações

• 4+ years of experience in an Analyst role.

Responsabilidades

• Gathers business and technical requirements using interviews, document analysis, workshops, surveys, site visits, and use cases.
• Documents business and technical specifications and keeps documentation up to date.
• Maps data attributes and sources; documents transformations as needed.
• Develops data dictionaries, source-to-target mappings, and business glossary.
• Develops business rules for data acquisition, integration, and quality monitoring.
• Performs data collection, profiling, validation, cleansing, analysis, and reporting from multiple sources.
• Analyzes data volumes, types, and content to support data architecture design.
• Assesses data structure, quality, and conformance; identifies inconsistencies and improves data integrity.
• Identifies trends and suggests business/process improvements.
• Tests and documents ETL processes, SQL queries, and stored procedures.

Conhecimentos

SQL

Data Modeling

ETL

Data Governance

BI

Tableau

Power BI

Data Quality

Ferramentas

Tableau

Power BI

Descrição da oferta de emprego

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 terms and complex business concepts in technical terms.
• Solid organizational and analytical abilities.

Knowledge, Skills & Abilities

• Knowledge of data management industry (DW, BI, BD, Cloud, MDM, DG, DQ, Data Modeling).
• Demonstrated experience with or certification in data management or related frameworks preferred; ability to attain proficiency and obtain certifications required.
• Leverage general business experience with knowledge to convert high level business objectives into functional and technical requirements and specifications.
• Ability to consult with functional leaders to understand business objectives in order to design optimized data solutions.
• Capacity to help facilitate and guide discovery and design sessions with business SME’s and technical leads.
• Ability to multi-task, prioritize, and meet aggressive deadlines.
• Ability to organize, prioritize, and manage dependencies.
• Ability to lead group facilitation, mediation, and conflict resolution.
• Excellent interpersonal skills and the ability to deal effectively in a team environment.
• Strong internal communication skills, including the ability to work with all levels of the organization.
• Demonstrated work ethic, focus, and self-discipline.
• Is effective in a variety of formal project and external presentation/meeting settings: one-on-ones, small and large groups, with peers, and superiors.
• Knowledge and understanding of Business Intelligence (Tableau, Power BI) reporting.
• Knowledge and understanding of data quality concepts.
• Excels in a fast-paced, agile environment where critical thinking and strong problem-solving skills are required for success.

EXL Overview

EXL (NASDAQ: EXLS) is a leading operations management and analytics company that designs and enables agile, customer‑centric operating models to help clients improve their revenue growth and profitability. Our delivery model provides market‑leading business outcomes using EXL’s proprietary Business EXLerator Framework™, cutting‑edge analytics, digital transformation, and domain expertise. At EXL, we look deeper to help companies improve global operations, enhance data‑driven insights, increase customer satisfaction, and manage risk and compliance. EXL serves the insurance, healthcare, banking and financial services, utilities, travel, transportation, and logistics industries. Headquartered in New York, New York, EXL has more than 60,000 professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), South America, Australia, and South Africa. For more information, visit www.exlservice.com.

Physical Demands and Working Conditions

Works in a normal office environment requiring light physical effort by handling objects up to 20 pounds occasionally and/or up to 10 pounds frequently. Works with standard office equipment (such as phone, fax, and personal computer). Ability to navigate stairs frequently during the course of a business day in various work locations. Sitting at desk for most of day, and working with the computer.

EEO/Minorities/Females/Vets/Disabilities

EXL is an equal opportunity employer and will provide reasonable accommodation to those individuals who are unable to be vaccinated, consistent with federal, state, and local law.

*The base salary range represents the low and high ends of the EXL base salary range for this position. Actual salaries will vary depending on factors including but not limited to: location and experience. The base salary range listed is just one component of EXL's total compensation package for employees. Other rewards may include bonuses, as well as a Paid Time Off policy, and many region‑specific benefits.”