Database Marketing BI Developer

About the Role

Key Responsibilities

• Interview and communicate with Business Stakeholders to gather requirements and collaborate through all phases of development.
• Perform data integration from disparate data sources such as SAP, Five9, Salesforce, Postal Data, Product Surveys, S3, SFTP, and various sources to create a data warehouse for the organization.
• Build and maintain data pipelines from SQL Server, APIs, Glue, Snowflake, and other data platforms to enhance organizational data and support data-driven initiatives.
• Analyze complex logical database designs, logical data models, and optimize database performance to ensure scalability for growing data volumes and processing demands.
• Maintain organizational KPIs that provide visibility into business and marketing activities; work with stakeholders to align reports using tools like Microsoft Excel, Tableau, SSRS, and SQL Server.
• Develop and maintain complex dashboards for Executive, Operations, Sales, Logistics, and Marketing teams using Tableau.
• Maintain a central repository of customer behavior data to support marketing campaigns such as direct mail, email, and social media marketing.
• Assist in developing marketing forecast models for subscription and non-subscription customers and help determine their lifetime value.
• Perform match-back analysis to measure the performance of sales campaigns.
• Support trend analysis, hypothesis testing, and identification of areas for efficiency and improvement.
• Manage and implement various marketing-related projects as defined by leadership using appropriate tools.
• Perform other duties as assigned.

Requirements

• Bachelor's Degree in a related field.
• 3+ years of related data experience or related university projects involving ETL/ELT processes.
• Proficiency in visualization tools such as Tableau, Python, SQL, API Framework, PowerShell, and scripting.
• Understanding of Cloud Ecosystem and Snowflake.
• Knowledge of source control systems such as GitHub.
• Results-oriented project management skills.
• Analytical and problem-solving skills.
• Strong ability to analyze information.
• Strong written and verbal communication skills.
• Experience with data analysis, data migration/integration tools, and data modeling.

Nice to Have

• Experience with data modeling.
• Knowledge of data migration and integration tools.
• Familiarity with source control systems like GitHub.

Qualifications

• Bachelor's Degree in a related field.

Benefits & Perks

• Competitive compensation package.
• Comprehensive benefits plans including medical and dental insurance.
• Company-sponsored life insurance.
• Retirement security savings plan.
• Short- and long-term disability programs.
• Tuition assistance.