Data Engineer - Latin America, Remote

Remote; San Francisco (CA); Remote; USD 120,000 - 160,000; Full time

Benefits offered by this job

Competitive salary and bonuses

Generous paid-time-off

Remote work option

Continuing education and certificates

Job summary

Bluelight Consulting is seeking a Data Engineer to design, build, and maintain data pipelines across AWS services, various databases, and BI tools. You will work with analytics and engineering teams to ensure scalable, high-quality data solutions.

Key responsibilities include data modeling, data quality monitoring, and collaboration to drive data-driven decision-making. Remote-friendly with growth opportunities in a collaborative environment.

Qualifications

• BS or MS degree in CS or related technical field.
• 3+ years of Data Pipeline development experience.
• 3+ years of SQL experience.
• Experience with data integration and data warehouse design.

Responsibilities

• Develop and maintain data models for core package application and reporting databases.
• Monitoring execution and performance of daily pipelines, triage and elevate issues.
• Collaborates with analytics and business teams to improve data models and data pipelines.
• Implements processes to monitor data quality and availability for stakeholders.
• Writes unit/integration tests and documents work.

Skills

AWS services

Data integration

SQL & databases

ETL / data pipelines

Agile methodologies

Problem solving

Communication skills

Data governance

Education

BS or MS in Computer Science

Tools

Pentaho Kettle

Informatica PowerCenter

Talend OpenStudio

Jitterbit

GoodData

Tableau

Power BI

Git

SQL Server

Redshift

Job description

Bluelight Consulting is a leading software consultancy dedicated to designing and developing innovative technology that enhances users' lives. With a steadfast commitment to delivering exceptional service to our clients, Bluelight excels in its focus on quality and customer satisfaction. Our mission is not only to create cutting-edge applications but also to foster a collaborative and enriching work environment where each team member can grow and thrive. With a presence across the United States and Central/South America, Bluelight is in an exciting phase of expansion, continually seeking exceptional talent to join its dynamic and diverse community.

What we are looking for

• Experience with AWS services including but not limited to S3, Athena, EC2, EMR, and Glue.

• Ability to solve any ongoing issues with operating the cluster.

• Experience with the integration of data from multiple data sources.

• Experience with various database technologies such as SQLServer, Redshift, Postgres, and RDS.

• Experience with one or more of the following data integration platforms: Pentaho Kettle, SnapLogic, Talend OpenStudio, Jitterbit, Informatica PowerCenter, or similar.

• Knowledge of best practices and IT operations in an always-up, always-available service.

• Experience with or knowledge of Agile Software Development methodologies.

• Excellent problem-solving and troubleshooting skills.

• Excellent oral and written communication skills with a keen sense of customer service.

• Experience with collecting/managing/reporting on large data stores.

• Awareness of Data governance and data quality principles.

• Well-versed in Business Analytics including basic metric building and troubleshooting.

• Understand Integration architecture: application integration and data flow diagrams, source-to-target mappings, data dictionary reports.

• Familiar with Web Services: XML, REST, SOAP.

• Experience with Git or similar version control software.

• Experience with integrations with and/or use of BI tools such as GoodData (preferred), Tableau, PowerBI, or similar.

• Broad experience with multiple RDBMS: MS SQLServer, Oracle, MySQL, PostgreSQL, Redshift.

• Familiarity with SaaS/cloud data systems (e.g. Salesforce).

• Data warehouse design: star-schemas, change data capture, denormalization.

• SQL/DDL queries/Tuning techniques such as indexing, sorting, and distribution.

• BS or MS degree in Computer Science or a related technical field.

• 3+ years of Data Pipeline development such as SnapLogic or Datastage, Informatica, or related experience.

• 3+ years of SQL experience (No-SQL experience is a plus).

• Experience designing, building, and maintaining data pipelines.

What you'll be doing

• Develop and maintain data models for core package application and reporting databases to describe objects and fields for support documentation and to facilitate custom application development and data integration.

• Monitoring execution and performance of daily pipelines, triage and elevate any issues.

• Collaborates with analytics and business teams to improve data models and data pipelines that feed business intelligence tools, increasing data accessibility and fostering data-driven decision-making across the organization.

• Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes.

• Writes unit/integration tests, contributes to engineering wiki, and documents work.

• Performs data analysis required to troubleshoot data-related issues and assist in the resolution of data issues.

• Work within AWS/Linux cloud systems environment in support of data integration solution

• Works closely with a team of frontend and backend engineers, product managers, and analysts.

• Teamwork: Collaborate with team members. Share knowledge, provide visibility of interpersonal accomplishments and follow directions when provided.

Company Benefits

• Competitive salary and bonuses, including performance-based salary increases.

• Generous paid-time-off policy

• Flexible working hours

• Work remotely

• Continuing education, training, conferences

• Company-sponsored coursework, exams, and certifications

Being a consultant in our team is a fun, challenging, and rewarding career choice. Your contributions are highly valued by clients, and the work you do often has a direct and significant impact on their business.

You will have the opportunity to work on a variety of projects for our incredible clients, which will accelerate your career growth. You’ll collaborate with modern technologies and work alongside some of the best professionals in the industry!