Data Engineer - INTL Brazil

Insight Global; Northbrook (IL); On-site; USD 135,000 - 190,000; Full time

Job summary

Insight Global is seeking a Senior Data Engineer to design, build, and maintain a data lakehouse and pipelines across bronze, silver, and gold zones. You will ensure data quality and scalable analytics powering enterprise reporting and AI use cases.

You will collaborate with stakeholders to translate requirements into robust data architectures, drive governance, and lead performance optimizations across cloud platforms such as Snowflake and Azure.

Qualifications

• Bachelor’s degree in CS/Engineering/Math or related field.
• Strong experience with data transformation, ETL/ELT and data management.
• Deep SQL experience and optimization skills.

Responsibilities

• Lead end-to-end delivery of complex data and analytics solutions.
• Design and optimize data pipelines and analytics models for BI and analytics.
• Assess source systems and set data standards and governance.
• Translate requirements into technical designs and plans.
• Promote data architecture best practices and cost efficiency.
• Mentor teammates and perform design/code reviews.
• Lead root cause analysis and performance improvements.
• Improve delivery processes for speed and quality.
• Implement data governance features such as lineage and data quality checks.
• Collaborate with platform teams on Snowflake, Azure, and cloud tuning.

Skills

ETL/ELT

SQL optimization

Dimensional modeling

Cloud data platforms

Data governance

Agile

NoSQL databases

ML concepts

Communication

Team collaboration

Education

Bachelor's degree in Computer Science, Engineering, Mathematics or related field

Job description

Job Description

The Senior Data Engineer plays a senior role in the design, development, and maintenance of constructing and populating a data lakehouse. This position helps develop and improve processes and techniques that ensure efficient data processing and high data quality to power analytics. The role applies technical expertise to design data architecture and data models and to build pipelines that populate the various data zones (bronze, silver, and gold) within a data lakehouse architecture.

JOB RESPONSIBILITIES:

Lead end-to-end technical delivery of complex data and analytics solutions, ensuring scalability, reliability, and alignment to business outcomes

Design, build, and optimize data pipelines and analytical data models (batch and near real-time) to support enterprise reporting, BI, and advanced analytics use cases

Assess source systems and data quality, defining transformation logic, data standards, and controls to meet business definitions and governance requirements

Partner with business and technical stakeholders to translate requirements into technical designs, and contribute to estimation, planning, and delivery sequencing

Drive data architecture and engineering best practices, including modular design, reusability, performance optimization, and cost efficiency

Mentor and coach team members, elevating overall engineering capability through guidance, knowledge sharing, and hands-on support

Perform code and design reviews, ensuring adherence to standards, maintainability, and optimal performance of data solutions

Lead root cause analysis and issue resolution, implementing preventative measures and performance improvements across pipelines and platforms

Continuously improve delivery processes, identifying opportunities to increase speed, quality, automation, and reliability

Implement and enforce data governance practices, including lineage, documentation, data quality checks, and secure data handling

Collaborate with platform and infrastructure teams to ensure optimal use of cloud data platforms (e.g., Snowflake, Azure), including performance tuning and cost management

Support DevOps and CI/CD practices for data engineering, including automated testing, deployment pipelines, and environment management

Ensure operational excellence, including monitoring, alerting, and SLAs for critical data pipelines and data products

Contribute to platform strategy and tool selection, evaluating new technologies to enhance data engineering capabilities and self-service enablement

Reads and follows the Underwriters Laboratories Code of Conduct and all physical and digital security practices.

Performs other duties as directed. None of the foregoing information in any way states or implies that these are the only duties to be performed by an employee occupying this position. Employees will be required to follow other job-related instructions and perform other job-related duties as requested. Duties are not necessarily comprehensive and are subject to change at any time at the discretion of management. Consult the position qualifications for this job when using the position profile for hiring, transfer, or promotion decisions or when providing career guidance.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• Bachelor’s degree in Computer Science, Engineering, Mathematics or related field
• Deep Experience with data transformation, ETL/ELT and data management
• Deep Experience with writing and optimize complex SQL
• Experience with data modeling using dimensional modeling techniques (Star Schema)
• Experience in cloud infrastructure, computing, on Big Data platforms
• Understanding of structured, unstructured, semi-structured data
• Experience with data streaming, messaging, and event driven data architecture
• Knowledge in data governance and data quality frameworks
• Experience of working in an Agile environment
• Experience working with all NoSQL Databases e.g. Graph, Document, Column
• Knowledge of machine learning and artificial intelligence concepts
• Ability to articulate an idea with strong communication and presentation skills
• Work as part of a small team, sharing ideas and contributing to the strategic goals