Data Engineer

OverviewBluelight 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.What We Are Looking ForExperience 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.What You'll Be DoingDevelop 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.Company BenefitsCompetitive 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.Seniority levelMid-Senior levelEmployment typeFull-timeJob functionInformation TechnologyIndustriesSoftware Development#J-18808-Ljbffr