Okay, I've searched for ERP Data Analytics and Reporting roles in Philadelphia that require 3-5 years of experience and skills in SQL or Python. Additionally, these positions are on-site and offer a salary of at least $90,000. I have found 42 positions that match your criteria.

Sure. Here's the analysis:

Job Analysis:

The ERP Data Analytics and Reporting Analyst role is fundamentally designed to enhance the City of Philadelphia's operational efficiency through data-driven insights and robust reporting mechanisms during the OPAL ERP and DW/BI project. The analyst will be tasked with analyzing reporting and analytics requirements, collaborating with cross-functional teams, and actively engaging in system design and testing phases. This position necessitates not only a technical aptitude for data reporting tools and programming languages like SQL, R, or Python but also strong soft skills for communication and collaboration. Success in this role involves delivering accurate and meaningful reports that drive decision-making and improve business processes across finance, grants, and procurement. The expected challenges include navigating the complexities of ERP implementation, ensuring user requirements are met, and optimizing data workflows amidst evolving project dynamics. A successful analyst will effectively translate user needs into functional specifications and provide ongoing support post-implementation while embracing a culture of continuous improvement.

Company Analysis:

The City of Philadelphia stands as a significant employer in the region with a diverse workforce and a commitment to serving its residents. Operating in a public service environment, the City prioritizes integrity, service, and accountability, which impacts the work culture significantly. A strong emphasis on collaboration and inclusion signifies a welcoming environment for individuals from various backgrounds. This role is nested within the Office of Innovation & Technology, underscoring its strategic importance in modernizing the City’s technological backbone. Given the initiative's goal to optimize financial and procurement processes, the ERP Data Analytics and Reporting Analyst will have high visibility within the organization, particularly as this project has direct implications for the City’s efficiency and service delivery. The role reflects broader plans for growth and innovation within Philadelphia, suggesting that this position is not merely about maintaining systems but about facilitating essential changes that will enhance the City’s operations and responsiveness to community needs.

Absolutely. Here are some mock interview questions that could come up:

• Behavioral Questions:
• 1. Tell me about a time when you had to manage conflicting priorities in your workload. How did you approach this situation?
• 2. Can you describe a project where you successfully implemented a data reporting solution? What challenges did you face?
• 3. Discuss an instance where you collaborated with a diverse team to achieve a common goal. What was your role?
• 4. Describe a time when you had to present complex information to non-technical stakeholders. How did you ensure clarity?
• Technical/Role-Specific Questions:
• 1. What methods do you typically use to gather analytics requirements from users?
• 2. How would you approach optimizing a data workflow for an ERP system?
• 3. Can you walk us through your experience with SQL and how you have applied it in past projects?
• 4. What strategies would you employ to ensure data confidentiality during the reporting process?
• Situational Questions:
• 1. Imagine you’re tasked with developing a report that has conflicting user requirements. How would you resolve this?
• 2. You notice that the reporting tool you are using is not meeting the performance standards expected. What steps would you take?
• Company Fit/Motivation Questions:
• 1. What interests you about working for the City of Philadelphia in this specific role?
• 2. How do you see your values aligning with the City’s commitment to integrity and accountability?
• 3. In your opinion, how can data analytics improve the efficiency of public services?
• Questions for the Candidate to Ask the Interviewer:
• 1. Can you describe the types of projects the team is involved in beyond the OPAL ERP project?
• 2. What opportunities for professional development and growth exist within the Office of Innovation & Technology?
• 3. How does the City of Philadelphia measure the success of its IT initiatives?