Senior Systems Analyst, Data Engineer

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Gather and analyze business requirements concerning data.

• Create conceptual, logical, and physical data models.

• Build, optimize, and maintain data pipelines (ETL/ELT).

• Integrate data from diverse sources and enterprise systems.

• Ensure the quality, governance, traceability, and consistency of data.

• Collaborate with Architects, Data Engineers, Data Scientists, and business stakeholders.

• Generate technical and functional documentation.

• Monitor and enhance data loading and transformation processes.

• Assist in the advancement of the organization’s data architecture and best practices.

⛳️ Requirements

• Extensive experience in conceptual, logical, and physical data modeling.

• Familiarity with dimensional modeling (Star Schema and Snowflake schema).

• Experience with Data Warehouse, Data Mart, and Data Lake.

• Proficient in SQL.

• Experience with relational databases (SQL Server, Oracle, PostgreSQL, and MySQL).

• Development and upkeep of ETL/ELT pipelines.

• Data integration across APIs, enterprise systems, and various sources.

• Expertise in data cleansing, transformation, enrichment, and quality assurance.

• Programming skills in Python and SQL.

• Experience with Cloud environments (Azure, AWS, or GCP).

• Understanding of Data Lakehouse architecture.

• Code versioning proficiency with Git.

• Experience in defining business requirements and creating technical documentation.

• Background in corporate data projects and analytical environments.

🏝️ Benefits

• Meal allowance or meal voucher;

• Discounts on courses, universities, and language institutions;

• Stefanini Academy — a platform offering free, up-to-date online courses and certificates;

• Mentoring;

• Benefits club for medical consultations and exams;

• Health insurance;

• Dental coverage;

• Discount and perks club at partner establishments;

• Travel club;

• Pet benefit.