Data Analyst

Company Overview: Lean Tech is a rapidly expanding organization situated in Medellín, Colombia. We pride ourselves on possessing one of the most influential networks within software development and IT services for the entertainment, financial, and logistics sectors. Our corporate projections offer a multitude of opportunities for professionals to elevate their careers and experience substantial growth. Joining our team means engaging with expansive engineering teams across Latin America and the United States, contributing to cutting-edge developments in multiple industries. Currently, we are seeking a Mid Data Analyst to join our team. Here are the challenges that our next warrior will face and the requirements we look for:  Position Title: Mid Data Analyst Location: Remote - LATAM What you will be doing: We are seeking a Mid Data Analyst to support a project focused on categorizing and correcting mismatched address records within an existing dataset. This role will involve manual data entry, data validation, and the exploration of potential automation solutions to enhance efficiency. The ideal candidate should have experience in address normalization, geocoding, and data cleansing.

• Analyze and categorize mismatched address records from datasets.
• Manually enter corrected address data into designated systems following defined procedures.
• Develop and implement data cleansing processes using fuzzy matching and other techniques.
• Monitor and improve data quality and accuracy across multiple systems.
• Utilize Microsoft Excel and Power Query for data manipulation and batch processing.
• Collaborate with the team to explore and develop automation tools for data processing tasks.
• Support the integration of RPA solutions with GIS systems as needed.
• Coordinate with stakeholders to resolve any data discrepancies.

Required Skills & Experience:

• Experience with geocoding, data cleansing, and address normalization.
• Advanced accuracy and attention to detail in data entry.
• Ability to identify and resolve address discrepancies across multiple systems.
• Knowledge of postal codes and addressing systems of the United States.
• Intermediate experience with fuzzy matching and data cleansing techniques.
• Proficiency with Microsoft Office suite, particularly Excel and Power Query, for data manipulation.
• Intermediate understanding of batch processing of address data.

Nice to Haves:

• Experience with address verification services like LightBox
• Familiarity with GE Smallworld for GIS applications
• Understanding of spatial analysis techniques
• Proficiency in RPA tools for automation integration
• Experience in using browser automation frameworks such as Selenium, Playwright, or Puppeteer
• Ability to create and maintain automation scripts for data processes

Soft Skills:

• Attention to Detail: Essential for ensuring data entry accuracy and identifying discrepancies in address records, contributing to overall data quality.
• Analytical Thinking: Important for categorizing mismatched addresses and utilizing techniques such as fuzzy matching to improve data accuracy.
• Communication Skills: Necessary for collaborating with team members and stakeholders to resolve data issues and facilitate process improvements.
• Problem-Solving: Critical for finding solutions to address discrepancies and exploring potential automation opportunities.
• Time Management: Required for handling both batch processing and case-by-case data cleansing effectively and efficiently.

Why you will love Lean Tech:

• Join a powerful tech workforce and help us change the world through technology
• Professional development opportunities with international customers
• Collaborative work environment
• Career path and mentorship programs that will lead to new levels.

Join Lean Tech and contribute to shaping the data landscape within a dynamic and growing organization. Your skills will be honed, and your contributions will play a vital role in our continued success. Lean Tech is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.