Senior Application Specialist I
Senior Application Specialist I
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Overview
The Professional Services team plans guides and delivers client projects all with the aim to meet timeline and budget expectations and achieve organizational goals. This is a Customerfacing project implementation role. Candidate must have required skills and experience for defining and performing complex integration development work in addition to strong communication and organizational leadership skills to act as the overall Tech Lead for assigned projects.
Team Overview
The Services team works closely together to set PowerSchool customers up for ongoing success through postimplementation support troubleshooting consultation on system setup options and training on features and functionality. The team offers crossportfolio support all while meeting organizational objectives for revenue utilization and customer satisfaction.
Responsibilities
Your daytoday job will consist of:
- Implement ETL processes that populate a data warehouse using star schemas from a variety of data sources
- Design and develop SQL Server stored procedures functions views and triggers to be used during the ETL process
- Design and develop Snowflake customizations within the product framework
- Participates in the requirements gathering process and assists with designing the business process dimensional models
- Work with data providers to fill data gaps and/or to adjust sourcesystem data structures to facilitate analysis and integration with other company data
- Perform data profiling and source to target mappings
- Perform analysis on source data to determine the feasibility of using this data to solve business needs
- Write scripts for automated testing of data in the target facts and dimensions
- Capture audit information during all phases of the ETL process
- Write and maintain documentation of the ETL processes via process flow diagrams
- Act as the customerfacing PowerSchool technical lead for assigned projects. Provide PowerSchool technical solution expertise and guidance for assigned projects and customers and lead and coordinate the delivery of technical integrations customizations data validation and system QA together with other assigned PowerSchool team members
Qualifications
Minimum Qualifications
- Bachelors Degree in Computer Science or STEM majors or equivalent years of equivalent work experience
- 5 years of professional experience in a similar scope role
- Excellent verbal and written communication skills
- Experience with relational database design/modeling
- Experience interfacing with business users and gathering and understanding their requirements
- SQL coding/querying skills in SQL Server and/or MySQL Oracle Postgres SnowFlake
- Experience in an Agile environment
EEO Commitment
EEO Commitment
PowerSchool celebrates a diverse and inclusive workplace. PowerSchool is an equal opportunity employer and does not discriminate on the basis of race national origin gender gender identity sexual orientation protected veteran status disability age or other legally protected status. Our inclusive culture empowers PowerSchoolers to deliver the best results for our customers. We not only celebrate the diversity of our workforce we celebrate the diverse ways we work. If you have a disability and need an accommodation regarding our recruiting process please let us know by emailing
#LIPR1
Required Experience:
Senior IC
Employment Type
Full-Time
