Sr. Data Engineer

Sr Data Engineer

About VENUS

VENUS is a leading women’s fashion brand offering clothing, swimwear, and lingerie in sizes 2-24. Founded in 1984 and headquartered in Jacksonville, Florida, VENUS’ unique products inspire Fun. Sexy. Style. and help our customers to make an impression in every moment of their lives.

This role is an opportunity to join a growing organization with transparent leadership and to work in an innovative environment with other passionate and hard-working people. Sustainability, diversity, and inclusion are core values of our brand and are central to the company’s engaging culture. If you would like to be part of our inclusive, forward-thinking, and collaborative team, we encourage you to apply today!

JOB DESCRIPTION:

The Sr Data Engineer will map source system data to data warehouse models, develop and test ETL processes, define and capture metadata and rules associated with ETL processes, and adapt ETL processes to accommodate changes in source systems and new business user requirements.

Responsibilities will include designing, programming, debugging, and supporting large-scale solutions on-prem and in the cloud (Google Cloud). Specifically, you’ll be designing and scaling the data engineering efforts for our Venus digital marketing products and platforms.

In this role, you'll work on understanding business problems so that you can build data solutions that allow people to make data-driven decisions. You'll develop a deep understanding of existing processes and data.

ESSENTIAL DUTIES & RESPONSIBILITIES:

Include the following. Other duties may be assigned:

• Responsible for establishing solid data requirements to integrate data from a variety of different data sources into the Venus Data Platform

• Clean, prepare and optimize data for ingestion and consumption in support of large, complex, scalable, end-to-end solutions

• Work with various stakeholders to identify and understand source data and source systems.
• Developing and testing ETL jobs/pipelines, configuring orchestration, configuring automated CI/CD, writing automation scripts, and supporting the pipelines in production.

• Collaborate with product owners, architects, analysts, and business users to design, implement, and deliver successful data solutions
• Troubleshoot complex, high-risk data issues and perform root cause analysis to proactively resolve product and operational issues
• Be an active participant and advocate of agile/scrum practice to ensure health and process improvements for your team
• Innovate constantly and stay current with the latest Big Data technologies while staying focused on solving large-scale and challenging problems in ecommerce.
• Mentor and develop other data engineers

CORE COMPETENCIES:

• Decision Quality: Making good and timely decisions that keep the organization moving forward.
• Collaborates: Building partnerships and working collaboratively with others to meet shared objectives.
• Customer Focus: Build strong customer relationships and delivering customer-centric solutions.
• Action Oriented: Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Situational Adaptability: Adapting approach and demeanor in real time to match the shifting demands of different situations.
• Communicates Effectively: Developing and delivering multi-mode communications that convey clear understanding of the unique needs of different audiences.

JOB BASED COMPETENCIES:

• Resourcefulness: Securing and deploying resources effectively and efficiently.
• Demonstrate Self-Awareness: Using a combination of feedback and reflection to gain productive insight into personal strengths and weaknesses.
• Self-Development: Actively seeking new ways to grow and be challenged using both formal and informal development channels.

QUALIFICATIONS:

• 8+ years of experience with relational database architecture, design and development
• 5+ years of experience working with ETL tools or Advanced SQL
• 3+ years of experience working on/ managing Data Warehousing projects (cloud preferred)
• Experience in programmatic ETL job/pipelines using open-source technologies on-prem and in the cloud
• Experience in developing shell scripting and automation
• Experience writing analytical SQL queries and in performance-tuning queries
• Understanding of the Systems Development Life Cycle (SDLC) using agile techniques
• Experience working in cloud solutions (Google Cloud preffered)
• Ability to work well in a team environment and independently
• Strong communication skills
• Strong analytical and critical thinking skills
• Attention to detail

EDUCATION:

• BA/BS degree in Computer Science or related engineering field or equivalent combination of education and experience