Sales Comp And Administration Analyst

Sage North America Lawrenceville , GA 30046

Posted 3 months ago

Sage is a global company with a local heart. The market leader for cloud-based accounting, financials, enterprise management, people, and payroll software, we empower the worlds business heroesfrom single-person startups to large enterprises. Our people are passionate and positive. We inspire our colleagues to serve business builders everywhere and champion their success. As a FTSE 100 company with 14,000 colleagues across 24 countries, we do business the right way, while giving back to our local communities through the Sage Foundation. Be Sage, build on.

EOE AA/M/F/Vet/Disability
Sage Software is an Equal Opportunity Employer. We comply with the laws set forth in the Equal Employment Opportunity in The Law poster: http://1sa.ge/EjaS30kzhpR

Sage is committed to Equal Employment Opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. If you are interested in applying for employment and need special assistance or an accommodation to use our website to apply for a position, please contact us at careers@sage.com We evaluate requests for reasonable accommodation on a case-by-case basis.Do you LOVE data?!? Are you not intimidated by giant spreadsheets? Do we have a job for you!

Responsible for the ongoing updates in an SQL database containing commission data. Will handle template inputs, changes, and final calculation updates. There is currently little automation in the commission processes so it is imperative to manage updates in the commission database and ensure that they are done correctly without error. Each error impacts rep payment and may result in over-payment in the following month, followed by unnecessary re-work.Key accountabilities and decision ownership:

  • Conducts data analysis and testing to ensure the integrity of data during conversion, migration & loading process

  • Consolidation and integration of data from multiple sources into a single reporting environment using reports, SQL queries and migration programs

  • Manage multiple, variable tasks and data review processes, as well as mass data entry, maintenance, and update projects

  • Ability to manipulate, validate and organize large amounts of data for internal payments.

  • Continuously improve work processes that affect data quality and timeliness

  • Producing reports consisting of tables and charts for Quality Assurance

  • Hands on experience writing moderate to complex SQL Queries

  • Create report and data reconciliation through Access, Excel, Power BI, Tableau and other reporting tools

Qualifications:

  • 2-4 years business and/or technical/academic training on Data Management tools, financial analysis, reporting, including report development

  • SQL skills highly desired

  • Comfortable working with ambiguity

  • Highly motivated self-starter, often taking initiative before being asked

  • Ability to adapt to rapid change and think creatively

  • High attention to detail with ability to extract data accurately.

  • Logical analytical mind and the ability to recognise discrepancies

  • Proficiency in SQL, Power BI, Tableau, Microsoft Excel (formulas, pivot tables, lookup tables), and other data mining tools

  • Excellent communication skills required to present findings and translate data into an understandable documents or presentations

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Sales Comp And Administration Analyst

Sage North America