Financial Compliance Data Analyst

12-Apr-2024

Controller - Internal Controls and Compliance

87905BR

University Job Title

Data Scientist 1

Bargaining Unit

None - Not included in the union (Yale Union Group)

Compensation Grade

Administration & Operations

Compensation Grade Profile

Manager; Program Leader (24)

Wage Ranges

Click here to see our Wage Ranges

Searchable Job Family

Accounting/ Financial, Financial

Total # of hours to be worked:

37.5

Work Week

Standard (M-F equal number of hours per day)

Work Location

Central Campus

Worksite Address

150 Munson Street
New Haven, CT 06511

Position Focus:

Reporting to the Senior Financial Compliance Analyst, Analytics, Controller’s Office, this position will play a pivotal role in transforming raw financial data into actionable insights that drive informed decision-making and optimize our business strategies. This will include monitoring financial activity, both through the use of established dashboards as well as through less structured data mining, to identify outliers, trends or other anomalies and perform procedures to investigate such findings. This position will also design, develop and implement advanced analytical models, algorithms and visualizations to uncover key insights, trends, and patterns within the data.  This role will conduct additional ad-hoc data analysis, including extracting/consolidating data, to mitigate risks and identify potential compliance issues. This role is technical in nature and requires expertise in using predictive modeling and machine learning techniques to deliver valuable insights and relationships into the financial data.  This role will also collaborate with management and various University stakeholders to provide insights that support the central finance monitoring program. This position may perform other special projects as required.

Essential Duties

Develop and execute new and/or highly complex algorithms and statistical predictive models and determine analytical approaches and modeling techniques to evaluate potential future outcomes. Establish analytical rigor and statistical methods to analyze large amount of data, using advanced statistical techniques and mathematical analyses.  Manage analytical projects from data exploration, model building, performance evaluation, through implementation. Develop work plans and monitor progress and project timelines. Document coding and changes to work plans using established work group methods in GitHub. Interact with a multidisciplinary team of internal and external peers to regularly, effectively, and openly communicate progress and outcomes of planned work. Attend weekly team meetings to discuss team and project-related activities, issues, change, communications, and updates.

Required Education and Experience

Master’s Degree in computer science, applied/computational mathematics, engineering, biostatistics, statistics, or a quantitative field such as astronomy or geology, economics, health policy, health services research, public policy, or a related field and two years of experience or an equivalent combination of education and experience.

Required Skill/Ability 1:

Exceptional technical skills using tools such as PowerBI, Advanced Excel (pivot tables, vlookups, macros, index match, data mining) and programming languages(Python, SQL, R) to extract, transform and analyze complex data sets.

Required Skill/Ability 2:

Experience with statistical analysis, risk analysis, regression analysis and fraud detection leveraging algorithms and machine learning (Artificial Intelligence) techniques.  Ability to work with large structured and unstructured datasets.

Required Skill/Ability 3:

Excellent oral and written communication skills. Ability to adapt communication style to address the needs of individuals at all levels throughout the University. Strong organizational skills and attention to detail.

Required Skill/Ability 4:

Strong analytical skills to identify trends or outliers. Well-developed problem-solving skills, an intellectual curiosity and inquisitive mindset.

Required Skill/Ability 5:

Ability to work independently, multitask, use good judgment.

Preferred Education, Experience and Skills:

BA in Data Analytics, Statistics, Computer Science, IT, or related field. Four plus years experience in data science, financial data management + analysis/equivalent combination of education and experience. Background in data analysis with diverse set of platforms i.e. Python/R, knowledge of advanced analytic approaches. Experience w/ data collection and coordinating efforts of multiple groups.

Physical Requirements

Physical Requirements:

Background Check Requirements

All candidates for employment will be subject to pre-employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks based on the position description and job requirements. All offers are contingent upon the successful completion of the background check. For additional information on the background check requirements and process visit "Learn about background checks" under the Applicant Support Resources section of Careers on the It's Your Yale website.

COVID-19 Vaccine Requirement

The University maintains policies pertaining to COVID-19. All faculty, staff, students, and trainees are required to comply with these policies, which may be found here:
https://covid19.yale.edu/health-guidelines

Posting Disclaimer

The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the particular position. Employees will be assigned specific job-related duties through their hiring departments.

EEO Statement:

University policy is committed to affirmative action under law in employment of women, minority group members, individuals with disabilities, and protected veterans. Additionally, in accordance with Yale’s Policy Against Discrimination and Harassment, and as delineated by federal and Connecticut law, Yale does not discriminate in admissions, educational programs, or employment against any individual on account of that individual’s sex, sexual orientation, gender identity or expression, race, color, national or ethnic origin, religion, age, disability, status as a special disabled veteran, veteran of the Vietnam era or other covered veteran.

Inquiries concerning Yale’s Policy Against Discrimination and Harassment may be referred to the Office of Institutional Equity and Accessibility (OIEA).

Note

Yale University is a tobacco-free campus