Overview

　　Job Title-Analyst-Financial system-SQL

　　Location

　　Aptean is changing. Our bespoke ERP solutions are transforming a huge range of global businesses, from food producers to manufacturers. In a world of generic enterprise software, we provide targeted solutions that bring together the very best technology and drive greater results. With over 3000 employees, 50 different products and a global client base, there's no better time to advance your career at Aptean.

　　2. GENERAL JOB SUMMARY

　　Provide technical support, administration, and maintenance of Data Warehouse and IBM Planning and Analytics

　　3. SCOPE

　　4. ORGANIZATION (Indicate the job positions reporting to this role)

　　Full line:

　　• Job (# of positions): 1

　　Dotted line:

　　• Job (# of positions):

　　5. PRINCIPAL DUTIES AND RESPONSIBILITIES

　　• Provide technical support, administration, and maintenance of Data Warehouse and IBM Planning and Analytics or TM1

　　• Act as a liaison with third party vendors to troubleshoot systems

　　• Work with SQL databases to create reports and stored procedures

　　• Develop an understanding of accounting processes within Aptean and how accounting systems work with each other and other systems at Aptean

　　• Support all aspects of internal and external audit as related to accounting systems

　　• Assist with scaling Finance specific team in the COE to support Aptean growing business

　　6. JOB SPECIFICATIONS

　　Education (Indicate the minimum level of education necessary for this position. Check all that apply and indicate specific degree as applicable to the side (e.g., Bachelor's in Computer Science)

　　Required Preferred Degree/Certification

　　☒ ☐ Bachelor's degree

　　☐ ☒ Master's degree

　　☐ ☐ Ph.D.

　　☐ ☐ J.D. (law)

　　☐ ☐ Certification:

　　☐ ☐ Registration:

　　☐ ☐ Licensure:

　　☐ ☐ Other:

　　Work Experience

　　• Prior experience working with Data Warehouse and IBM Planning and Analytics

　　• Experience administering Data Warehouse and IBM Planning and Analytics

　　Knowledge, Skills and Abilities

　　• Microsoft SQL skills - Writing queries and stored procedures

　　• Microsoft Excel skills - Pivot tables and macros

　　• A moderate understanding of standard business practices related to accounting

　　• A strong work ethic to solve problems, accomplish objectives, and meet deadlines

　　• At least 2 years of experience in Data Warehouse and IBM Planning and Analytics

　　• Knowledge of Intacct API is a plus

　　DISCLAIMER

　　The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

　　If you share our mindset, you can share in our success. To find out more about joining Aptean, get in touch today.

　　Learn from our differences. Celebrate our diversity. Grow and succeed together.

　　Aptean pledges to promote a company culture where diversity, equity and inclusion are central. We are committed to applying this principle as we interact with our customers, build our teams, cultivate our leaders and shape a company in which any employee can succeed, regardless of race, color, sex, national origin, sexuality and gender identity, religion, disability or age. Celebrating our diverse experiences, opinions and beliefs allows us to embrace what makes us unique and to use this as an asset in bringing innovative solutions to our customer base.

　　"At Aptean, our global and diverse employee base is our greatest asset. It is through embracing and understanding our differences that we are able to harness our individual power to maximize the success of our customers, our employees and our company." - TVN Reddy