Analytical Engineer
Business Intelligence & Financial Planning & Analysis (FP&A)
Remote (India)
Full-Time | US Shift (PST)
Posted:
Job Overview
Joins the BI and FP&A team of a full-service US marketing agency (Newport Beach, California) specializing in face-to-face marketing and sales campaigns. Develops data solutions to support sales and analytics functions, reporting to the BI Manager.
Key Responsibilities
Design, build and deploy BI solutions using Tableau and SQL
Debug and troubleshoot existing data tables, objects, workbooks and reports
Evaluate and improve existing BI systems
Collaborate with the analytics team to deploy integrated system solutions
Assist in the design and development of data architecture and data warehouses
Map the various databases used in the organization
Own the data model, design layout/structure and maintain published data sources
Requirements
5+ years of SQL experience (T-SQL highly preferred)
3+ years of Tableau experience
3+ years working with stored procedures
Strong knowledge of relational database structure and management methodologies
Strong data pipeline knowledge
Strong requirement gathering, project scoping and data analysis skills
Nice to Have
Salesforce experience
Snowflake experience