Posted 2mo ago

Senior Data Analyst

@ 1-800-FLOWERS.COM
Jericho, New York, United States
$95k-$105k/yrOnsiteFull Time
Responsibilities:design ETL, develop ETL, collaborate teams
Requirements Summary:Bachelor’s degree in CS or related field; 2+ years enterprise DB experience; advanced SQL; ETL; data quality; agile; on-call support.
Technical Tools Mentioned:SQL, Snowflake, Oracle, SQL Server, DB2, DBT, Informatica, Coalesce, Python
Save
Mark Applied
Hide Job
Report & Hide
Job Description
About the Team and Role
The Business Intelligence and Data Management team at 1-800-FLOWERS.COM is seeking a talented Senior Data Analyst to join an established group focused on enterprise-wide analytics and data management initiatives. In this role, you will design, build, and maintain the enterprise data warehouse and all associated extraction, transformation, and loading (ETL) processes.
Key Responsibilities
Design, document, develop, and implement new ETL processes and enhancements; modify and optimize existing code
Independently develop, configure, unit test, and deploy ETL solutions based on detailed source-to-target mappings
Collaborate closely with data analysts, reporting teams, and application developers on integration solutions, providing clear explanation and justification for technical decisions
Gather and analyze business and technical requirements; evaluate and recommend viable implementation options
Develop and maintain comprehensive functional and technical documentation for data quality procedures and processes
Design and implement IT controls to ensure the confidentiality, integrity, and availability of data and outputs
Participate in an on-call rotation to support a 24/7 production environment
Requirements
Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent professional experience)
2+ years of hands-on experience with enterprise databases such as Snowflake, Oracle, SQL Server, DB2, or similar
Advanced proficiency in SQL
Strong data analysis, profiling, and data quality development skills, including issue management and remediation processes
Demonstrated experience with unit testing, release management, change control procedures, and coding/design documentation standards
Experience with integration technologies and ETL processes (DBT, Informatica, Coalesce, or similar)
Proven ability to manage multiple concurrent projects in a fast-paced Agile environment
Strong organizational, communication, and documentation skills
Ability to participate in an on-call support rotation
Preferred Qualifications
Experience developing ETL solutions using RESTful APIs
Experience with Python for data processing and automation
Why Join Us
At 1-800-FLOWERS.COM, you’ll be part of a collaborative Business Intelligence and Data Management team supporting enterprise-wide analytics initiatives. This role offers the opportunity to work with modern data technologies, build scalable data solutions, and directly impact business decision-making across the organization. You’ll partner with cross-functional teams and contribute to high-visibility projects that shape how data is leveraged across the company.
The expected salary range for this position is $95,000 to $105,000 annually. Actual compensation will be determined based on experience, skills, internal equity, and other factors permitted by law.
To support our commitment to being an employer of choice, we offer comprehensive and competitive health, wellness, and additional benefits to eligible full-time team members. Benefit eligibility may vary based on location, average hours worked, and length of service.
Benefits may include:
Medical, dental, vision, life, and disability insurance for the associate and eligible dependents
Flexible Spending Account (FSA)
Health Savings Account (HSA)
401(k) retirement savings program
Mental health resources and Employee Assistance Program (EAP)
Paid vacation time (accrued based on hours worked and tenure)
Paid company holidays
Employee discount across our family of brands
Potential eligibility for annual merit-based compensation increases, where applicable
Exact benefit terms, conditions, and eligibility requirements are governed by official plan documents and applicable law. The Company reserves the right to modify, amend, or terminate benefit plans and programs at any time.