Job Description

Department: Development Location: Pune, India Description ParentPay Group is Europe's leading software product company and the UK's largest education technology business We are on a mission to bring next-generation innovation to positively impact on the lives of millions of parents, teachers, and students every day in over 49 countries Our market leading products use cutting edge cloud-based technology to streamline school processes, including secure web and mobile apps that enable secure online payments for school items such as meals, trips, clubs and uniform, improve parental engagement, simplify meal management and through our product SIMS collect and manage a database of student information and core school operations ParentPay Group's new offices in Pune are a fantastic tech hub for those looking to boost their careers in software product development Our bright team FastTrack their career with international exposure and ways of working based on agile development best practices from globally renowned technology consultancies Key Responsibilities As a Lead Business intelligence Report Developer for the ParentPay Group, you will be responsible for the production of automated Power BI reporting from our Group Data Warehouse You will collaborate with stakeholders at all levels of the business, transforming their requirements into insightful reports and dashboards Working with all teams across the business, your focus will be: Build insightful automated Power BI reports, dashboards and datasets to meet business requirements Identify any gaps in our current reporting suite and advise on solutions Responsible for Technical leadership, Architectural design, Non-functional requirements Mentoring of junior engineers To succeed in this role, you will have an analytical and logical mindset, have excellent attention to detail and quality, be comfortable working with large amounts of data from various sources and be able to interpret data and help the business understand the numbers You will be proficient in writing SQL queries, often complex queries combining data from numerous data sources located on multiple on premise SQL servers You will also have advanced knowledge of working with Power BI Key Responsibilities Ongoing review and maintenance of the existing BI suite of automated reports and processes End to end development of BI Solutions from initial discussions with stakeholders to the deployment of an automated solution, using SQL and Power BI Ensuring consistency and accuracy across all BI Reports Regular communication with internal stakeholders, ensuring they are supported and have the data required for their business area Fulfilling all ad hoc data requests Supporting internal projects where necessary Skills, Knowledge and Expertise Degree in relevant field or 8+ years working in a report developer role Proficient in writing complex SQL queries, Linked Server queries, creating Stored Procedures, Functions and Agent Jobs Proficient in data modelling concepts Advanced knowledge of Power BI Advanced knowledge of Power BI Report Builder Experience working with multiple data sources, able to transform, combine and aggregate data into a single repository Outstanding written, verbal, and interpersonal skills A keen eye for detail and aptitude for working with data Highly accurate and thorough in all tasks Exceptional organisational and presentation skills Highly organised and able to prioritise tasks Strong problem-solving skills and an analytical mind Experience working with cross functional teams desirable Experience in the schools/education marketplace (3+ years) desirable