Sr. Data Developer (Remote), Experian Consumer Services

Company Description

Experian is the world’s leading global information services company, unlocking the power of data to create more opportunities for consumers, businesses and society. We are thrilled to share that FORTUNE has named Experian one of the 100 Best Companies to work for. In addition, for the last five years we’ve been named in the 100 “World’s Most Innovative Companies” by Forbes Magazine.

Experian Consumer Services provides credit education and identity protection solutions to consumers and helps businesses manage the impact of a data breach. This group is divided into two divisions; the Direct-to-Consumer team provides these solutions directly to consumers while the Partner Solutions team empowers companies to provide these solutions to their consumers. 

Whether it is directly through our apps/websites or via one of our partners, consumers now have direct access to valuable credit education and identity protection solutions that help them protect their personal information. We are also the leader in Global Data Breach services, helping businesses for over 15 years.

Job Description

Experian is the power behind the data. As the leading holder of consumer and business credit data, we're transforming data into solutions that advance industries, move companies forward, and improve the lives of millions of consumers around the world. Putting the customer at the heart of what Experian does is the foundation of its strategy, which is why the company is putting a lot of emphasis on building an industry-leading Customer Relationship Management (CRM) function to spearhead this movement. We are looking for an experienced, detail-oriented, Sr. Data Developer supporting data-driven marketing & innovation. Our ideal candidate is a hands-on problem solver with a passion for data quality, to work collaboratively on data-driven solution designs and development initiatives supporting customer marketing and service communications.

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 stakeholders to understand the business 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 enable error notifications. Additionally, you will become immersed in our CRM Ops application stack including SalesForce Marketing Cloud, Alteryx, and Campaign Management tools.

What you’ll be doing:

• Conduct data discovery and analysis in support of new Experian Consumer Services (ECS) digital products and programs
• Investigate data errors/discrepancies and SQL job/file transmission failures
• Define data requirements/design in support of 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
• Liaise with cross-functional teams including Technical Teams, Business Intelligence/Data Warehousing, Analytics, Web Operations, Legal, and Marketing

Qualifications

What your background looks like:

Required:

• 5+ years of experience in data development using large data sets
• 5+ years of hands-on expert-level experience developing SQL code
• Experience with Python/Pyspark
• Experience across all stages of data analysis, design, and development
• Experience in Data Management/Design Structures/Approaches - OLTP, OLAP, Dimensions, Facts, and Data modeling
• Programming background (e.g., C/C++, Java, Cobol)
• Ability to troubleshoot, isolate errors, optimize performance, and create standardized, modular, and reusable code where applicable
• Work with data engineers and product developers to help identify and resolve data problems
• Ability to analyze and understand previously developed SQL Logic and data workflows
• Strong knowledge in data validation and transformations across source