Billing System Consultant

Artech Information System LLC; Centennial (CO); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading IT staffing company based in Centennial, CO is seeking a Data Analyst to review and implement billing processes. The ideal candidate will have over 3 years of data analysis experience, with strong SQL programming skills. Responsibilities include supporting data remediation and auditing operations, alongside creating data collection methods to automate reporting. This role requires effective communication skills and the ability to synthesize large amounts of data into KPIs. Competitive compensation is offered along with opportunities for professional growth.

Qualifications

• 3 years of data analysis and information reporting experience.
• Knowledge of CSG and Amdocs billing systems.
• Experience with relational databases and query/report creation.

Responsibilities

• Review and implement billing processes.
• Support data discrepancy remediation.
• Analyze billing and system data for operational audits.

Skills

Data analysis

SQL programming

Analytical skills

Communication skills

Root cause analysis

Automating reporting efforts

Interpersonal skills

Statistical concepts

Education

BS in Finance, Math, Engineering or equivalent experience

Tools

SQL

Oracle

Tableau

Hadoop

Hive

Job description

Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.

Job Description

Location: Centennial , CO

Duration: 12 months

Job Responsibilities

• Review, Document & Implement billing processes. Validation to Comcast standards. Propose detailed steps to resolve issues.
• Support data discrepancy remediation, documentation and validation in market clean-up activities.
• Subject Matter Expert to help ensure automated tools are correct and implementable.
• Analyze billing and system data to support operations audits in Video and HSD.
• Identify and implement metric collection opportunities across billing system ecosystems which will drive actionable business decisions.
• Work with tool automation team in the collection, validation and reporting of business data allowing it to become scalable and repeatable.
• Ensures accuracy of data through partnerships with team members. Provides validation and spot checks of data as needed.
• Leverage audit tools to improve business practices.

Skills Required

• 3 years of data analysis and information reporting experience, including 2 years obtaining an understanding of information repository issues and concepts.
• 3 - 5 Years related experience in CSG and Amdocs billing systems.
• Extensive experience in SQL programming.
• Strong analytical, conceptual and root cause analysis skills.
• Ability to synthesize large amounts of data into meaningful, business driving KPIs and communicate that data visually.
• Experience in creating data collection methods for organizations that automate reporting efforts for the business.
• Knowledge of relational databases concepts, and the creation of queries and reports using SQL or reporting tools (i.e., Oracle, Tableau).
• Understanding of data elements as they relate to data quality requirements.
• Strong interpersonal, presentation, verbal, written and communication skills.
• Understanding of statistical concepts with an ability to apply to reporting.
• BS in Finance, Math, Engineering, or equivalent experience in complex problem solving.
• Experience with Microsoft SQL, Oracle, Tableau, Hadoop & Hive.
• Proven record of building and maintaining effective business relationships.
• Demonstrated ability to matrix manage in a large cross-functional organization.
• Familiar with cable operations, video, HSD, etc.