Posted: Monday, May 15, 2017 9:05 PM
The Value Management and Pricing Analytics team is part of the Marketplace Strategy and Analytics organization responsible for Advertiser Analytics and optimization of traffic distribution to YPs core digital product. The Senior SQL Strategist is responsible for designing, implementing, and supporting database solutions involving business data exchange, data enrichment operations, analytic data integration, and aiding in interpretation of analytical output to meet value management and pricing analytics goals.
As Senior SQL Strategist, your primary responsibilities will include the following:
: Responsible for creating and maintaining SQL queries and routines. Build a database of customer level performance metrics from multiple data sources (i.e. database tables and flat files). Writes ad:hoc queries based on schema knowledge from multiple data sources for various requirements/ scenario testing.
: Responsible for providing technical expertise in the areas of requirements elicitation and documentation, database modeling, database development, customer data integration (CDI), data quality process integration, process automation, and systems integration.
: Using SQL, Data Quality, and process automation tools, this position designs, develops, and implements various value management and pricing analytics database solutions including: data quality and validation, data extraction, process scheduling/automation, and systems integration as needed.
: Collaborates with reporting team, Business Intelligence team, and Platform Data Services team on designing and building automated reports that determine customer traffic acquisition targets and report on other value and pricing KPIs.
: Works with reporting, Data warehouse, Business Intelligence and other Engineering / technical teams to understand how various systems receive records from multiple data sources, create efficient database design and implement for business analyses.
: Working in collaboration with Product, Marketing and Technology groups to serve as the subject:matter expert on data sources, data definitions, and processes for capturing, accessing and extracting data.
: B.S. Degree in Computer Science/Engineering or equivalent.
: 5+ years hands:on experience in SQL writing, or equivalent level of demonstrated knowledge.
: 2+ years hands:on experience working with data model design or using HP Vertica for SQL on Hadoop.
: Intellectually curious
: Superior analytical skills
: Advanced proficiency in gathering, assessing and analyzing data from multiple sources
: Methodical and process oriented
: Able to organize and prioritize multiple concurrent work streams involving both internal and external resources
: Demonstrated ability to work cross:functionally at all organizational levels and/or with outside professionals.
: Attention to detail and strong organization skills;
: Strong collaborative and interpersonal skills
: Ability to work independently with minimal supervision
: Prior experience with an advertising or consulting agency a plus
: Self:motivated and a self:starter with strong ability to multitask projects/tasks effectively
: Highly proficient in developing SQL queries.
: Strong knowledge of data validation, hygiene and database management including data clean up, deduping, and data transformation for end user consumption.
: Good documentation skills for process flow and requirements analysis.
: Strong communication and intra:personal skills.
: Experience with Business Intelligence tools (Business Objects and Tableau) is desirable.
: Intermediate user of excel (Pivot tables, charts and graphs).
: Knowledge of basic statistical concepts : sample size selection, A/B test
: Experience with large sc
• Location: glendale, San Fernando Valley
• Post ID: 115426588 sanfernandovalley