Company:
Experian
Location: Costa Mesa
Closing Date: 04/12/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Job Description
Reporting to the Manager of CRM Operations Data Management, the Sr. Data Developer will join a team focused on data and processes supporting high-volume and personalized outbound interactions. The scope of work includes working in partnership with CRM Program Managers and IT partners to understand our needs, underlying data, and tools used in the deployment of email, SMS, and mobile push communications. As a Sr. Data Developer, you will develop production-level SQL code, analyze data flows and discrepancies, automate data quality monitoring, and allow error notifications. Additionally, you will become immersed in our CRM Ops application stack, including SalesForce Marketing Cloud, Alteryx, HCL Unica, and Campaign Management tools.
What you'll be doing
You will develop large-scale, SQL data pipelines with job logging
Conduct data discovery and analysis to support new Experian Consumer Services (ECS) digital products and programs
Investigate data errors/discrepancies and SQL job/file transmission failures
Define data requirements/design to support ECS consumer products and outbound marketing programs
Develop source to target data mapping and data flow documentation
Develop well-documented, performance-optimized SQL scripts for production deployment
Troubleshoot and update existing SQL jobs that error/time out or require performance tuning
Create job monitoring automation and error notifications
Draft and present data design solutions/recommendations to tech and business teams
Learn new tools and become a power-user of applications, including Salesforce Marketing Cloud, Alteryx, Jira, Confluence, Lucid Chart, and Unica Campaign
Support CRM Ops center of excellence. Identify innovation opportunities, inefficiencies, and opportunities for additional automation
You will communicate with teams, including Technical Teams, Business Intelligence/Data Warehousing, Analytics, Web Operations, Legal, and Marketing
Reporting to the Manager of CRM Operations Data Management, the Sr. Data Developer will join a team focused on data and processes supporting high-volume and personalized outbound interactions. The scope of work includes working in partnership with CRM Program Managers and IT partners to understand our needs, underlying data, and tools used in the deployment of email, SMS, and mobile push communications. As a Sr. Data Developer, you will develop production-level SQL code, analyze data flows and discrepancies, automate data quality monitoring, and allow error notifications. Additionally, you will become immersed in our CRM Ops application stack, including SalesForce Marketing Cloud, Alteryx, HCL Unica, and Campaign Management tools.
What you'll be doing
You will develop large-scale, SQL data pipelines with job logging
Conduct data discovery and analysis to support new Experian Consumer Services (ECS) digital products and programs
Investigate data errors/discrepancies and SQL job/file transmission failures
Define data requirements/design to support ECS consumer products and outbound marketing programs
Develop source to target data mapping and data flow documentation
Develop well-documented, performance-optimized SQL scripts for production deployment
Troubleshoot and update existing SQL jobs that error/time out or require performance tuning
Create job monitoring automation and error notifications
Draft and present data design solutions/recommendations to tech and business teams
Learn new tools and become a power-user of applications, including Salesforce Marketing Cloud, Alteryx, Jira, Confluence, Lucid Chart, and Unica Campaign
Support CRM Ops center of excellence. Identify innovation opportunities, inefficiencies, and opportunities for additional automation
You will communicate with teams, including Technical Teams, Business Intelligence/Data Warehousing, Analytics, Web Operations, Legal, and Marketing
Share this job