- Job Title
- Database Analyst
- Job ID
- Birmingham, MI 48009
- Other Location
***Must Be Local To Metro Detroit!
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.
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
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
Bachelor's/Master's in computer science, information systems, or engineering
5+ years of experience in programming
Must have Python!
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, .NET, AWS & Redshift a plus