Tobacco Data Analyst (Governmental Auditor 3)
The Oregon Department of Justice (DOJ) is seeking candidates to consider for the position of Tobacco Data Analyst (Governmental Auditor 3). The selected candidate will join the Tobacco Enforcement Unit in the Civil Enforcement Division. In this role, you will assist management in making data-driven decisions. Tobacco regulation generates and utilizes data from a variety of sources. You will gather and examine a variety of financial records, tobacco sales data and other documentary evidence to reconcile and summarize high volumes of data regarding tobacco sales, payments, and compliance. If you enjoy combing through and reconciling data, making data-driven decisions while remaining open to create solutions, and have the patience to sit with a problem and not rush to an answer, we hope to hear from you.
WHAT’S IN IT FOR YOU
- Permanent, full-time employment in Oregon’s capitol city.
- A workplace where individual contribution matters and is recognized, where creativity and accomplishment are rewarded.
- Opportunity to expand your government auditing and regulatory skills.
- Vacation, sick leave, paid holidays, in addition to special paid time off.
- Excellent health insurance, and very low premiums: 95-99% employer-paid medical, vision, and dental for you and your family.
- Pension and retirement programs.
- Support and representation from the Service Employees International Union (SEIU).
DUTIES AND RESPONSIBILITIES (in part)
Data Analysis and Reporting
- Examine a variety of source documentation (invoices, financial records, general ledger, and/or various reports filed with governmental entities) to determine the flow of tobacco products through the distribution chain.
- Assist management in making data-driven decisions regarding deployment of audit and inspection resources.
- Gather and analyze large, complex raw data sets to make the data usable and understandable.
- Create models to glean specific, relevant information from the data and to identify patterns in the data. Examine large volumes of potentially conflicting data sets and use analytical techniques.
- Compile or review work papers to summarize reportable findings in preparation for report writing.
- Summarize large amounts of data gathered from numerous sources into comprehensive reports for management, auditors, law enforcement, and other stakeholders.
- Coordinate with other law enforcement or regulatory jurisdictions in multi-jurisdictional investigations; maintain good working relationships with other agencies to facilitate information exchanges and referrals; provides technical expertise on data analysis.
Internal Dataset Auditing
- Examine reports submitted by tobacco distributors, manufacturers and reconcile to internal database.
- Prepare data for production to third-party accounting firm.
- Review source documentation and reconcile calculations made by third-party accounting firm regarding cigarette sales in Oregon.
- Participate in any dispute resolution proceedings as an expert witness.
- Review account activity (including investments) and verify compliance with tobacco regulations and escrow agreements.
- Review voluminous payment notices, instructions, and calculations and reconcile payments owed to the State of Oregon.
- Study new pronouncements on accounting principles, data analytics, and auditing standards and techniques as developed by authoritative bodies within the profession.
REQUIRED AND SPECIAL SKILLS AND EXPERIENCES
Must illustrate ALL of the following.
- Hold a Bachelor's degree in a business-related field, such as business administration, public administration, finance, economics, computer science, etc.; and has completed a minimum of 18 semester hours in accounting coursework.
- Three (3) years of auditing experience that includes one year of experience doing governmental auditing.
- One (1) year of auditing experience that included electronic data processing to reach conclusion.
- Extensive knowledge of: generally accepted accounting principles; investigative and fact-finding principles and practices; and principles and methods of data collection, analysis, and evaluation.
- General knowledge of: common financial and business recordkeeping, and computerized data records; and corporate structures including subsidiary activities and companies.
- Experience reaching logical conclusions and presenting written and verbal reports of facts following audits involving conflicting allegations or data.
Twenty quarter hours of college courses in a business or financial field such as the areas listed above AND two (2) additional years’ experience doing governmental auditing may substitute for the degree; however, candidates with a Bachelor’s degree may be given greater consideration. Also, successful completion of the duties and training as an Oregon Governmental Auditor (Entry) will substitute for one year of governmental auditing experience.
DESIRED SKILLS AND EXPERIENCES
- Experience working with and managing data sets.
- Demonstrated ability to synthesize data and convey information in a meaningful way.
- Experience auditing financial transactions, including the assessment of the validity of those transactions.
- Experience in professional accounting, with experience in forensic accounting preferred
- Applied knowledge of accounting transactions, practices, procedures and record keeping standards.
- Experience constructing an organized and detailed account of financial transactions from disorganized records.
- Expert in Microsoft Excel.
- Experience in confrontational and witness interviewing to gather evidence for legal action.
- Experience providing testimony at court hearings and/or trials.
- Experience working as part of a multidisciplinary team and collaborating with others, both in person and using technology to collaborate from a distance.
- Experience writing comprehensive audit, investigative, or analytical reports.
- Possess excellent analytical, communication, and organizational skills.
- Certification as a CPA or a CFE (Certified Fraud Examiner) is a plus.
- Able to maintain a valid driver license or have an acceptable mode of transportation in order to travel to required meetings.
- Experience planning and conducting internal audits, preferably in a state or other government agency.
- References support a history of innovative and service-minded thinking, problem-solving, critical thinking, accountability, adaptability while maintaining the highest degree of ethical conduct, and a demonstrated ability and desire to work independently in an office setting with long periods of time reviewing voluminous data, financial records, and other technical materials.
- Demonstrated cultural competence and commitment to addressing issues related to implicit bias, diversity, and inclusion.
- Tact and diplomacy in dealing with complex, sensitive, and confidential issues.
- Life-long learner with established credibility.
- Reputation as someone who builds and maintains strong business connections.
- Follow the "Apply" link above and complete the application online and all supplemental questions.
- Attach your resume.
- Attach your cover letter. To help us get to know you, please describe in your letter your experience with data analytics and accounting—briefly elaborate on the level of responsibility you’ve been given during your assignments, including scope (breadth and depth) of the reviews performed, the types of work done (include any State of Oregon experience), and your specific experience with software and other tools used in data analysis.
Transcripts will be requested prior to interview.
ALL APPLICANTS: You will only have one opportunity to upload the required resume, cover letter, and writing sample. Drag and drop all three into Workday when prompted to upload your resume. If you are concerned that any of the required documents didn't attach to your application, please email a copy to the recruiter noted at the bottom of this job posting. Material will be associated on your behalf if received before the posting deadline.
CURRENT STATE EMPLOYEES: Login to Workday using your state-issued login, and apply via the Career Worklet located on your home page. Using a private account disrupts the hiring process for all internal candidates.
Candidates from diverse backgrounds are encouraged to apply. The Department of Justice is an equal opportunity employer, does not discriminate based on race, color, national origin, ethnicity, veteran, gender, sexual orientation, religion, age or disability, and is committed to workplace diversity.
For additional information regarding benefits and application assistance, click HERE.
Oregon Department of Justice
1162 Court St NE
Salem OR, 97301
Phone: (503) 947-4328
Fax: (503) 373-0367