AM53 Smart Solutions

Data Engineer II

AM53 Smart Solutions

full-time

Posted on:

Location Type: Remote

Location: Brazil

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

ApacheETLPythonSparkSQL

About the role

  • Design, code, test, debug and document programs and scripts using agreed standards and tools, ensuring well-structured deliverables.
  • Ensure data quality and implement tools and frameworks to automate the detection of data quality issues.
  • Profile data sources and develop ETL processes, with knowledge of data modeling fundamentals, using SQL, Python and ETL/ELT support tools.
  • Assist management in preparing estimates and proposals for clients.
  • Plan effective solutions for data storage, security, sharing and publication within the organization.
  • Create and update documentation of process flows and business rules.
  • Maintain existing pipelines and process large volumes of data as needed.

Requirements

  • Bachelor's degree in Computer Science, Statistics, Mathematics or a related field.
  • 3 to 5 years of experience in Data Engineering and/or Data Warehousing.
  • Experience designing and developing ETL/ELT data pipelines.
  • Proficiency in writing advanced SQL queries.
  • Proficiency in Python and various Python libraries.
  • Strong analytical skills, with the ability to understand and communicate the meaning of presented data.
  • Excellent mathematical, statistical and logical skills.
  • Excellent reasoning ability.
  • Enthusiastic, highly motivated, quick learner.
  • Experience creating ETL workflows in Databricks.
  • Understanding of Apache Spark.
Benefits
  • Flexible meal/food allowance – R$ 37.47/day
  • Home-office allowance: R$ 70.00 (hybrid model)
  • Dental plan – SulAmérica Odonto (basic plan 20 – R$ 15.13 or executive plan 20 – R$ 68.67) optional
  • Health plan – Bradesco options: EECO/Efetivo Enfermaria (R$ 150.00 + co-participation) OR CFXQ (Flex) Apartment (R$ 200.00 + co-participation) mandatory
  • Medical and dental assistance with eligibility to include legal dependents (spouse and children), subject to eligibility and co-participation deduction
  • SulAmérica life insurance coverage up to 24 months' salary (50% paid by the employee); calculation: Salary x 24 x 0.00020 / 2
  • Optional transportation allowance
  • TotalPass
  • Partnership with SESC.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLPythonETLELTdata modelingdata profilingdata qualitydata engineeringdata warehousingadvanced SQL queries
Soft Skills
analytical skillscommunication skillsmathematical skillsstatistical skillslogical skillsreasoning abilityenthusiasmmotivationquick learner
Certifications
Bachelor's degree in Computer ScienceBachelor's degree in StatisticsBachelor's degree in Mathematics