Remote Data Engineer

Scottsdale, AZ, United States

Scottsdale, AZ

About This Role

Hello prospective pickle! Design Pickle is looking for a Data Engineer to join our team and help us develop new ways to inspire our customers and streamline processes for our global network of creatives. You will be tasked to build and maintain the right data pipelines and data models to power our decision-making and enable actionable insights.

The ideal candidate will be able to create efficient, flexible, extensible, and scalable data models, ETL designs, and data integration services. They will also be required to support and manage the growth of these data solutions. Given our aspirational vision, to be the most helpful creative platform in the world, and the nature of our products, this role requires entrepreneurial drive and thinking, comfort with ambiguity, and the ability to break down and solve complex problems.

If you have ever wanted to make a significant contribution and help shape the trajectory of a startup, this role is for you!

Reports to: Director Data Science & Analytics

On a daily basis, works closely with: Engineering, Product Management, Product Marketing and Global Operations.

Location: Design Pickle is a fully remote company with a Company Hub in Scottsdale, Arizona. Who We Are Looking For

First, Design Pickle is anything but typical. Were a group of hard-working, creativity-loving individuals from around the world.

Do we love pickles, too? Most of us! But dont stress if pickles arent your thing. Its not a deal-breaker. We do look for a passion and interest in something though because our employees uniqueness is what helped make us the great company we are today.

We stand by our vision, purpose, and values, and these are mission-critical to how you show up every single day.

Specific to your role, were looking for individuals who have... A robust background with at least two years dedicated to software development, encompassing the full spectrum of the product lifecycle. This includes ideation, development, deployment, and iteration.

A minimum of three years' expertise in crafting and optimizing SQL queries. Candidates should be well-versed in manipulating and extracting data to meet business needs.

Over two years of hands-on experience in ETL (Extract, Transform, Load) processes, showcasing proficiency in designing, implementing, and maintaining robust ETL pipelines.

At least two years of programming experience with a focus on object-oriented languages, such as Python.

A minimum of two years in database schema design and dimensional data modeling, illustrating a deep understanding of how to structure and model data effectively for scalability and performance.

Proven experience in the data warehousing field, indicating a solid foundation in managing large-scale data storage solutions.

Demonstrated ability to analyze datasets to uncover discrepancies and inconsistencies, thereby ensuring data quality and reliability.

Practical experience with Amazon Web Services (AWS), including but not limited to S3, Redshift, and Machine Learning services. Candidates should be comfortable leveraging these services to enhance data storage, processing, and analytics capabilities.

Expertise in managing and clearly communicating plans for data sourcing and pipeline development to stakeholders within the organization, ensuring alignment and understanding across teams.

Exceptional problem-solving abilities, with a knack for navigating through unclear requirements and delivering effective solutions.

Bonus Pickle Points: A Bachelor's or Master's degree in Computer Science, a related technical field, or equivalent practical experience.

Additional experience with AWS, specifically in managing Data Lakes, is highly regarded.

Familiarity with building and utilizing reports in business intelligence tools such as PowerBI and Tableau, enhancing decision-making and insights.

Proficiency in Ruby on Rails, adding value through versatile web development skills.

A proven track record of working independently within globally distributed teams, showcasing effective communication and collaboration across different time zones.

Demonstrated capacity to leverage data in influencing pivotal business decisions, underlining the strategic use of insights in driving outcomes.

Key Objectives and Responsibilities

As a fast-growing company, our roles are always evolving. However, we want you to know exactly what youre walking into. In the first 90-days, here is a preview of whats expected: Conceptualize and own the data architecture for our suite of tools and analytics platform.

Create and contribute to frameworks that improve the efficiency of logging data, while working with data infrastructure to troubleshoot and resolve issues.

Collaborate with engineers, product managers, product design and product marketing to understand data needs, representing key data insights in a meaningful and actionable way.

Define and manage SLA for all data sets.

Determine and implement the security model based on security and privacy requirements, confirm safeguards are followed, address data quality issues and evolve governance processes.

Design, build and launch sophisticated data models and visualizations that support our products and global operational processes.

Solve data integration problems, utilizing ETL patterns, frameworks, query techniques, sourcing from structured and unstructured data sources.

Optimize pipelines, dashboards, frameworks, and systems to streamline development of data artifacts.

Mentor team members for best practices in the data engineering space.

Commitment to documentation.

$100,000 - $115,000 a year The compensation range for this position $100,000 to $115,000 annually. The actual salary offer to a candidate will be made with mindful consideration of many factors. These factors include but are not limited to skills, qualifications, education/knowledge, experience, and alignment with market data for a given location within the US. In addition to base salary, some positions may be eligible for additional forms of compensation such as bonuses or commissions. This salary data is for our US-based positions only. Benefits, Compensation, And Perks Uncapped PTO: Hate seeing your PTO hours decrease as the year goes on? Not anymore! There is no cap or number associated with the amount of PTO days you can request. Major medical healthcare: We offer major medical plans as well as Dental and Vision insurance. Remote-work flexibility: More productive at home? Not based in Scottsdale, AZ? Fine with us! We are a remote-first company with people all over the country. 401K: Plan for your future with a 401K with a 5% company match. World-class Company Hub: More productive in an office? Also, fine with us! Our Company Hub is set up with state-of-the-art standing desks, high-definition monitors, breakout rooms for meetings and calls, a podcast studio, a relaxation room, and of course - as much merch as you need. In-office gym: Our Company Hub also has a small CrossFit-style gym with a Peloton studio available for any pickles to use! Life-changing massage chair: We change lives through creativity...and massages. Our team has traveled far and wide to take advantage of a life-changing massage chair that is housed in our Company Hub. One massage is all it will take to radically transform your life. New parent leave: Design Pickle encourages all primary caregivers to take up to 8 weeks leave for a new family member, including adoption, at full salary. Short Term / Long Term Disability Options Paid training and personal development: We offer a yearly stipend for employees to continue to grow their skillset and learn things to help them in their careers. Pet insurance: Have a furry friend? Design Pickle offers pet insurance through United Pet Care for discounted vet visits, medication, and procedures. Team retreats, social events, and adventures: Pickle collaboration is important to us! We host regular social events, get-togethers, and experiences for our staff. About Design Pickle Design Pickle was founded in 2015 with a vision to change lives through its creative software, solutions, and services. Since then, the company has grown to be the leading flat-rate creative services company in the world. We have served tens of thousands of clients with a team that spans the globe. Design Pickle continues to be one of the fastest-growing companies in America listed on the Inc. 5000 in 2019, 2020, 2021, 2022, 2023. Weve also been ranked as an AZ Central Best Place to Work in 2020, 2021, 2023. We are a company that takes our core values to heart: Be the SPARK Let your fire and passion inspire someone elses day. DRIVE Performance Seek out new ways to improve performance, satisfaction, and impact for our customers. Less is more rules supreme. Give it to me STRAIGHT Lead with radical and professional candor in every situation. Graciously accept when others do the same. Move forward together and aligned. HELP when nobody's watching Find opportunities to support each other and our clients beyond the day-to-day. Lean into HARD We thoughtfully select our challenges and tenaciously commit to conquering them. Make your own PICKLES We are a collection of incredible individuals who challenge ourselves and each other to grow. Change is celebrated as a sign of progress. You can learn more about our company, our vision, and what we stand for on our website and social channels. We cant wait to meet youthank you in advance for your application! Design Pickle is an Equal Opportunity Employer. You will often hear members of the Design Pickle team refer to themselves as pickles. Pickles come in an infinite amount of variety, and as such, the pickles at Design Pickle celebrate every aspect of our diverse workforce and do not tolerate discrimination on the basis of race, color, religion, marital status, age, nationality, (dis)ability, gender, gender expression, or sexual orientation. All employment decisions are made on the basis of qualifications, merit, and business need. The right pickle for the right opportunity. Design Pickle is an Equal Opportunity Employer. Notice to Staffing and Recruiting Agencies Design Pickle will not accept resumes from any source other than the candidate. Any unsolicited resume sent to Design Pickle will be considered Design Pickle sourced. PM21

PI237876076

#J-18808-Ljbffr