Analytical Engineer

A full-service marketing agency, specializing in face-to-face marketing and sales campaigns, with wellknown clients, is seeking an Analytic Engineer to join our Business Intelligence and Financial Planning &

Analysis team to help develop Data solutions to support sales and analytic functions.

This role requires

strong analytic skills, deep knowledge in the BI tool Tableau, and T-SQL knowledge. The Analytic Engineer

willreport to the BI Manager and engage with internal departments to help support and optimize business

with data driven solutions. The Company is based in Newport Beach, California. The hours worked for this

role will align with the US time zone.

The duties for this position are described below.

Analytic Engineer (Remote)

Job Duties:

-Design, Build and deploy BI Solutions (BI -Tableau, SQL)

-Debugging/Troubleshoot existing data tables/objects/workbooks/reporting

-Evaluate & Improve existing BI systems

-Collaborate with the analytic team to deploy integrated system solutions.

-Assist in the development/design of data architecture and data warehouses

-Map various databases used in the organization

-take ownership of data model, design layout/structure, and actively maintain existing data

table/published data source

Technical skills & requirements:

5+ years of SQL experience (T-SQL highly preferred)

3+ years of Tableau experience

3+ years in stored procedures

Strong knowledge of RDB structure & management methodologies

Strong Data pipeline knowledge

Strong Requirement gathering, project scoping skills

Strong data analysis skills

Salesforce experience preferred

Snowflake experience preferred