Title: Data Integration Engineer
From boutique-brand culture to big-box retail, Liberated Brands thinks differently and has global scale servicing over 60+ countries. With over three decades of experience in brand-building, we are enhancing what a full-service license model can look like. We focus on the fundamentals of designing, producing, distributing, and marketing our brands and products, but always leave room for the x-factors to lead the way. Our expertise spans all sales channels, from direct-to-consumer to specialty wholesale and everything in between, both physical and digital. This Liberated approach creates a unique and powerful balance between brand-culture and sustainable growth. Join us and experience the benefits of being truly Liberated.
WHAT YOU’LL DO:
The Data Integration Engineer is responsible for developing and maintaining data interfaces and integrations that support data warehousing, business intelligence, and custom product initiatives.
- Designing and developing ETL processes to extract global data from various sources for data enablement, exposure, and consumption
- Developing transformation rules to ensure data quality and consistency
- Maintaining and streamlining ETL processes to ensure they run efficiently and effectively
- Collaborate with data analysts, business stakeholders, and other members of the IT team to develop organizational data solutions
- Assist with developing and maintaining data objects in the business intelligence space
- Documentation of the ETL processes
- Designing and implementing ETL workflows, as well as writing scripts to automate data processing tasks
- Data analysis and profiling to identify data quality issues and recommend/implement solutions
- Analyze and optimize end-to-end ETL process performance
- Keep up-to-date with emerging trends and technologies in ETL and data integration
WHAT YOU’LL NEED:
- Bachelor’s Degree in Information Technology, Information Security/Assurance, Computer Science, Data Engineering, or related field of study, or any combination of relevant equivalent experience, education and training
- 5+ years of experience in ETL development and data integration using SQL Server development skills as the designated ETL Developer
- Exceptional in ETL development, data integration, and data analysis
- Experience in developing with SSIS or similar ETL toolsets(Talend, TIBCO, Make)
- Ability to write views, stored procedures, functions
- Strong experience with:
- SQL optimization and execution plan analysis
- Source control management and deployment tools
- Shell script development and execution within a workflow
- Automated Jobs and scheduled processes
- ETL concepts, data integration, data warehousing, and business intelligence
- Data modeling and relational database design
- BI Data Integration – utilizing normalization & denormalization techniques
- Works well in a team environment and demonstrates seasoned communication skills (written and oral) to technical and non-technical stakeholders
- Ability to learn/adapt to new technologies and methodologies
- Competent in troubleshooting and resolving issues with ETL workflows and processes
LIBERATED PERKS:
- Collaborative culture with amazing family vibe
- Discounts on Liberated Merch
- Medical, Dental, and Vision Benefits (majority employer paid)
- 401k, including employer contribution
- Surf and Snow Team Building Days
- Summer Half Day Fridays
- Paid Time Off
- Referral Program
Liberated Brands is committed to fair and equitable compensation practices. The salary range for this role in Costa Mesa, CA is $115,000 – $130,000. This position is hybrid and, as such, compensation will ultimately be in line with the location in which the position is filled. Final compensation for this role will be determined by several factors such as a candidate’s relevant work experience, skill set, certifications, and specific work location.
WeareanEqualOpportunityEmployerandallqualifiedapplicantswillreceiveconsiderationforemploymentwithoutregardtorace, color, religion, sex, nationalorigin, disabilitystatus, veteranstatus, sexualorientation, genderidentityoranyothercharacteristicprotectedbylaw
If you are unable to complete this application due to a disability, please contact Customer Service to ask for an accommodation or an alternative application process: 1 (855) 330-0188 or ADAaccommodations@liberatedbrands.com.