This job has expired

Data Engineer

Long Island City, New York
Closing date
12 Aug 2022

View more

Full Time

Job Details

Bloomingdale's makes fashion personal and fun, aspirational yet approachable. Our mission is to guide and inspire our customers to make style a source of creative energy in their lives. We will always strive to make Bloomingdale's like no other store in the world. Everyone plays a critical role to bring our mission to life. Regardless of position, we believe all colleagues have a voice and access to share their thoughts with every level of leadership. Our colleagues are passionate, driven, entrepreneurial and collaborative. We welcome and embrace diversity of background, thought and opinion while having a lot of fun along the way.

Job Overview:
The Data Engineer works with technology partners and deliver, cutting edge data systems that supports the Business Intelligence and Analytics functions within Marketing to maximize sales and drive customer loyalty. The Data Engineer will be responsible for integrating and automating data flows, designing and building data marts and managing big data systems, working with diverse on-premise systems and the Azure cloud. The Data Engineer will also be responsible for working with a wide variety of Bloomingdale's colleagues and external vendors on data requirements to support strategic business needs.

Essential Functions:
  • Integrate data from multiple databases across different platforms such as Oracle, SQL Server, Teradata and Hadoop to integrate data and build a data lake and analytical data marts
  • Work with the Lead Data Architect to determine high level data strategy for the Enterprise Data Warehouse within a Microsoft Azure environment. Work extensively with Azure Data Warehouse MPP database platform
  • Create logical and physical data models for operational applications and all analytic applications
  • Participate in ETL design and act as the subject matter expert on source and target data structures
  • Work with various outside vendors and internal support teams in maintaining and/or enhancing processes and data integrations
  • Support business by generating ad-hoc analysis, using SQL, for overall business as needed
  • Perform extensive data quality and data analysis checks to ensure integrity of database for business use
  • Work with business partners on the full lifecycle of data related projects from requirements analysis and design through development
  • Maintain and manage scheduling and distribution of reporting
  • Manage and monitor server processes and jobs for on-premise and Azure cloud environments
  • Investigate and resolve root cause for complex data issues
  • Script and automate processes
  • Diagram and document databases and data flows

Qualifications and Competencies:
  • Bachelor's Degree from a 4-year college or university
  • 3-5 years direct experience
  • Knowledge of data warehousing methodologies. Experience with ETL tools. Microsoft SSIS preferred. Azure Data Factory nice to have. Experience with enterprise reporting tools. Business Objects, Microsoft SSRS, Power BI or Tableau preferred
  • Familiarity with a programming/scripting language such as Java, .Net, PowerShell or Python.
  • Experience with Hadoop, Spark, Hive experience preferred
  • Practices open and continuous communication, values keeping others informed, effectively presenting information in a clear, concise manner
  • Excellent leadership, facilitation, and interpersonal skills, with the ability to work across functional lines and at many levels
  • Ability to think creatively, strategically and technically
  • Ability to work a flexible schedule based on department and Company needs



Learn more about this company

Visit this company’s hub to learn about their values, culture, and latest jobs.

Visit employer hub

Learn more about this company

Visit this company’s hub to learn about their values, culture, and latest jobs.

Visit employer hub

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert