Database Analyst

IPG MediaBrands   •  

Birmingham, MI

Industry: Business Services

  •  

5 - 7 years

Posted 300 days ago

This job is no longer available.

Position Summary

We are looking for a JavaScript/SQL Server Database Analyst/Developer to join our team! This position supports the Business Analytics Engine (BAE), that drives Paid Search decision making and insights. This individual is tasked with integrating consumer, industry and media insights with our Fortune 100 clients' Paid Search programs, as well developing advanced reporting solutions that align with agency, client and team objectives.

Ambitious, experienced individuals with a strong interest in media, marketing, and business intelligence are ideal candidates for this position.

 Essential Functions

  • Contribute to media, sales, brand equity and any other relevant data gathering and harmonization efforts
  • Collect database need specifications from planning and analytics teams
  • Build and maintain SQL scripts to calculate key metrics, and create analytical datasets
  • Work alongside Paid Search team to develop JavaScript and analytic tools to drive business objectives
  • Communications:
    • Effectively collaborate with account teams to understand their needs and build solutions that meet or exceed expectations
    • Possess sound written, oral, and organizational skills
    • Document solutions, systems, and procedures
    • Deliver personal, customer focused, and professional service
    • Work effectively as an individual and as part of a team
    • Adhere to team policies and organizational reporting structures
    • Facilitate meetings with stakeholders and peers
    • Provide status and issue updates to managers and peers

Qualifications

Education:

  • Bachelor's/Master's in computer science, information systems, or engineering

Work Experience:

  • 5+ years of experience in programming

Skills:

  • Software development life cycle
  • Solid understanding of data architecture
  • Tableau coding and design experience
  • Excellent communication skills
  • Expert knowledge of MS Excel, including VBA and Macros
  • Proficient in all facets SQL Server, SSIS, SSAS, and SSRS with strong knowledge of T-SQL
  • Familiar Sharepoint, Python or .NET, AWS & Redshift

Tracking Code : 20148403