Data Engineer - Remote, Latin America
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.
We are looking for a skilled individual to join our rapidly growing team at Bluelight Consulting . This position is ideal for someone who thrives in a fast-paced, dynamic environment where everyone's opinions and efforts are valued and appreciated. You will have the opportunity to contribute to challenging and meaningful projects, developing high-quality applications that stand out in the market. We value continuous learning, personal growth, and hard work, offering a collaborative environment that promotes professional development. If you are passionate about software development and eager to be part of a growing software consultancy, we invite you to apply and join us on this exciting journey.
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 escalate 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