What are the responsibilities and job description for the Staff Auditor-Data Analytics position at Ameriprise Financial Services, LLC?
Ameriprise Financial is looking to add a Staff Auditor- Data Analytics to the team! The individual in this role will apply data analytics and business intelligence solutions to meet Internal Audit objectives. Execute repeatable data analytics processes to provide audit assurance and improve audit efficiency and effectiveness. Help evolve the analytics program for Internal Audit throughout the implementation and execution process.
Key Responsibilities
Support the Internal Audit data analytics program throughout all phases of the audit process, including risk assessment, planning & scoping, fieldwork and reporting. Responsible for developing and executing data analysis procedure during audit engagements, under the supervision of audit project leads. Includes extracting business information from IT systems and databases, evaluating it and using it to develop strategies to attain audit objectives.
Utilize Power BI capabilities (i.e., DAX, Power Query) to create visual dashboards for audit reporting and continuous auditing. These dashboards will provide insight into transactional records and enhance decision making capacity during audits.
Leverage Computer Assisted Audit Techniques (CAATs) such as robotic process automation (RPA), process mining, and other computer programming skills (e.g., Python) to automate audit data collection and audit testing practices for process improvements.
Leverage analytical procedures to execute continuous audit engagements and continuous risk assessments.
Keep abreast of new industry tools and emerging technologies which may offer improved functionality or a more efficient and effective ability to deliver audit analytics solutions.
Required Qualifications
Bachelor's degree or equivalent
0-1 years of experience
Experience or strong academic knowledge with data manipulation programming languages (i.e.,SQL, Python,R, Power BI DAX)
Strong understanding of or experience with relational databases
Experience with Excel data manipulation
Excellent oral and written communication skills
Ability to thrive in a team environment or work independently
Ability to collaborate with a team through open communication and sharing of ideas in a clear and concise manner
Adaptability to work and communicate with various business units
Preferred Qualifications
Degree in Data Science, IT, Economics, Finance, Accounting
Master's degree
CIDA, ACDA, MCSA, Cert Internal Auditor, Cert Bank Auditor, Cert Public Accountant, Cert Internal Systems
Professional work experience
Accounting Information Systems, Management Information Systems, Computer Sciences or Data Analytics degree
Machine Learning tools and techniques
About Our Company
We’re a diversified financial services leader with more than $1.5 trillion in assets under management, administration and advisement as of 2024. With our team of more than 20,000 people in 20 countries, we advise, manage and protect assets and income of more than 3.5 million individual, small business and institutional clients. We are a longstanding leader in financial planning and advice, a global asset manager and an insurer. Our unwavering focus on our clients and strong financial foundation connects each of our unique businesses - Ameriprise Financial, Columbia Threadneedle Investments and RiverSource Insurance and Annuities. Here, we foster meaningful careers, invest in the future, and make a difference for clients, institutions and communities around the world.
Base Pay Salary
The estimated base salary for this role is $66,700 - $90,000/year. We have a pay-for-performance compensation philosophy. Your initial total compensation may vary based on job-related knowledge, skills, experience, and geographical work location. In addition, most of our roles are eligible for variable pay in the form of bonus, commissions, and/or long-term incentives depending on the role. We also have a competitive and comprehensive benefits program that supports all aspects of your health and well-being, including but not limited to vacation time, sick time, 401(k), and health, dental and life insurances.
Ameriprise Financial is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, national origin, genetic information, age, sexual orientation, citizenship, gender identity, disability, veteran status, marital status, family status or any other basis prohibited by law.
Full-Time/Part-Time
Full time
Exempt/Non-Exempt
Exempt
Job Family Group
Finance
Line of Business
FIN Finance
Key Responsibilities
Support the Internal Audit data analytics program throughout all phases of the audit process, including risk assessment, planning & scoping, fieldwork and reporting. Responsible for developing and executing data analysis procedure during audit engagements, under the supervision of audit project leads. Includes extracting business information from IT systems and databases, evaluating it and using it to develop strategies to attain audit objectives.
Utilize Power BI capabilities (i.e., DAX, Power Query) to create visual dashboards for audit reporting and continuous auditing. These dashboards will provide insight into transactional records and enhance decision making capacity during audits.
Leverage Computer Assisted Audit Techniques (CAATs) such as robotic process automation (RPA), process mining, and other computer programming skills (e.g., Python) to automate audit data collection and audit testing practices for process improvements.
Leverage analytical procedures to execute continuous audit engagements and continuous risk assessments.
Keep abreast of new industry tools and emerging technologies which may offer improved functionality or a more efficient and effective ability to deliver audit analytics solutions.
Required Qualifications
Bachelor's degree or equivalent
0-1 years of experience
Experience or strong academic knowledge with data manipulation programming languages (i.e.,SQL, Python,R, Power BI DAX)
Strong understanding of or experience with relational databases
Experience with Excel data manipulation
Excellent oral and written communication skills
Ability to thrive in a team environment or work independently
Ability to collaborate with a team through open communication and sharing of ideas in a clear and concise manner
Adaptability to work and communicate with various business units
Preferred Qualifications
Degree in Data Science, IT, Economics, Finance, Accounting
Master's degree
CIDA, ACDA, MCSA, Cert Internal Auditor, Cert Bank Auditor, Cert Public Accountant, Cert Internal Systems
Professional work experience
Accounting Information Systems, Management Information Systems, Computer Sciences or Data Analytics degree
Machine Learning tools and techniques
About Our Company
We’re a diversified financial services leader with more than $1.5 trillion in assets under management, administration and advisement as of 2024. With our team of more than 20,000 people in 20 countries, we advise, manage and protect assets and income of more than 3.5 million individual, small business and institutional clients. We are a longstanding leader in financial planning and advice, a global asset manager and an insurer. Our unwavering focus on our clients and strong financial foundation connects each of our unique businesses - Ameriprise Financial, Columbia Threadneedle Investments and RiverSource Insurance and Annuities. Here, we foster meaningful careers, invest in the future, and make a difference for clients, institutions and communities around the world.
Base Pay Salary
The estimated base salary for this role is $66,700 - $90,000/year. We have a pay-for-performance compensation philosophy. Your initial total compensation may vary based on job-related knowledge, skills, experience, and geographical work location. In addition, most of our roles are eligible for variable pay in the form of bonus, commissions, and/or long-term incentives depending on the role. We also have a competitive and comprehensive benefits program that supports all aspects of your health and well-being, including but not limited to vacation time, sick time, 401(k), and health, dental and life insurances.
Ameriprise Financial is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, national origin, genetic information, age, sexual orientation, citizenship, gender identity, disability, veteran status, marital status, family status or any other basis prohibited by law.
Full-Time/Part-Time
Full time
Exempt/Non-Exempt
Exempt
Job Family Group
Finance
Line of Business
FIN Finance
Salary : $66,700 - $90,000
Staff Auditor - Payment Services
U.S. Bank -
Minneapolis, MN
Staff Auditor – Centralized Operations
U.S. Bank -
Minneapolis, MN
Analytics Data Analyst
Fairview Health Services -
Minneapolis, MN