Data Engineer: New York, NY

Our client 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 associates and external vendors on data requirements to support strategic business needs.
 
Responsibilities:

  • 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.

Requirements:

  • Bachelor's degree in Information Technology, Computer Science.
  • Minimum 4 years' experience in database development and administration.
  • Experience with data integration and database design.
  • Knowledge of data warehousing methodologies.
  • Experience with ETL tools. Microsoft SSIS preferred. Azure Data Factory nice to have.
  • Strong conceptual/analytical/creative thinker.
  • Strong skills in SQL to analyze, manipulate data, investigate data problems, and develop reports.
  • 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.
  • Strong conceptual/analytical/creative thinker.
  • Excellent data interpretation and communication skills; ability to summarize complex findings clearly and concisely, ability to communicate effectively to all levels of management.

 

 

Compensation:

Competitive salary range commensurate with education and experience.

Please apply directly to Courtney by sending your resume in Word format to: holly@dcmstaffing.com. Please list your subject line as: "Data Engineer Candidate: (Your Name)"

ALL INFORMATION PROVIDED IS CONFIDENTIAL.
THERE IS NO COST INVOLVED FOR ANY APPLICANT AS ALL FEES ARE CLIENT/COMPANY PAID.

button-submit-your-resume.png

backButton.png