Data Engineer

Location
Long Island City, New York
Posted
22 Oct 2021
Closes
05 Nov 2021
Ref
19706
Function
Marketing
Level
Manager
Hours
Full Time
About:
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


This job description is not all-inclusive, and Macy's Inc. reserves the right to amend this job description at any time. Macy's Inc. is an Equal Opportunity Employer and is committed to a diverse and inclusive work environment. Candidates for positions in San Francisco ONLY can review their rights and the Company's obligations under SFPC Art. 49 here. Candidates for positions in Los Angeles ONLY can review their rights and the Company's obligations under LA MC Ch. XVIII Art. 9 here. Candidates for positions in Philadelphia ONLY can review their rights and the Company's obligations under PC Ch. 9-3500 here.
DIGITAL00

Similar jobs

More searches like this

Similar jobs