Skip to main content

Principal Data Analyst

Data Analytics

Johnston, Rhode Island; Phoenix, Arizona; Charlotte, North Carolina; Westwood, Massachusetts; Franklin, Tennessee

Job ID: 23788

Full/Part Time: Full Time

Shift: 1ST

Description

In this Technology Services - Risk and Finance Principal Data Analyst position, you will work with internal clients to understand, define and document business requirements.

Additional responsibilities will include:

  • Interpreting and translating business requirements into data requirements and linking them to mapping lineage documents used by developer colleagues.
  • Identifying data gaps that may exist between internal client needs against available information housed with the reporting data mart or data warehouse. 
  • Profiling big data sources using SQL across a wide variety of different product “Systems of Record” to satisfy gaps in data requirements.
  • Leading team member discussions to determine the best data source options, requirements gapping, expected data content profiling, and source/transformation/target mapping. 
  • Generating and documenting pseudo logic required to derive data attributes that need to be synthesized from existing base data elements.
  • Providing instruction and ongoing support to developer/programmer resources to ensure mapping documentation is clear and well understood. 
  • Supporting others within the Enterprise Data Organization in their implementation and testing of expected data outcomes.
  • Generating complex data queries to perform testing and validation checks as required to assist developers with production code migrations or post-prod validations.

Experience and Skills:

  • 5-10 years of work experience as a Business Analysts in a large data environment
  • Strong analytical and systemic thinking, problem solving, and SQL skills
  • Strong communication (written and verbal), presentation skills
  • Proven technical Documentation skills— using MS Office 365 Suite
  • Demonstrated ability to manage multiple projects to completion
  • Self-Starter comfortable working independently or as part of a team
  • Desire to learn emerging methods and technologies and wanting to stay on top of latest ideas within the logical mapping design and development discipline
  • Experience with the following a plus, DB2, Oracle, MS SQL, Dbeaver, AWS Redshift, Athena, SAS
  • Working knowledge of Aqua Data Studio or comparable query tool to analyze data in a variety of DBMSs (Database Management Systems)

Education and Certifications

  • Bachelor's Degree in Business, OIM (Operations and Information Management), Computer Science, or Mathematics.

Hours & Work Schedule

Hours per Week: 40

Work Schedule: Monday through Friday, 8:30AM – 5:00PM

Some job boards have started using jobseeker-reported data to estimate salary ranges for roles. If you apply and qualify for this role, a recruiter will discuss accurate pay guidance.

Benefits

We offer competitive pay, comprehensive medical, dental and vision coverage, retirement benefits, maternity/paternity leave, flexible work arrangements, education reimbursement, wellness programs and more.

View Benefits

Awards We've Received

2022

The Banker’s Bank of the Year

2022

Dave Thomas Foundation for Adoption Top 100 Best Adoption-Friendly Workplace

2022

DiversityInc
Noteworthy Company for Diversity

2022

Human Rights Campaign Best Places to Work for LGBTQ Equality

2021

Military Friendly Employer

Apply
  • CSI Investment Assistant Boston, Massachusetts; Columbus, Ohio; Monroeville, Pennsylvania; East Naples, Florida Boston, Massachusetts, Columbus, Ohio, Monroeville, Pennsylvania, East Naples, Florida
    View Job
  • CSI Investment Assistant East Naples, Florida; Boston, Massachusetts; Columbus, Ohio; Monroeville, Pennsylvania East Naples, Florida, Boston, Massachusetts, Columbus, Ohio, Monroeville, Pennsylvania
    View Job
  • Citizens Branch Manager II Niantic, Connecticut; Groton, Connecticut; New London, Connecticut; Waterford, Connecticut Niantic, Connecticut, Groton, Connecticut, New London, Connecticut, Waterford, Connecticut
    View Job
0