Data Analyst III providing insights for AAA Life Insurance decision - making by analyzing compliance data. Transforming data into actionable recommendations to drive marketing strategies.
About the role
- Technical analyst transforming legacy systems by extracting and validating data for Equiplano's ERP. Collaborating on data engineering processes and ensuring financial data integrity.
Responsibilities
- We are seeking a professional to serve as the primary technical liaison for extracting, processing and validating large volumes of data from legacy systems.
- The professional will be responsible for "translating" third-party databases into Equiplano's data model, ensuring the client's accounting, payroll and tax history are preserved accurately.
- Data Engineering & ETL: Extract data from different sources and formats (relational databases, .txt and .csv files, competitor backups) for import into Equiplano's ERP.
- Analysis & Cleansing: Identify inconsistencies, duplicates and errors in source data prior to migration.
- Mapping (From/To): Create correlation scripts and mappings between the source-system tables and the Equiplano system.
- Business Validation: Support the verification of migrated data (e.g., reconcile accounting balances, check employee histories) to ensure the integrity of public records.
- Automation: Develop scripts and routines (SQL/Python) to automate repetitive data-cleaning and conversion tasks.
Requirements
- Bachelor's degree in Computer Science, Information Systems, Database Management or related fields.
- Advanced proficiency in SQL (writing complex queries, joins, views and stored procedures).
- Proven experience working with databases (PostgreSQL, Oracle, SQL Server or Firebird).
- Preferred: Knowledge of programming logic or scripting languages (Python or C#).
- Advanced Excel skills.
- Knowledge of Public Sector accounting and management rules (CASP - Accounting Applied to the Public Sector, PCASP, Payroll Event Table, Laws 8.666/14.133).
Benefits
- 👶 Childcare allowance to support your family needs.
- 🍱 iFood card — valid for food and meals to simplify your daily dining.
- 🎁 Birthday bonus so you can celebrate your special day.
- 🛍️ Colmeia Shop — exclusive platform with special product discounts.
- 🎓 Partnerships with educational institutions to support your professional development.
- ⏳ Perrengue Day — an annual personal day off to use as you prefer.
- 💻 Fleury — access to online medical consultations.
- ✈️ OnHappy — benefits and discounts for travel.
- 🚀 Career advancement opportunities; we want you to grow with us.
- 🦷 Dental plans through Dental Uni for continuous dental care.
- 🏷️ Private pension plan for a secure future.
- 🩺 Health plan with Unimed to ensure your well-being.
- 👨👩👧👦 Life insurance for you and your family’s protection.
- 🏋️♂️ Wellhub — access to gyms to support your health and wellness.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Demand Analyst developing demand forecasts using statistical and machine learning models in Nestlé's Supply Chain team. Collaborating with planners and analysts to enhance forecasting tools and processes.
Data Analyst role at fintech focusing on financial and operational data analytics for business insights. Collaborating with teams to enhance decision - making processes.
Data Analyst role within Customer Data Operations team optimizing customer risk data using advanced analytical skills. Collaborating closely with SMEs, Product, and Engineering teams to improve data processes.
Analyst managing technical governance for global account in APAC Analytics. Responsible for global data collection and e - commerce operations across regional markets.
Data Analyst using Power BI and CRM systems to generate marketing intelligence for Rede Lius Agostinianos. Responsible for data collection, analysis, and reporting to enhance marketing strategies.
Senior Data Analyst leveraging data to support Clair's mission of financial freedom for America’s workers. Collaborating with product and business teams to drive growth and improve user experience.
Data Engineer / Data Analyst improving data analytics for tourism sector. Collaborate on data integration and support predictive analytics with strong technical skills.
Data Analyst at Nium analyzing transaction and risk data. Leveraging SQL and analytics to translate insights into risk rules and operational decisions.
Data Analyst responsible for collecting and analyzing data for insights at a pet nutrition company. Collaborating on reports, dashboards, and process improvements.