Business Intelligence Data Engineer

Effy Jewelry; New York (NY); On-site; USD 100,000 - 110,000; Full time

Job summary

Effy Jewelry seeks an experienced Data Engineer/BI Engineer to support revenue analytics in cruise retail. You will build and maintain data infrastructures and financial dashboards powering insights into sales, demographics, and inventory.

This full-time, onsite position is based at our NYC Headquarters, requiring five days on location. You will collaborate across teams to optimize data workflows and deliver data-driven strategies for retail operations.

Qualifications

• Bachelor’s degree in CS/Engineering/IS/Analytics or related field.
• 3+ years of data engineering experience in retail or e-commerce.
• Strong Python and SQL; experience with distributed data systems.
• Experience with cloud platforms (Azure) and data lake/lakehouse architectures.
• Deep understanding of retail metrics (sales, inventory, SKU, loyalty).
• Must have valid work authorization to work in the U.S.

Responsibilities

• Design, develop, and maintain scalable data pipelines from multiple sources (POS, e-commerce, ERP, CRM).
• Develop and maintain data lakes, data warehouses, and data marts (Snowflake, BigQuery).
• Integrate data from proprietary systems to refine semantic layers for data-driven strategies.
• Optimize data workflows and automate recurring data tasks for efficiency.
• Build and manage financial dashboards using Power BI, Tableau, Looker; monitor usage and gather feedback.
• Maintain documentation of pipelines, schemas, and governance processes.
• Stay current with emerging technologies and recommend retail-specific tools.

Skills

Python

SQL

Distributed data systems

Data pipelines

Education

Bachelor’s degree in Computer Science, Engineering, Information Systems, Analytics or related field

Tools

Snowflake

BigQuery

Power BI

Tableau

Looker

Job description

Title: Business Intelligence Data Engineer

Reporting to: Business Intelligence Manager

Location: New York, NY (Onsite)

About Us

Effy Jewelry is a family-owned and operated business that has been crafting exquisite jewelry for over four decades. Founded by Effy Hematian, the brand has become synonymous with innovative design, superior craftsmanship, and unparalleled quality. With a focus on innovation and creativity, Effy Jewelry has become a global leader in the fine jewelry industry. Its pieces can be found in major retailers and department stores worldwide, as well as over 150 land and cruise-based stores. Effy is also a major name in the Maritime & Cruise industry, providing exclusive onboard retail experiences including trunk shows and VIP events.

Job Summary

We are seeking an experienced Data Engineer/BI Engineer to support our data-driven initiatives in cruise retail focusing on revenue analytics. You will be responsible for building & maintaining data infrastructures and financial dashboards that power key insights across sales performance, customer demographics, and inventory management.

This role is a full-time, onsite position based at our NYC Headquarters. The selected candidate will be required to work onsite five days per week.

Essential Job Functions

• Design, develop, and maintain scalable data pipelines to process and transform large volumes of retail data from multiple sources (POS systems, e-commerce platforms, ERP, CRM, etc.).
• Develop and maintain data lakes, data warehouses, and marts (e.g., Snowflake, BigQuery).
• Integrate data from proprietary systems to refine semantic layers optimized for data-driven strategies
• Optimize data workflows and automate recurring data tasks to improve operational efficiency.
• Design, build, and manage financial dashboards using tools such as Power BI, Tableau, Looker; monitor report usage & collect feedback for continuous improvement.
• Maintain clear documentation of data pipelines, schemas, and data governance processes.
• Stay current with emerging technologies and recommend tools that fit retail-specific needs.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, Information Systems, Analytics or a related field.
• 3+ years of experience in data engineering, preferably in a retail or e-commerce environment.
• Strong programming skills in Python, SQL, and experience with distributed data systems.
• Experience with cloud platforms (Dynamics, Azure) and modern data architecture (data lake/lakehouse); Experience working with large volumes of transactional and customer data.
• Deep understanding of retail-specific metrics and financial datasets (sales, inventory, SKU, loyalty programs, etc.).
• Must have current work authorization to work in the U.S.

Preferred Qualifications:

• Experience with retail systems like Oracle Retail, Shopify, Dynamics.
• Understanding of omnichannel data flows (online, in-store, mobile).
• Exposure to machine learning pipelines or advanced analytics for recommendation engines and customer segmentation.
• Strong communication skills with technical and non-technical stakeholders.
• Analytical mindset with a problem-solving approach.
• Ability to manage multiple priorities in a fast-paced retail environment.
• Proactive, with attention to detail and a passion for data quality.

Salary Range

$100,000 – $110,000 annually, depending on experience and qualifications.

Candidates must have valid work authorization for the U.S. at the time of application and throughout employment; we are not able to sponsor visas.

Effy Jewelry is committed to diversity in its workplace and is proud to offer equal employment opportunities to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, veteran status, or any other legally protected characteristic in the location in which the candidate is applying. Effy Jewelry applicants are assessed solely on their qualifications for the role, without regard to disability or need for accommodation.