Language Language

English English español español

E Recruit E Recruit


   Back to Results

Job Title:

Business Analyst - SQL Query Experience - Auditing/Billing - Broomfield, CO

Job Description:

One of the world’s largest communication companies, our client has an opening for a Business Analyst, who possesses SQL Query experience, to work on a team at our telecom client site in Broomfield, CO.   Imagine everything that you could learn to advance your career while working at a global communication and IT services company focused on connecting people to the power of the digital world. This position seeks talented candidates who will put the customer at the center of everything they do. Inquire about this opportunity and you could end up on a diverse and inclusive team where you’ll not only be valued but feel inspired to give your all to get the job done.

We work with cross-functional teams to identify and eliminate revenue leakage and increase cost savings in our business, ensuring we bill revenue, manage costs, and maintain margins as effectively as possible. As a Senior Analyst you will be responsible for performing detailed customer audits that identify revenue recovery and cost savings opportunities. You will isolate and research negative or non-optimal margin services, analyze the business drivers, determine root cause and work with functional and business teams to resolve issues. You will serve a critical role in improving cross-functional quote-to-bill and cost-to-revenue processes and developing business intelligence. Your operational activities include negative margin and shelf life monitoring, root cause analysis, develop and implement audits and control points, reporting, and ultimately drive resolution and governance processes with all impacted stakeholders to meet profitability goals. 

-Must be familiar with SQL and writing database queries; seeking someone who is process oriented who understands order entry to billing, in addition to Telecom Voice knowledge 
-Ability to write join statements and sub queries to get data they need 
-Ability to understand legal contract and how it is supposed to be billed 
-Skilled in MS SQL Server & any Oracle Client (i.e., Toad, etc) 

Essential Duties 
• Lead efforts that prevent revenue leakage, reduce cost, increase revenue and reduce defects. Root cause and error resolution resulting in revenue recovery, revenue loss, or cost savings. 
• Audit and evaluate customer’s invoices, contracts, and orders to ensure revenue is billed appropriately and adequate margin is obtained. Analyze customer’s offnet access charges and offnet architecture against customer’s revenue and work with stakeholders to optimize. 
• Architect and implement Financial Assurance controls including source data acquisition, normalization and automation. Implement new control points and metrics as the business changes. 
• Work with and manage multiple departments and cross-functional stakeholders to ensure customers services are at the appropriate margins and installed and disconnected in agreed timeframes. 
• Optimize Business Intelligence including query development and data analysis. Build and run queries, and conduct complex data analysis. 
• Support adhoc requests and projects as requested by the supported organizations and teams. 

Required Knowledge & Skills: 
• 5+ years in Financial Assurance/Financial Analysis/Reporting a must 
• Audit experience is a plus 
• Bachelor’s degree in Business, Finance, Economics or IT 
• Advanced Microsoft Excel skills 
• Proficient in querying a large amount of data using SQL query skills 
• Ability to query and analyze data in Access, Brio, Hyperion, Business Objects or other reporting tools 
• General understanding of data models and various IT platforms/solutions 
• Experience with process mapping, and business requirements documentation 
• Project management and planning skills 
• Understanding of Financial Assurance concepts and application in business 


Job ID:
334846

Dept ID:
10600

Location:
Broomfield, CO
United States of America

Industry:
Online / Full App

Job Type:
Temp Position
Folder Group ID
258

Posted Date:8/8/2018

Domain:arna

Apply for this Position

Job Title: Business Analyst - SQL Query Experience - Auditing/Billing

Location: Broomfield, CO

Job Type: Temp Position

Reference ID: 334846

Posted Date: 8/8/2018

Thank you for your interest in Advantage Resourcing. You have responded that you are not 18 years of age or older. It is Advantage Resourcings policy to hire individuals who are 18 years of age or older. We invite you to reapply when you meet this requirement. If you have questions or concerns about this policy please email recruiting@advantageresourcing.com

Thank you for your interest in Advantage Resourcing. You have responded that you are not authorized to work in the US. Advantage Resourcing adheres to Department of Homeland Security regulations regarding employment of individuals authorized to work in the US. Should you require sponsorship or have questions about these regulations, please contact recruiting@advantageresourcing.com


Please Choose One:
Valid Resume Formats: (.doc .docx .pdf .rtf .txt only)

 

No Resume?

Please enter the following fields in the absence of a Resume

Invitation to Self-Identify

Advantage Resourcing is committed to equality of opportunity for all staff and job applicants. We acknowledge the unique contribution that all individuals can make and we aim to create a working environment in which all individuals are able to make use of their skills, free from discrimination or harassment, and in which all decisions are based on merit. This form is intended to help us maintain equal opportunities best practice and identify barriers to workforce equality and diversity.

The information on this form will be used for monitoring purposes only and will not be used in any decision affecting you. The information you provide will remain anonymous and will be stored separate to any job application. You are not obliged to answer any of these questions but the more information you supply, the more effective our monitoring will be. All information supplied will be treated anonymously.


Voluntary Self-Identification of Disability
Form CC-305 - OMB Control Number 1250-0005
Expires 1/31/2020

Why are you being asked to complete this form?

Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities.i To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way

If you already work for us, your answer will not be used against you in any way. Because a person maybecome disabled at any time, we are required to ask all of our employees to update their information every fiveyears. You may voluntarily self-identify as having a disability on this form without fear of any punishmentbecause you did not identify as having a disability earlier.

How do I know if I have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

Blindness , Autism , Bipolar disorder , Post-traumatic stress disorder (PTSD) , Deafness , Cerebral palsy, Major depression , Obsessive compulsive disorder , Cancer , HIV/AIDS , Multiple sclerosis (MS) , Impairments requiring the use of a wheelchair , Diabetes , Schizophrenia , Muscular dystrophy , Epilepsy , Missing limbs or partially missing limbs , Intellectual disability (previously called mental retardation)

Reasonable Accommodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Submit Application