The Role
The Data Engineer will resolve data issues in the MDM system, optimize data models, write complex SQL queries, and utilize AWS resources for data analysis.
Summary Generated by Built In
Position Overview:
We are looking for an experienced Data Engineer to join our dynamic team. If you are passionate about building scalable software solutions, have expertise in system design and data structures, and are familiar with various databases, we would love to hear from you.
ShyftLabs is a growing data product company that was founded in early 2020 and works primarily with Fortune 500 companies. We deliver digital solutions built to help accelerate the growth of businesses in various industries, by focusing on creating value through innovation.
Job Responsibilities:
- Act as the first point of contact for data issues in the Master Data Management (MDM) system.
- Investigate and resolve data-related issues, such as duplicate data or missing records, ensuring timely and accurate updates.
- Coordinate with the Product Manager, QA Lead, and Technology Lead to prioritize and address tickets effectively.
- Work on Data related issues, ensuring compliance with regulations.
- Build and optimize data models to ensure efficient storage and query performance, including work with Snowflake tables.
- Write complex SQL queries for data manipulation and retrieval.
- Collaborate with other teams to diagnose and fix more complex issues that may require code changes or system updates.
- Utilize AWS resources like CloudWatch, Lambda, SQS, and Kinesis Streams for data storage, transformation, and analysis.
- Update and maintain the knowledge base to document common issues and their solutions.
- Monitor system logs and alerts to proactively identify potential issues before they affect customers.
- Participate in team meetings to provide updates on ongoing issues and contribute to process improvements.
- Maintain documentation of data engineering processes, data models, and system configurations.
Basic Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Minimum of 6+ years of experience in data engineering, preferably related to MDM systems.
- Strong expertise in SQL and other database query languages.
- Hands-on experience with data warehousing solutions and relational database management systems (RDBMS).
- Proficiency in ETL tools and data pipeline construction.
- Familiarity with AWS services.
- Excellent programming skills, preferably in Python.
- Strong understanding of data privacy regulations like DSAR and CCPA.
- Good communication skills, both written and verbal, with the ability to articulate complex data concepts to non-technical stakeholders.
- Strong problem-solving skills and attention to detail.
We are proud to offer a competitive salary alongside a strong insurance package. We pride ourselves on the growth of our employees, offering extensive learning and development resources.
Top Skills
AWS
ETL
Python
Snowflake
SQL
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
We provide customized data and analytics consulting services, including automation and software development for a sustainable and intuitive digital transformation.
