Data Engineer - Latin America, Remote

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.

• 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, Snap Logic, Talend Open Studio, Jitterbit, Informatica Power Center, 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 Good Data (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 Snap Logic or Datastage, Informatica, or related experience.

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

• Experience designing, building, and maintaining data pipelines.

• 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,…