SPM Senior Data Engineer

Job Description

This role requires FINRA certification.

This colleague works on the Sales Performance Management team and is responsible for data research & curation for the purposes of sales performance management, incentives, & compensation.

Areas of Focus :

• Process Modernization
• Support and advance the SPM roadmap for modernization
• Increase use of enterprise data assets as source of information
• Reduce dependencies on more manual data curation tools and applications
• Increase availability and proximity to code for SPM users
• Non-Compensation System Plan Support
• Support incentive plan administration until onboarded to compensation system (ICM)
• Support data feeds to ICM
• Support migration to ICM
• Data Sourcing, Reacting, and Quality
• Source data for incentive plan fulfillment and progress reporting
• Collaborate with teams in Technology Services Organization, Enterprise Data Organization and other SPM teams on development and implementation of data asset roadmap, data assets, and sourcing data
• Research and cure potential data quality issues
• Data Sharing
• Transmissions set-up and support
• Reporting and quality assurance support
• Business Analysis
• Gather business requirements & translate to technical solutions
• Effective management of projects with varying degrees of complexity and length and act as team lead on certain projects
• Build solution documentation for build / support
• Administrative
• SQL server administration
• Sandbox Maintenance
• Tools and Access SME (Alteryx, SQL, Redshift etc.)
• EUDA maintenance / modernization / elimination
• Internal team documentation of process and procedures
• External documentation for business partners (exports, processes, procedures)

Skills :

• Technical understanding - demonstrated ability / understanding of databases, ETL tools, BI and database query tools such as : SQL, Tableau Prep, Alteryx, Tableau, Python
• Advanced knowledge of SQL and ETL
• AWS Cloud (S3, Redshift, etc.)
• SQL Server Administration experience
• Strong leadership and communication skills
• Ability to collaborate and self-start

Competencies :

• Communicating
• Detail Oriented
• Building understanding and trust
• Collaborating for success
• Influencing
• Finding Solutions
• Critical Problem Solving
• Gathering Information
• Project Management

Hours and Work Schedule

Work Schedule - Monday-Friday, 8 : 30am- 5 : 00pm

Hours per Week - 40

About Us

Equal Employment Opportunity

At Citizens we value diversity, equity and inclusion, and treat everyone with respect and professionalism. Employment decisions are based solely on experience, performance, and ability.

Citizens, its parent, subsidiaries, and related companies (Citizens) provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to age, ancestry, color, citizenship, physical or mental disability, perceived disability or history or record of a disability, ethnicity, gender, gender identity or expression (including transgender individuals who are transitioning, have transitioned, or are perceived to be transitioning to the gender with which they identify), genetic information, genetic characteristic, marital or domestic partner status, victim of domestic violence, family status / parenthood, medical condition, military or veteran status, national origin, pregnancy / childbirth / lactation, colleague's or a dependent's reproductive health decision making, race, religion, sex, sexual orientation, or any other category protected by federal, state and / or local laws.

Equal Employment and Opportunity Employer

Citizens is a brand name of Citizens Bank, N.A. and each of its respective affiliates.

Job Applicant Data Privacy Policy

Background Check

Any offer of employment is conditioned upon the candidate successfully passing a background check, which may include initial credit, motor vehicle record, public record, prior employment verification, and criminal background checks.

Results of the background check are individually reviewed based upon legal requirements imposed by our regulators and with consideration of the nature and gravity of the background history and the job offered.

Any offer of employment will include further information.