Data Engineer

Overview

Bluelight Consulting is a leading software consultancy dedicated to designing and developing innovative technology that enhances users' lives. We focus on quality and customer satisfaction and foster a collaborative environment for professional growth. With a presence across the United States and Central/South America, Bluelight is expanding and seeking exceptional talent to join its diverse team.

We are looking for a skilled data engineer to join our rapidly growing team. This role suits someone who thrives in a fast-paced environment where ideas and efforts are valued. You will contribute to challenging projects, developing high-quality applications and data solutions. We value continuous learning and collaboration to support professional development. If you are passionate about software development and eager to be part of a growing consultancy, we invite you to apply.

• Experience with AWS services including but not limited to S3, Athena, EC2, EMR, and Glue.
• Ability to solve ongoing issues with operating the cluster.
• Experience with integration of data from multiple sources.
• Experience with databases such as SQLServer, Redshift, Postgres, and RDS.
• Experience with data integration platforms such as Pentaho Kettle, SnapLogic, Talend OpenStudio, Jitterbit, Informatica PowerCenter, or similar.
• Knowledge of IT operations best practices for an always-up service.
• Experience with Agile Software Development methodologies.
• Excellent problem-solving and troubleshooting skills.
• Excellent oral and written communication skills with a strong customer service orientation.
• Experience with collecting, managing, and 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 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 concepts: star schemas, change data capture, denormalization.
• SQL/DDL queries and tuning techniques (indexing, sorting, distribution).
• BS or MS degree in Computer Science or a related technical field.
• 3+ years of Data Pipeline development experience with tools such as SnapLogic, Datastage, Informatica, or related.
• 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 applications and reporting databases to describe objects and fields for support documentation and to facilitate custom application development and data integration.
• Monitor execution and performance of daily pipelines, triage and escalate issues.
• Collaborate with analytics and business teams to improve data models and data pipelines that feed business intelligence tools, increasing data accessibility and enabling data-driven decisions.
• Implement processes and systems to monitor data quality, ensuring production data is accurate and available for stakeholders.
• Write unit/integration tests, contribute to engineering wiki, and document work.
• Perform data analysis to troubleshoot data-related issues and assist in issue resolution.
• Work within AWS/Linux cloud environment in support of data integration solutions.
• Collaborate with frontend and backend engineers, product managers, and analysts.
• Teamwork: share knowledge and follow directions when provided.

• Competitive salary and bonuses, including performance-based increases.
• Generous paid time off policy.
• Technology/Office stipend.
• Health coverage.
• 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 valued by clients and often have a direct impact on their business. You will work on a variety of projects with cutting-edge technologies and collaborate with top professionals in the industry.

If you’re eager to be part of an exciting, challenging, and rapidly growing consultancy, we encourage you to apply.

• Mid-Senior level

• Full-time

• Information Technology

• Software Development