Data Engineer in New York, NY at Open Systems Technologies

Date Posted: 1/8/2020

Job Snapshot

Job Description

Our client is currently looking for a Data Engineer to join the Platform Team. You will help build data driven solutions to bring digital media experiences to active users by working on new product features and improving the data infrastructure.


  • Responsible for ensuring high-availability and performance of our data platform
  • Responsible for our Azure SQL DW, SQL Server, SSAS, Azure Data Factory technologies
  • Assess and cultivate long-term strategic goals for efficient data platform growth
  • Provide data support and guidance to the larger engineering and data science teams
  • Evaluate and select database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions
  • Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts

 Required Experience:

  • Strong data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling
  • Expertise in Microsoft Azure Cloud, SQL DW, SQL Server, Azure Data Factory
  • Experience with Stream Analytics, Event Hubs, Power BI
  • Extensive DBA skills and highly advanced SQL and RDBMS knowledge
  • Experience in troubleshooting and resolving database integrity issues, performance, blocking/deadlocking, replication, log shipping, connectivity, and security issues
  • Strong analytical skills and familiarity with performance tuning, monitoring, and capacity planning
  • Experience with columnar indexed databases
Job category:
  • Information Technology
Job keywords:
  • Data
  • SQL
  • Database Administration
  • ETL