Salary : $5,364.67 - $7,404.80 MonthlyLocation : Minneapolis, MNJob Type: Regular StatusRemote Employment: Flexible/HybridJob Number: 2024-01291Division: Finance & AdministrationDepartment: FinanceOpening Date: 01/06/2025Closing Date: 1/21/2025 3:00 PM CentralMN Data Practices: The Metropolitan Airports Commission (MAC) collects information from applicants for the purposes of determining employment suitability. By providing information, MAC will use the information to determine employment suitability. Applicants are not legally required to provide the requested information. However, information not provided, other than race, gender, or disability, may prevent MAC from being able to consider the application or determine the applicant's suitability for the position. The information collected may be classified as public or private data under the MGDPA. Public means that data is available upon request. Private means the data is only available to the person the information is about, and to those who must see it in the course of conducting MAC business and as otherwise provided for by law. If the applicant becomes a MAC employee, then some of the collected information is required to be shared with a representative union.Position Summary Do you want to work for an organization with a purpose? Come work for the Metropolitan Airports Commission! The Metropolitan Airports Commission (MAC) is seeking a Payroll Specialist to join the Finance and Payroll team. In coordination with the payroll team, a Payroll Specialist performs advanced payroll transactions that ensure timely and accurate processing of payroll for the Metropolitan Airports Commission employees which includes thirteen bargaining units. Independently audits, balances, and corrects payroll documents and payroll time records; processes payroll adjustments, retroactive pay, cost of living adjustments, union contract changes, and salary increases; prepares federal and state tax reports on a quarterly basis; uses ERP software (JDE Edwards Enterprise One) to prepare payroll and year-end reports; and performs related duties as assigned.This position provides an opportunity for on-site and remote work. MAC's remote work policy requires employees to be on-site three days of the week. Among the three on-site days, one of them must be either a Monday or a Friday. To apply: Click the Apply link located above the position description, log-in and follow the instructions provided. Questions regarding this position can be directed to Alaina Reede at ...@mspmac.org or at (612) ###-####. Applications will be accepted until 3:00 p.m. on Tuesday, January 21, 2025. MAC complies with the Americans with Disabilities Act. If an accommodation is required for you to participate in the application process because of a disability, please contact Tekia Jefferson at 612-###-#### or MAC is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, gender, age, nationality, or disability. Position Description Bi-weekly Payroll Processing
- Audit employee time entry submissions through the JD Edwards ERP system and UKG for accuracy of hours, earnings, compliance with state and federal regulations, contract agreements, and MAC policies.
- Review calculations based on Fair Labor Standards Act (FLSA) standards for overtime, contract premiums, and shift differentials per collective bargaining agreements.
- Maintain current knowledge of MAC policies, applicable federal and state laws, and union contract agreements.
- Review error reports, trace errors, and make appropriate corrections to ensure timely processing of payroll checks.
- Import time entry from time-keeping system.
- Perform setup and maintenance processes for general deductions; verify and reconcile mandatory and voluntary deductions including benefits, accruals, and special individual deductions.
- Maintain files and records on garnishments, child support, levies, and severance pay.
- Audit and import online expense reports to be processed through payroll.
- Review, verify, and enter direct deposit information.
- Calculate and process wage adjustments relating to overtime, promotions, reclassifications, retroactive pay, cost of living adjustments, terminations, etc.
- Prepare and generate files for transmitting direct deposit payroll information to financial institutions.
- Process and document vouchers for payments to vendors to accounts payable.
- Prepare, reconcile, and submit bi-weekly payroll related filings for deferred compensation, employee garnishments, pension contributions, HSA/FSA contributions, and employee payroll information to the appropriate financial institution for payments.
- Prepare biweekly payroll related journal entries; evaluate for accuracy, completeness, and conformity with established collective bargaining agreements and procedures.
- Submit approved payroll tax information to service provider for tax filings and payments.
- Process calculations for and track longevity, holiday, and educational pay.
- Provide information to internal and external auditors and other departments as appropriate in the verification of payroll related processes.
- Respond tactfully, timely, and accurately to phone calls, emails, employee issues, and requests for information.
Timekeeping Administration
- Review timecards for accuracy and verify manager approvals.
- Support assigned MAC groups with assistance for the time keeping system.
- Serve as a back-up to the Payroll Manager for system administration.
- Use the in-menu reporting system in the time keeping system to gather data for other departments for monthly billings.
Reporting and Follow Up Requests
- Prepare bi-weekly paid time off reports.
- Prepare quarterly Federal and State tax reports.
- Reconcile quarterly 941 reports to total Federal and State tax payments.
- Prepare bi-weekly payroll reports (e.g., DBA register, check register, pension reports, etc.).
- Responsible for the application of state aid reimbursement for police pensions.
- Process other department wage and audit requests.
Other Responsibilities
- Maintain online expense reporting, employee reporting workflow, and reimbursement rates in the JD Edwards system.
- Provide employee training for online expense reporting process as needed.
- Process employee stipend requests and prepare annual stipend audit.
- Prepare and submit the monthly Commission Report - Travel, Payroll Expenditures, etc.
- Provide back-up support to the Payroll Manager for maintaining the MACpoint Payroll webpage.
- Process off-cycle payrolls as requested.
- Other duties as assigned.
COMPETENCIESIndividual Contributor (IC) Competencies
- Customer Focus - Building strong customer relationships and delivering customer-centric solutions
- Decision Quality - Making good and timely decisions that keep the organization moving forward
- Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm
- Optimizes Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement
- Ensures Accountability - Holding self and others accountable to meet commitments
- Collaborates - Building partnerships and working collaboratively with others to meet shared objectives
- Values Differences - Recognizing the value that different perspectives and cultures bring to an organization
- Communicates Effectively - Developing and delivering multi-mode communications that convey a clear understanding of unique needs of different audiences
- Courage - Stepping up to address difficult issues, saying what needs to be said
- Instills Trust - Gaining the confidence and trust of others through honesty, integrity, and authenticity
- Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels
- Situational Adaptability - Adapting approach and demeanor in real time to match the shifting demands of different situations
Position Requirements MINIMUM REQUIREMENTS
- High school diploma or equivalent, such as a GED.
- Three years of experience processing in-house payroll for 100+ employees.
- Experience applying applicable state and federal laws to payroll processing and transactions.
- Intermediate skill level using Microsoft Word, Excel, and Outlook.
- Ability to add, subtract, multiply, and divide using whole numbers, fractions, and decimals.
- Ability to compute rate, ratio, and percent.
- Strong communication, interpersonal, and collaboration skills.
- Ability to analyze data, identify errors or trends, and recommend corrective action as needed.
- Ability to perform under pressure to meet deadlines.
- Strong attention to detail.
- Experience using payroll software.
- Ability to maintain strict confidentiality.
DESIRABLE REQUIREMENTS
- Associate's degree in accounting, finance, or a related field.
- Experience applying Human Resources policies and multiple collective bargaining agreements to payroll processes.
- Experience using JD Edwards Enterprise One.
- Valid APA sponsored FPC or CPP certifications.
- Experience with timekeeping systems that integrate with payroll systems, preferably UKG.
- Basic understanding of tax laws.
- Knowledge of IRS Publication 15.
- Knowledge of the Minnesota Government Data Practices Act.
- Experience with public pension funds, such as PERA.
Other InformationYour health. Your time. Your future. Good pay is only the beginning.See the many and generous the Metropolitan Airports Commission offers to employees.01 I became of aware of this opportunity through:
- Job Interest Card Notification
- MAC Employee
- MAC Web Site
- LinkedIn
- GovernmentJobs.com
- Indeed.com
- Other
02 This position is eligible for a hybrid work schedule after two months of service. MAC's hybrid work schedule includes two days remote and three days onsite. One of the onsite days must be a Monday or Friday.I am aware of this policy and remain interested in this position.
03 What is your highest level of education?
- High school diploma or equivalent (such as a GED)
- Associate's degree
- Bachelor's degree
- Master's degree or above
- None of the above
04 If you indicated that you have a post-secondary degree, please provide your major/minor course(s) of study and the degree(s) you hold. 05 Indicate your experience using Microsoft Word. Check each function you are proficient with.
- Create and save new document
- Open, fill-in and save an existing template
- Enter and edit text
- Select, move and copy text
- Format text
- Set and remove tabs
- Access the help feature
- Run a basic mail merge to print form letters and labels
- Check spelling and grammar
- Set margins
- Print and preview documents
- Design new template
- Create page breaks
- Create numbered and bulleted lists
- Create headers and footers
- Insert clip art, graphics and symbols
- Size and format graphics
- Create, navigate and edit columns
- Electronically route documents for review
- Use comments function
- Find and replace text
- Modify tables, including margins, columns, rows, headers and general format
- Create new table
- None of the above
06 Indicate your experience using Microsoft Excel. Check each function you are proficient with.
- Open, close and save a workbook
- Set page margins and print area
- Format and align numbers, text, columns, rows and cells
- Cut, paste and delete cells
- Insert or delete rows and columns
- Edit existing data
- Enter new data in existing worksheet
- Create a new workbook
- Use AutoFill function
- View multiple panes
- Insert, delete, copy and move worksheets
- Insert graphics
- Create a criteria range
- Create default templates
- Create and format charts
- Search and replace text
- Protect and unprotect cells
- Hide and unhide columns or rows
- Use drawing tools
- Use Solver
- Share workbooks
- Create custom toolbars
- Apply borders and shading
- Establish fixed or absolute cell address
- Sort data on single and multiple levels
- None of the above
07 Indicate your experience using Microsoft Outlook. Check each function you are proficient with.
- Sort e-mail
- E-mail display
- Forward e-mail
- Create new e-mail
- Send message
- Calendar - Display
- Calendar - Day view
- Meeting planner
- Contacts - view
- Create new contact
- Print contact list
- Mark task as complete
- View sent items
- Create appointment
- Schedule recurring meetings
- Return receipt
- Rules wizard
- Autopick meeting
- Autodialer
- Explore web page
- Journal - display
- Journal - view activity
- Notes
- Category - mark
- None of the above
08 How many years of full-time experience do you have processing in-house payroll for 100+ employees?
- None
- Less than one year
- One to two years
- Three or more years
09 Are you able to add, subtract, multiply, and divide using whole numbers, fractions, and decimals?
10 Are you able to compute rate, ratio, and percent?
11 Are you able to analyze data, identify errors or trends, and recommend corrective action?
12 Are you able to perform under pressure to meet deadlines?
13 Are you able to maintain strict confidentiality of data and information?
14 Do you have experience using payroll software?
15 Do you have experience using JD Edwards Enterprise One software?
16 Do you have experience using UKG timekeeping software?
17 Please describe your experience using payroll and/or timekeeping software. Please include the name(s) of the software you have used and the type of work you performed with each. If you do not have this experience, please enter N/A in the space provided. 18 Describe your experience applying Human Resources policies and multiple collective bargaining agreements to payroll processes. Please include the name(s) of the employer(s) where you gained this experience. If you do not have this experience, please enter N/A in the space provided. 19 Please select the items below that you have experience or familiarity with. Check all that apply.
- Tax laws
- IRS Publication 15
- Minnesota Government Data Practices Act
- Public pension funds
Required Question