Senior SQL Programmer - SBS

Company: SGS Consulting
Location: New York
Posted on: January 17, 2020

Job Description:

Job Title: Senior SQL Programmer Duration: 12 Months Client: Facebook Req ID: 9716545 Location: New York, NY 10003 Description: Duties: Create ad-hoc SQL queries to provide data for sales operations; don't need T-SQL Troubleshoot and resolve issues that arise with data in Tableau dashboards, data pipelines, and other surfaces Create and update python scripts to calculate fields, extract, and transform data Assist with support of production environment on call support Create data quality checks, documentation, and analysis as needed Skills: Must Have SQL Mastery Using Common Table Expressions to do recursive queries and sub-queries Implementing logic such as If, exists, case, filter, ranking, nulls, pivot and unpivot Data transformation such as regular expressions, replace, split, coalesce, transform Understanding database concepts and applying them in functions such as cardinality When to use each join type, aggregate functions, and arrays Debugging query errors and issues and finding where data is stored in specific tables Attention to detail to ensure providing the right data Preferred, but not required Python experience to interact with data and troubleshoot issues SQL PostgreSQL and Presto User Defined Functions Query tuning and performance optimization Tableau Desktop or other BI tool experience Knowledge of Facebook internal tools - provided by Dice

Keywords: SGS Consulting, New York , Senior SQL Programmer - SBS, IT / Software / Systems , New York, New York