Sr 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)

Required Skills/Experience:

• 3+ years of technical experience - 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

Education:

Bachelor's Degree preferred

Candidates must currently be a U.S. Resident to be eligible for this role.

• Please note that U.S. Immigration sponsorship or work visa is not available for this position and candidates must have permanent authorization to work in the U.S.

Hours and Work Schedule

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

Hours per Week - 40

Pay Transparency

The salary range for this position is $105,120 - $157,680 per year, plus an opportunity to earn an annual discretionary bonus. Actual pay is based on various factors including but not limited to the work location, and relevant skills and experience.

We offer competitive pay, comprehensive medical, dental and vision coverage, retirement benefits, maternity/paternity leave, flexible work arrangements, education reimbursement, wellness programs and more. Note, Citizens' paid time off policy exceeds the mandatory, paid sick or paid time-away policy of every local and state jurisdiction in the United States. For an overview of our benefits, visit ;br>
About Us

Equal Employment Opportunity

Citizens, its parent, subsidiaries, and related companies (Citizens), provides 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, transgendered and transitioning individuals, genetic information, genetic characteristic, marital or domestic partner status, victim of domestic violence, family statparenthood, 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. At Citizens we are committed to fostering an inclusive culture that enables colleagues to bring their best selves to work every day and where all are expected to be treated with respect and professionalism. Employment decisions are based solely on experience, performance, and ability. We perform our best so we can do more for our customers, colleagues, communities and shareholders.

Equal Employment and Opportunity Employer

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.