Data Engineer I

Company Description

Sundance… A Place. An Idea. Celebrating and Enriching the Human Experience.

Job Description

LOCAL CANDIDATES ONLY

The Data Engineer is responsible for building, maintaining, and optimizing data pipelines, as well as ensuring that the organization’s data infrastructure is capable of handling large volumes of structured and unstructured data. This position will work closely with analysts, and other teams to deliver high-quality, reliable, and efficient data systems that support data analytics and business intelligence needs.

Key Responsibilities:

Data Pipeline Design & Development:

• Build Data Pipelines: Design, develop, and manage scalable and efficient data pipelines that facilitate the extraction, transformation, and loading (ETL) of data from various sources to data storage systems.
• Data Integration: Integrate diverse data sources (databases, APIs, third-party tools, etc.) to provide a unified and coherent data environment.
• Automation: Automate data extraction and transformation processes to improve efficiency and reduce manual intervention.

Database & Data Storage Management:

• Database Design & Management: Work with relational databases to store, retrieve, and manage large volumes of data. Ensure databases are optimized for both storage and performance.
• Data Provisioning: Architect, build, and manage data marts or data lakes that support large-scale analytics and reporting needs.
• Data Modeling: Collaborate with data architects and analysts to design data models and structures to support and improve operations.

Data Quality & Performance:

• Ensure Data Quality: Monitor data quality and accuracy, implementing data validation and transformation rules to clean and preprocess data.
• Monitor Data Pipeline Performance: Continuously monitor data pipelines to identify and address performance bottlenecks or failures in real time.

• Data Access and Reporting: Ensure that data is easily accessible for business intelligence tools, dashboards, and reporting applications.

Optimization & Scaling:

• Performance Optimization: Optimize data pipelines for speed and efficiency to handle high data volume, ensuring minimal latency.
• Scalability: Design and implement data systems that can scale horizontally to accommodate the increasing volume, variety, and velocity of data as the business grows.

Collaboration with Peers and Business Owners:

• Collaborate with Peers to understand business requirements and deliver data systems that support advanced analytics, machine learning models, and reporting.

Qualifications

Required Skills and Qualifications:

• Education: Bachelor’s degree in Computer Science, Information Technology, Engineering, a related field, or equivalent experience.

• Experience: Background in data engineering, software engineering, or a related field, with a strong focus on building data pipelines and managing data infrastructure
• Problem-Solving Skills: Strong analytical and troubleshooting skills to solve complex data-related challenges.
• Communication Skills: Ability to communicate effectively with both technical and non-technical stakeholders, ensuring alignment with business goals and data needs.

• Technical Skills:
  • Proficiency in programming languages such as Python, or SQL.
  • Strong knowledge of relational databases (e.g., MS SQL Server, MySQL, PostgreSQL).
  • Experience with data warehousing solutions, ETL tools, and data integration processes.

Helpful Skills:

• Machine Learning / AI Engineering: Knowledge of machine learning algorithms and how they can facilitate data-driven decision making.
• Scripting and query languages: GraphQL, Powershell, R.
• Data Visualization: Familiarity with data visualization tools like Tableau, Power BI, or other dashboard/reporting tools.
• Development tools: Understanding of Jupyter Notebooks for data pipeline development, and IDEs like VS Code.
• Retail and E-commerce: Experience working with ERP (Enterprise Resource Planning) and WMS (Warehouse Management Systems) in a retail environment, with an understanding of how data flows between inventory, order management, and fulfillment systems. As well as Shopify or similar platforms.

Additional Information

Work Environment:

• Full-time position. Mon-Thur - In-Office. Fri - Remote
• Collaborative, fast-paced design environment.

We offer a competitive wage and excellent benefits package including medical, dental, vision, life, disability, 401(k), paid time off, and great merchandise discounts. 

For more information about our culture and brand at Sundance, please visit https://careers.smartrecruiters.com/SundanceHoldingsGroupLLC

For the Sundance Story, visit: https://www.sundancecatalog.com/category/customer+service/about+us.do

Sundance is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, childbirth and related medical conditions, lactation, genetic information, gender, sexual orientation, gender identity or expression, military service, veteran status, or any other category protected under federal, state, or local law.

All applicants have rights under Federal Employment Laws, including Family and Medical Leave Act (FMLA), Equal Employment Opportunity (EEO) and Employee Polygraph Protection Act (EPPA).