GSS Data Analyst

About The Role

As a GSS Data Analyst you will prepare data to be used by the Business Reporting & Analytics (BR&A) team across multiple areas of reporting. You will gather requirements from stakeholders and complete data transformation according to those requirements. You will report to the Manager, SQL & Data Manager and be located at our Cranberry Township, PA location. Hybrid Work Schedule.

Key Responsibilities

• Build robust data pipelines to support the gathering and transformation of data to be used by the BR&A and APX Project Management Office teams
• Support the APX Project Management Office by meeting with stakeholders and developing analytical processes to support Business Intelligence reporting
• Develop advanced queries to provide valuable data insight for the business
• Create and maintain data models in an efficient manner, maximizing the use of our data and our tools
• Develop automated programs for extracting, transforming, and loading data
• Assist in the administration of a central data lake to be used by the BR&A team
• Perform research and provide suggestions on technologies that could be used to boost the overall productivity of the BR&A team
• Protect the integrity of BR&A reporting data by continually monitoring for data cleanliness and quickly identifying and resolving issues

Qualifications

• B.A., B.S. or equivalent business experience
• 3+ years experience in a similar role
• Knowledge of financial processes, controls, and associated improvement programs
• Familiarity with systems and data quality processes
• Knowledge of relational databases
• Proficient in SQL, Python, R, Java, or any similar programming language
• Background knowledge of Databricks
• Proficiency in Power Platform (Power Automate, Power BI, Power Query)

Pay

The base salary range for this position, which is dependent upon experience, qualifications and skills, is estimated to be $64,800 to $81,000 per year.

Benefits

• Comprehensive Medical benefits which could include medical, dental, vision, prescription coverage and Health Savings Account (HSA) with employer contributions options
• Wellness Programs designed to support employees in maintaining their health and well-being including Employee Assistance Program providing support for our employees and their household members
• 401(k) with Company Match Contributions to support employees' retirement
• Paid Vacations and Company Holidays
• Opportunities for Flexible Work Arrangements to promote work-life balance
• Educational Reimbursement and Comprehensive Career Programs to help employees grow in their careers
• Global Recognition and Service Programs to celebrate employee accomplishments and service
• Employee Referral Program