Experian Health
Senior Database Developer
Experian Health, Costa Mesa, California, United States, 92626
Job Posting - Salary Range: $112,375 - $202,276Department: Data ManagementFlexible Time Off: 20 DaysSchedule: Full TimeShift: Day ShiftCompany Description
Experian is a global data and technology company that powers opportunities for people and businesses worldwide. We help to redefine lending practices, uncover and prevent fraud, simplify healthcare, create marketing solutions, and gain deeper insights into the automotive market, all using our unique combination of data, analytics, and software. We also assist millions of people in achieving their financial goals and helping them save time and money.We operate across multiple other markets, from financial services to healthcare, automotive, agribusiness, insurance, and many more industry segments.We invest in people and new advanced technologies to unlock the power of data. As an FTSE 100 Index company listed on the London Stock Exchange (EXPN), we have a team of 22,500 people across 32 countries. Our corporate headquarters are in Dublin, Ireland. Learn more at experianplc.com.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 doingYou 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.Qualifications
You have 6+ years of experience in advanced enterprise SQL data development.Bachelor's or master's degree in computer science, information technology, or a related field.You have a deep knowledge and familiarity with large-scale, customer-centric, and marketing data sets.Experience across all stages of data analysis, design, and development.Experience in Data Management/Design structures/approaches - OLTP, OLAP, Dimensions, Facts, and Data modeling.Expertise in modular and reusable code development.Work with data engineers and product developers to help identify and resolve data problems.You can analyze and understand previously developed SQL Logic and data workflows.You have knowledge in data validation and transformations across source to target systems.Expertise in SQL development and complex SQL queries for validation.You understand and generate data flows and data models.Develop test strategy, test plan/design, and execute test cases.Overall knowledge of CRM technology infrastructure and how different tools/services/ functionality integrate and facilitate data-driven marketing.Experience processing large, complex clickstream logs.Customer-centric data design and development.Experience in outbound campaign management.You have hands-on programming experience.Experience using Python for data processing.Experience with Customer Data Platforms (CDP).Familiarity with Salesforce Marketing Cloud development.Experience with the AWS data stack – (e.g. Redshift, S3, Dynamo).Proficiency with GitHub (or other version control management practices).Additional Information
Core benefits including full medical, dental, vision, and matching 401K.Flexible schedule, ability to work remotely, hybrid, or in-office.Flexible time off, including volunteer time off, vacation, sick, and 12-paid holidays.Our uniqueness is that we celebrate yours.
Experian's culture and people are important differentiators. We take our people's agenda very seriously and focus on what matters: DEI, work/life balance, development, authenticity, engagement, collaboration, wellness, reward & recognition, volunteering...the list goes on. Experian's people-first approach is award-winning: Great Place To Work in 24 countries, FORTUNE Best Companies to Work, and Glassdoor Best Places to Work (globally 4.4 Stars), to name a few. Check out Experian Life on social media or our careers site to understand why.Experian is proud to be an Equal Opportunity and Affirmative Action employer. Innovation is an important part of Experian's DNA and practices, and our diverse workforce drives our success. Everyone can succeed at Experian and bring their whole self to work, regardless of gender, ethnicity, religion, color, sexuality, physical ability, or age. If you have a disability or special need that requires accommodation, please let us know as soon as possible.
#J-18808-Ljbffr
Experian is a global data and technology company that powers opportunities for people and businesses worldwide. We help to redefine lending practices, uncover and prevent fraud, simplify healthcare, create marketing solutions, and gain deeper insights into the automotive market, all using our unique combination of data, analytics, and software. We also assist millions of people in achieving their financial goals and helping them save time and money.We operate across multiple other markets, from financial services to healthcare, automotive, agribusiness, insurance, and many more industry segments.We invest in people and new advanced technologies to unlock the power of data. As an FTSE 100 Index company listed on the London Stock Exchange (EXPN), we have a team of 22,500 people across 32 countries. Our corporate headquarters are in Dublin, Ireland. Learn more at experianplc.com.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 doingYou 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.Qualifications
You have 6+ years of experience in advanced enterprise SQL data development.Bachelor's or master's degree in computer science, information technology, or a related field.You have a deep knowledge and familiarity with large-scale, customer-centric, and marketing data sets.Experience across all stages of data analysis, design, and development.Experience in Data Management/Design structures/approaches - OLTP, OLAP, Dimensions, Facts, and Data modeling.Expertise in modular and reusable code development.Work with data engineers and product developers to help identify and resolve data problems.You can analyze and understand previously developed SQL Logic and data workflows.You have knowledge in data validation and transformations across source to target systems.Expertise in SQL development and complex SQL queries for validation.You understand and generate data flows and data models.Develop test strategy, test plan/design, and execute test cases.Overall knowledge of CRM technology infrastructure and how different tools/services/ functionality integrate and facilitate data-driven marketing.Experience processing large, complex clickstream logs.Customer-centric data design and development.Experience in outbound campaign management.You have hands-on programming experience.Experience using Python for data processing.Experience with Customer Data Platforms (CDP).Familiarity with Salesforce Marketing Cloud development.Experience with the AWS data stack – (e.g. Redshift, S3, Dynamo).Proficiency with GitHub (or other version control management practices).Additional Information
Core benefits including full medical, dental, vision, and matching 401K.Flexible schedule, ability to work remotely, hybrid, or in-office.Flexible time off, including volunteer time off, vacation, sick, and 12-paid holidays.Our uniqueness is that we celebrate yours.
Experian's culture and people are important differentiators. We take our people's agenda very seriously and focus on what matters: DEI, work/life balance, development, authenticity, engagement, collaboration, wellness, reward & recognition, volunteering...the list goes on. Experian's people-first approach is award-winning: Great Place To Work in 24 countries, FORTUNE Best Companies to Work, and Glassdoor Best Places to Work (globally 4.4 Stars), to name a few. Check out Experian Life on social media or our careers site to understand why.Experian is proud to be an Equal Opportunity and Affirmative Action employer. Innovation is an important part of Experian's DNA and practices, and our diverse workforce drives our success. Everyone can succeed at Experian and bring their whole self to work, regardless of gender, ethnicity, religion, color, sexuality, physical ability, or age. If you have a disability or special need that requires accommodation, please let us know as soon as possible.
#J-18808-Ljbffr