Data Engineer: Bloomingdale’s, New York, NY

Macy's
Macy's

Job Overview
Job Overview:
Bloomingdales is looking for a Data Engineer to work 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. This individual 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 Bloomingdales associates and external vendors on data requirements to support strategic business needs. Performs other duties as assigned.
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.
Regular, dependable attendance and punctuality.
Qualifications:
Education/Experience:
Bachelors degree in Information Technology, Computer Science.
Minimum 4 years experience in database development and administration.
Experience with data integration and database design.
Experience with Hadoop, Spark, Hive experience preferred.
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.
Communication Skills:
Excellent data interpretation and communication skills;
Ability to summarize complex findings clearly and concisely, ability to communicate effectively to all levels of management.
Mathematical Skills:
Basic math functions such as addition, subtraction, multiplication, and division.
Reasoning Ability:
Strong conceptual/analytical/creative thinker.
Strong skills in SQL to analyze, manipulate data, investigate data problems, and develop reports.
Must be able to work independently with minimal supervision.
Strong organizational and time management skills; ability to adhere to deadlines.
Physical Demands:
This position involves regular walking, standing, hearing, and talking.
May occasionally involve stooping, kneeling, or crouching.
Involves close vision, color vision, depth perception, and focus adjustment.
Other Skills:
Knowledge of data warehousing methodologies.
Familiarity with a programming/scripting language such as Java, .Net, PowerShell or Python.
Work Hours:
Ability to work a flexible schedule based on department and company needs.
This job description is not all inclusive. Macys Inc. reserves the right to amend this job description at any time. Macy’s Inc. is an Equal Opportunity Employer, committed to a diverse and inclusive work environment.
View More
Job Detail
Shortlist Never pay anyone for job application test or interview.