BASIC PURPOSE: Responsible for the design, development and maintenance of all marketing solutions which includes but is not limited to database querying, performance optimization, data loads, reporting and dashboards. Oversee the design, implementation and maintenance of the data required to provide the necessary reporting & analytics for the CDP and other solutions.

POSITION RESPONSIBILITIES:

• Design and develop highly visual, interactive, and layered Marketing Analytics reports using Tableau and DOMO.
• Responsible for the construction of basic to advanced SQL (Oracle / SQL Server) and basic PLSQL that provide the necessary data to support the business and feed our Marketing platforms including CDP.
• Responsible for data preparation, data blending, and creation of data models /sets using applications such as Alteryx.
• Create data models for marketing performance by aggregating marketing datasets across multiple marketing publishers and success outcomes of visits, leads and bookings.
• Envision and automate data extraction process across the multiple sources.
• Write basic to advanced SQL that provide the necessary data to support the business and feed our dashboard platforms.
• Triage requests, gather user requirements and ultimately facilitate ad hoc report/data requests with a quick turn-around time and/or develop production reports originating from the Data Warehouse to be used by the business for ongoing analytical and operational needs.
• Define and document processes, best practices, and strategies for existing and future reports and business rules, optimizing business efficiencies as it relates to process improvement.
• Responsible for the education of users on available reporting platforms.
• Design test plans, including definition of test cases and the creation of detailed solution test scripts.
• Work with other teams and vendors to explore methods for automation of testing.
• Audit and analyze application data, when requested by management.
• Act as a liaison between business users, management and application system IT support.
• Maintain documentation of database workflows, requirements, policies, and procedures as they relate to Marketing Analytics Reporting.
• Support the creation, implementation, communication and ongoing support of data standards and processes to ensure standardized data naming, establishing consistent data definitions and monitoring overall data quality.
• Assist business and DW areas in developing relevant exception reporting and addressing existing exceptions reports to ensure that mistakes, inaccuracies and discrepancies are highlighted, addressed and ultimately resolved.
• Interface with Marketing Ops, Data Warehouse and Architectural staff to provide data requirements to support ongoing initiatives.
• Define and document processes, best practices, and strategies for existing and future BI solutions.
• Perform other job related functions as assigned.

KNOWLEDGE AND EXPERIENCE:

EDUCATION: MBA, MIS or Bachelor's Degree in Computer Engineer Science, Statistics, Industry Engineering, Business Administration or related field of study; or any equivalent combination of experience and training.

EXPERIENCE: Minimum 3 - 5 years experience building dashboards in Tableau, dashboards on marketing or web experience preferred. Knowledge of data warehouse technologies, project management, and software development lifecycle. Strong ability to use SQL for analyzing data.

KNOWLEDGE & SKILLS:

• Strong background developing data visualizations, end user reports and performing data analysis.
• Strong understanding of design strategies around information display.
• End to end knowledge of business intelligence and data warehousing architectures.
• Have a fundamental understanding of data management systems and processes within the ecosystem (source systems, data feeds, reference data management, ETL, Data Warehouses and Marts, data cube design, etc.).
• Strong RDBMS background, have excellent SQL skills.
• Excellent analytical skills and organizational skills to gather and document business requirements.
• Verbal and written communication skills to thoroughly prepare specifications make recommendations and effectively work with internal and external members.
• Excellent analytical, logical and problem-solving skills.
• Excellent spoken and written communication skills.
• Self-motivated, quality-oriented, delivery-oriented, and able to self-prioritize work.
• Ability to thrive in a fast-paced and changing environment.

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee discount
• Flexible schedule
• Health insurance
• Life insurance
• Paid time off
• Parental leave
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday

Ability to commute/relocate:

• Miami, FL 33126: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

• Will you now, or in the future, require sponsorship for employment visa status (e.g. H-1B visa status)?

Work Location: One location

Please Note :
epokagency.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, epokagency.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.