Data Warehouse Engineer

Job Description

Job Description

Company Description

Teleflora provides innovative marketing, education, and technology to make sure our member florists get the resources they need to thrive, creating beautiful bouquets with keepsake vases delivered to your door.

We’ve been a part of The Wonderful Company family since 1979, and with a nationwide network of florists, we’ve become the world’s largest flower delivery service.

With more than 10,000 member florists in North America, we lead the industry by working directly with our florists to hand-arrange and hand deliver every bouquet!

Teleflora brings together the time-honored tradition of sending flowers with the modern benefits of an advanced florist network, offering the kind of personal touches, artistry and expertise you expect from a trusted neighborhood florist even if that neighborhood is across the country.

This position will be involved in the development, implementation, and deployment of jobs, reports, and dashboards. The Data Warehouse Cloud Engineer will assist in providing critical technical solutions on various projects for the company.

This position is also responsible for performing proof-of-concepts; report creation and distribution; documentation and presentation of BI standards and guidelines;

design and development of ETL processes. Additionally, this person is responsible for analyzing customer requirements as well as identifying and implementing strategies.

This is a hands-on technical individual contributor role.

This position is not eligible for immigration / visa sponsorship

Job Description

• Responsible for the conception, design, development, and deployment of data architecture and data models
• Work together with various business units to develop data warehouse platform vision, strategy, and roadmap.
• Follow various ETL Processes to prepare design for all metadata.
• Ensure high-performance access to diverse data sources.
• Enforce architectural constraints and reject designs which compromise system integrity.
• Participate in research, requirements definition, planning, design and execution of projects on enterprise Business Intelligence initiatives.
• Manage customer expectations to ensure strong customer satisfaction by meeting the business needs for IT systems in a timely manner.
• Performance tuning and enforcing repository best practices.
• Collaborate with business areas and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution.
• Develop front-end, metadata and ETL specification to support business requirements for reporting across the organization.
• Modify Security as per the business needs.
• Deploy Code migration method and manage release control.
• Make configuration changes to improve performance.
• This job requires meetings, code deployments, and on-call responsibilities that occur after normal business hours. It also requires extended hours over the holidays.

Qualifications

• Must be authorized to work in the US without visa assistance now or in the future
• At least 5 years in BI / DWH with a variety of platforms and industries
• Strong operational experience with Oracle and Google Cloud Platform.
• At least 5 years of Data Warehousing Experience.
• Experience with ERP integration.
• Business processes or knowledge / experience of developing BI solutions for enterprise process.
• SME in Industry leading ETL / Data Integration tools
• Well versed with Linux operating system and should be comfortable in writing shell scripts.
• Excellent data profiling abilities.
• Expert knowledge of SQL and related SQL procedure languages.
• Strong Python programming skill.
• Strong analytical skills to identify patterns and insights from large and complex data sets.
• Excellent organizational, interpersonal, and oral / written communication skills.
• Experience in managing data warehouse project and lifecycle initiatives.
• Data Lake experience (GCP preferred)
• Kubernetes and Kafka experience

Additional Information

• Competitive benefits package including Medical (including 24 / 7 online access to a physician), Vision, Dental and 401k with match eligibility
• Opportunities for development and internal mobility
• Manager and leadership training, biweekly L&OD webinars, and eLearning offerings
• Companywide problem solving and continuous improvement training
• Wonderful Giving (wonderfulgiving.com) - allowing you to donate company money to a cause of your choice
• Company focus on wellness and health

Say everything and share your "Love Out Loud™" with the gift of Teleflora® flowers all made by hand and delivered by hand by your local florist.

With more than 10,000 member florists in North America alone, Teleflora offers the kind of personal touches, artistry and expertise you expect from a trusted neighborhood florist even if that neighborhood is across the country.

No prepackaged flowers in nondescript boxes dropped on your doorstep Teleflora's network of professional florists creates artistic arrangements personally delivered in a vase, often on the same day.

Teleflora makes every day an occasion with a two-in-one gift that includes a multipurpose keepsake container for long-lasting enjoyment.

For more, visit : www.teleflora.com, or follow us on Instagram and Facebook and tag your own #LoveOutLoud moment.

Teleflora has been part of The Wonderful Company since 1979. The Wonderful Company is an Equal Opportunity Employer that provides opportunities for advancement.

We are committed to creating a diverse workforce that embodies a deep culture of acceptance, equity, and inclusion. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories.

LI-JB1

LI-Hybrid

EEO is the law - click here for more information