Your Recently Viewed Jobs

SQL Systems Specialist - Billing

SQL Systems Specialist - Billing| Information-technology | Lake Mary, FL, USA

Send to a Friend Print


Responsibilities

At Verizon, we innovate constantly to help the biggest names in business do business – quicker and smarter. It takes vision. It takes focus. And we apply both every bit as much to the way we do business too. The brightest minds, the latest technologies and pioneering processes are combining to enhance this critical business function at our Center for Excellence. We’re finding new ways to add value and provide strategic support. This is the kind of work we do. And you can be part of it.

This is a strategic reporting and analytical support role in the Verizon Bill To Cash organization, responsible for providing analytical insights to leadership for operational and strategic decision making.  Responsibilities will include using data analysis and data mining expertise to support various projects and ad-hoc reporting requests and using technical skills to develop reports and  automation via SQL coding and Business Intelligence tools.

  • Support ad-hoc analytical needs serving operations and strategy.  Work with stakeholders to obtain a greater understanding of the needs of the business and the types of analysis that supports business goals.
  • Develop custom reporting via SQL (Teradata, Oracle, and T-SQL) and various BI tools (Cognos, Tableau, OBIEE, etc.) to provide valuable information to stakeholders and leadership.  Add value to requests from business leaders and build reporting logic that will produce analytical measures to tell the story of what is happening in the business.  This requires a strong understanding of business processes and data flows.
  • Utilize advanced data mining and SQL skills to evaluate and critically inspect financial and operational results.
  • Provide direction on metrics and quantifying the savings and/or costs of various initiatives.
  • Assist in development of standard metrics and reporting methodologies for fraud team.  Requires understanding of metrics used by various business units to stay in line with overall company direction.   Participate in user groups geared towards reporting standardization. 
  • Determine and write reporting requirements for development of standard data sets that will be used for data analysis, data mining, and ETL.  Work with peers to implement solutions.
  • Ensure data integrity.  Develop and maintain appropriate control processes to ensure the accuracy of datasets.  Define the appropriate steps needed to validate various data feeds to and from the organization, ensure consistency of results, and troubleshooting issues as they arise.   Identify and recommend appropriate process owners to ensure ongoing integrity of data, partner with other reporting contacts to ensure consistent methodologies and adherence to standardization.  Participate in code reviews with team members.
  • Ensure reporting process efficiency.  Identify and implement efficiency improvements in recurring reporting while maintaining the accuracy and integrity of the data.  
  • Maintain reporting relevance to add value to the business.  Identify reporting enhancement opportunities, documenting suggested resolution, and updating code as agreed upon by users.
  • Develop business cases to support changes in the business.
  • Work with IT and other business partners to address reporting concerns and ensure data integrity and availability to meet SLAs.
  • Participate in cross-functional project teams as reporting subject matter expert to identify critical reporting requirements.
  • Develop self service reporting functionality following an Information Management strategy of agreed upon terms, data stewards, etc.


Qualifications
  • Bachelor’s Degree in Finance, Mathematics, Statistics, related field, or equivalent experience required
  • 3+ years development experience with Business Intelligence tools 
  • 3+ years experience in a reporting and analysis role with strong quantitative and analytical skills and a proven track record of turning large amounts of multi-faceted data into meaningful information required
  • 3+ years experience writing SQL against large Teradata, SQL Server, and/or Oracle datasets to generate reporting required
  • Strong mathematical, analytical, financial background and attention to detail required
  • Advanced knowledge of MS Excel and PowerPoint for data manipulation and report creation required
  • Previous use of Business Intelligence tools, such as Cognos, SSRS, Business Objects, Tableau, Hyperion or others, required
  • Previous use of ETL tools, such as SSIS, Informatica or others, required
  • Previous experience developing and writing reporting requirements for creation of reporting solutions, such as fact tables, cubes or dashboards
  • Strong understanding of star/snowflake schema preferred
  • Experience in Cognos Framework Manager (both Query/DMR), Report Studio, and Analysis Studio preferred
  • Proficiency in key financial systems, such as Hyperion Essbase and Peoplesoft, a plus
  • Experience in business case development and analysis preferred
  • Ability to effectively communicate in both written and verbal formats
  • Demonstrated ability to work independently and as part of a team in a dynamic and fast-paced environment
  • Stronng ability to manage multiple projects simultaneously, adapt to changing priorities and meet aggressive deadlines

Our business is fuelled by our passion for delivering unprecedented results for customers in over 52 countries. Throughout the world, we’re helping to create a better future – transforming how doctors battle cancer, rescue workers save lives, and people, businesses and communities interact with one another. If you have the drive, talent, energy and commitment to join over 180,000 like-minded people who are unlocking this positive potential of technology, we’ll support you every step of the way. Whether that’s through competitive compensation, award-winning training, or benefits so comprehensive we call them Total Rewards.

Start creating powerful answers today. 

 



Equal Employment Opportunity

Verizon is an equal opportunity and affirmative action employer M/F/Disability/Vet



  • Verizon is a Federal Contractor
  • Verizon requests veteran priority referrals
  • Verizon is an equal opportunity and affirmative action employer M/F/Disability/Vet.




Job ID: 343964