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 Customer-facing 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 OverviewThe Services team works closely together to set PowerSchool customers up for ongoing success through post-implementation support, troubleshooting, consultation on system setup options, and training on features and functionality. The team offers cross-portfolio support, all while meeting organizational objectives for revenue, utilization, and customer satisfaction.
ResponsibilitiesYour day-to-day job will consist of:
Implement ETL processes that populate a data warehouse using star schemas from a variety of data sourcesDesign and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL processDesign and develop Snowflake customizations within the product frameworkParticipates in the requirements gathering process and assists with designing the business process dimensional modelsWork with data providers to fill data gaps and/or to adjust source-system data structures to facilitate analysis and integration with other company dataPerform data profiling and source to target mappingsPerform analysis on source data to determine the feasibility of using this data to solve business needsWrite scripts for automated testing of data in the target facts and dimensionsCapture audit information during all phases of the ETL processWrite and maintain documentation of the ETL processes via process flow diagramsAct as the customer-facing 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 QualificationsBachelor’s Degree in Computer Science or STEM majors, or equivalent years of equivalent work experience5+ years of professional experience in a similar scope roleExcellent verbal and written communication skillsExperience with relational database design/modelingExperience interfacing with business users and gathering and understanding their requirementsSQL coding/querying skills in SQL Server and/or MySQL, Oracle, Postgres, SnowFlakeExperience in an Agile environment EEO Commitment EEO CommitmentPowerSchool 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 accomodations@powerschool.com.
#LI-PR1
Software Powered by iCIMS
www.icims.com