Reporting analyst jobs in Lower Makefield, PA - 582 jobs
All
Reporting Analyst
Data Analyst
Data And Reporting Analyst
Asset Management Analyst
Project Analyst
Operations Analyst
Data Analyst
Old Republic Specialty Insurance Underwriters 4.5
Reporting analyst job in Yardley, PA
Title: Data Analyst - Actuarial Support
Reports To: VP, Actuary
Department: Actuary
Classification: Full-Time/Exempt
Who We Are:
Old Republic is a leading specialty insurer that operates diverse property & casualty and title insurance companies. Founded in 1923 and a member of the Fortune 500, we are a leader in underwriting and risk management services for business partners across the United States and Canada. Our specialized operating companies are experts in their fields, enabling us to provide tailored solutions that set us apart.
Old Republic Specialty Insurance Underwriters (ORSIU) is part of Old Republic International Corporation. We offer insurance and reinsurance spanning most lines of business, and partner with specialists who are committed to providing the highest levels of service with the products necessary to meet the unique needs of the Alternative Risks, Specialty Programs and Excess Casualty marketplace.
Position Overview:
The Data Analyst will assist the actuarial department by gathering, analyzing, and interpreting relevant data sources in support of pricing, reserving, filing, reporting, and other business needs. Note that this role is not a part of the actuarial exam program.
Essential Job Functions:
Collaborate with cross functional teams to improve data and automate reports where appropriate.
Use analytics to spot trends, dependencies, and patterns.
Acquiring and compiling structured and unstructured data while verifying its quality, accuracy, and reasonableness.
Support actuarial department in responding to corporate/regulatory requests (state data calls, etc.), from determining requirements to data preparation to final exhibit creation.
Align with operations team as part of ongoing system development/enhancements while enhancing data availability within the organization.
Qualifications:
Degree in Business, Computer Science or another related field.
A minimum 2 years of P/C insurance experience is preferred.
Strong analytical and problem-solving skills as well as solid oral and written communication skills
Technical expertise in Microsoft Excel required; experience with Access, SQL, VBA, or other programming languages.
ORI is an Equal Opportunity Employer. ORI provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
$67k-81k yearly est. 5d ago
Looking for a job?
Let Zippia find it for you.
Data Analyst
Robert Half 4.5
Reporting analyst job in Philadelphia, PA
We are seeking a detail-oriented Data Quality Operations Analyst to support a high-visibility initiative focused on improving data accuracy and optimizing data processes. This role plays a critical part in ensuring the integrity of contract, pricing, and program data within enterprise systems. The ideal candidate has strong data entry skills, exceptional attention to detail, and the ability to work independently in a fast-paced environment. Experience in the insurance industry is a plus but not required.
Key Responsibilities
Review, validate, and reconcile contract and pricing information against system data to ensure completeness and accuracy
Perform accurate data entry and updates within certain enterprise systems
Identify, research, and resolve data discrepancies and inconsistencies
Collaborate with account owners and certain team members to obtain missing information and clarify program structures
Liaise with technology teams to support data-related inquiries and script preparation as needed
Document findings, corrections, and updates in a clear, organized, and auditable manner
Maintain high data quality standards while meeting project deadlines
Required Qualifications
Exceptional attention to detail with strong organizational and time-management skills
Ability to maintain data accuracy and quality in a deadline-driven environment
Experience navigating and updating information within enterprise systems or web-based portals
Proficiency in Microsoft Office, particularly Excel
Strong written and verbal communication skills
Proven problem-solving ability and capability to work independently
Preferred Qualifications
Familiarity with property and casualty insurance, claims processes, or insurance terminology
Prior experience in data quality, data operations, or data validation roles
$54k-83k yearly est. 4d ago
Asset Management Analyst
Preit 4.0
Reporting analyst job in Philadelphia, PA
Company
Headquartered in Philadelphia, PREIT is a premier owner, developer, and operator of high-quality retail and mixed-use destinations across densely populated U.S. markets. Founded in 1960, the company has a storied history of transforming traditional shopping centers into vibrant, community-centric hubs that bring together shopping, dining, entertainment, and lifestyle experiences. Today, PREIT continues to redefine the future of retail by leveraging its portfolio's prime locations to deliver dynamic, multi-generational destinations.
Responsibilities
This position will support the Regional Asset Manager as it relates to company strategy and goals. This includes, but is not limited to, budgeting & forecasting, leasing analysis, deal execution, due diligence, analysis, and other projects that align with PREIT objectives such as transactions, refinancing, and development.
Essential Functions
Supports leadership in PREIT portfolio lease execution.
Create and update annual property budgets and creating forecasting models for region in Argus and Excel.
Develop pro formas and projections for leasing representatives to help them in negotiating transactions.
Develop and track pro formas for redevelopment projects.
Work closely with property management and accounting staff in coordinating collection efforts and responding to various tenant inquiries relating to co-tenancy, CAM audits and various other lease clauses.
Build and maintain quarterly covenant calculations for term reporting.
Participate in Regional Production meetings and ensure action items are addressed in a timely manner.
Monitor performance of the property and identifying operations and challenges and implement strategies to respond.
Review lease comments and work with Leasing Representatives to evaluate the impact of proposed changes and Landlord's risk and develop the appropriate responses to tenants.
Prepare financial projections for the properties and portfolio, and for properties under consideration for development.
Carry out special assignments/projects as assigned by management.
Assist team in acquisition, disposition, and refinance initiatives.
Qualifications
Bachelor's degree in Accounting, Finance, Real Estate, Business Management, or related field required. Master's Degree highly desirable.
1 - 5 years of experience in commercial real estate, financial analysis and/or contract and real estate law. A combination of equivalent education and experience necessary to effectively perform the responsibilities of the position.
Strong interpersonal skills; comfortable working with all levels of management, leadership, ownership, joint venture partners and external advisors.
Excellent written and verbal communication skills
Detail orientation demonstrated ability to multitask effectively, and strong analytical skills.
Competency in the use of Microsoft Office suite including Excel and PowerPoint. Experience using ARGUS or Yardi a plus.
Ability to work in Center City, Philadelphia office 4 days per week.
Benefits
401(k)
Health insurance
$66k-81k yearly est. 1d ago
FMC Data Analyst Co-Op-1
FMC Corporation 4.9
Reporting analyst job in Philadelphia, PA
FMC Corporation is a global leader in agricultural sciences, driven by our purpose: Innovation for Agriculture. Solutions for the Planet. We are passionate about the power of science to solve agriculture's biggest challenges. With one of the most productive and diversified pipelines in the industry, FMC is delivering cutting-edge and next-generation crop protection technologies - including Dodhylex™ active, Isoflex™ active, rimisoxafen, and fluindapyr - to help farmers increase the productivity and resilience of their land. Our employees are at the heart of this innovation. We're looking for bold thinkers and collaborative doers. At FMC, your ideas matter. From day one, you'll contribute to meaningful work that drives progress in agriculture, supported by a culture that values integrity, safety, respect, and results. Join us in advancing the future of agriculture. Together, we're building a more resilient planet - one innovation at a time.
We are seeking a motivated Data Analyst Intern to join our growing team. In this role, you will collaborate on defining business requirements, designing technical solutions, performing data transformation, and creating analytics visualization (e.g., Power BI dashboards) and charts to tell comprehensive
data stories that inform and enhance business leaders' ability to drive value. This is an exceptional opportunity to gain hands-on experience in enterprise-level data analysis while contributing to meaningful projects and business decisions.
FMC is an equal opportunity employer. We are committed to creating a diverse and inclusive workplace where all individuals are treated with respect and dignity. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other legally protected status. Employment decisions at FMC are based on business needs, job requirements, and individual qualifications. We value diversity and strive to ensure that our hiring and employment practices support a work environment that is free from discrimination and harassment.
$70k-93k yearly est. Auto-Apply 60d+ ago
Data Analyst
Artech Information System 4.8
Reporting analyst job in Philadelphia, PA
Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.
Job Description
The Software Data Analyst will be joining the Team, builder of an enterprise-wide cloud-based software platform providing the core content navigation and discovery services,customer facing web, mobile, and set top box applications.
These services include content metadata management, data quality, search, browse, recommendations, customer entitlements, customer identity and authentication, personalization and voice recognition/control.
The Software Engineer will specifically be joining the triage group to field issues involving content from a customer perspective and internal teams. T
They will ensure data is accurate and either resolve or escalate any issues.
1) The main thing is finding a resource who is passionate about technology and likes to learn.
2) Any experience with "data" is preferred - quality, analysis, scrubbing, finding defects, trends, etc.
3) Problem solving ability is key - their thought process on how they think through a problem.
4) Analytical skills - like to figure out how stuff works, reverse engineering, or just a plain old "figure it out" attitude.
Job Details:
• Supports triage of code defects and cross-team evaluation of current trends in process deficiencies
• Work with developers to ensure issues are escalated to the correct teams for resolving
• Troubleshooting data issues related to on-screen content
• Finding the root-cause of issues through internal teams that affect customer applications
• Improving overall customer experience
Qualifications
Required Skills:
(3-5 years)
• SQL knowledge is a plus
• Basic UNIX or Linux skills - understanding command line are a plus
• Excellent communication and problem solving skills
• Experience in a production support environment preferred
• Basic scripting - Python, Perl, or PHP experience is preferred
•Communication, Problem Solving, Data Querying
•Production Support experience is a plus, however really what client need is a bright person who can intelligently / efficiently speak the language of both the end user and the developer.
Additional Information
For More information, Contact:
Siva Kumar
************
****************************
$66k-92k yearly est. Easy Apply 60d+ ago
Systems Data Coordinator
Robbinsville Public Schools
Reporting analyst job in Robbinsville, NJ
Technology/Systems Data Coordinator Additional Information: Show/Hide Robbinsville School District Vacancy Robbinsville Public Schools is a high-performing (PreK - 12) school district located in Mercer County, New Jersey. We educate about 3,100 students in three (3) schools (elementary, middle, and high school).
The following position is anticipated: Systems Data Coordinator
Anticipated Start Date: 01/20/2026
Application Deadline: 01/09/26 or until filled
Requirements: Please see attached job description for qualifications and responsibilities
Salary: $90k to $110k; Commensurate with experience
Benefits: Full-time staff are eligible for Medical, Prescription, and Dental Benefits. Sick, personal, vacation, holiday and bereavement days are included.
Application Procedure:
Applications are being accepted on-line through Applitrack until the position is filled.
**********************************************************************
Robbinsville Public Schools is an Equal Opportunity / Affirmative Action Employer, and all qualified applicants are encouraged to apply.
Attachment(s):
* Systems Data Coordinator (4).pdf
$90k-110k yearly 19d ago
Data Analyst
Mindlance 4.6
Reporting analyst job in Piscataway, NJ
Mindlance is a national recruiting company which partners with many of the leading employers in the Life Sciences, IT, and Financial Services sectors, feel free to check us out at *************************
Job Description
JOB TITLE:- Data Analyst - I/ Contracts Analyst/ Medicaid Analysty
LOCATION:- Piscataway, NJ 08854
DURATION:- 9-10+ months
Local / W2 candidates only
JOB OVERVIEW
• Pharmaceutical Health Care Systems Inc. (JJHCS) a member of Pharmaceutical's Family of Companies is currently recruiting for a Medicaid Analyst, Government Rebate Operations located in Piscataway, NJ. JJHCS provides customer support services to key health care customers, including hospital systems and group purchasing organizations, leading health plans, pharmacy benefit managers, and government health care institutions.
• The company also provides contract management, logistics and supply chain functions for the major Pharmaceutical franchises.
• The Analyst, Government Rebate Operations will report to the Sr. Manager, Medicaid Operations and will oversee the critical operational aspects of Medicaid Payments
• The Analyst will serve as a subject matter expert in relation to state processing and is required to stay fully informed of any new regulatory or Government rule changes as it relates to States and Medicaid.
• They will partner with State and/or PBA agencies in order to efficiently & accurately process multiple types of invoices; including but not limited to State Medicaid, State Pharmaceutical Assistance Programs (SPAP), State Supplemental, ADAP and Managed Medicaid across nine Pharmaceutical companies, over 285 products and 50 States & DC.
• This would include analyzing any State resubmissions and price changes from Pharmaceutical companies Responsibilities will include detailed data validation and reporting, creation and maintenance of supporting documentation, including SOPs and Work Instructions.
• The Analyst, will also be responsible for generating, developing, analyzing and processing monthly and quarterly Medicaid & State reports on behalf of the Pharmaceutical Operating Companies utlizing multiple data sources.
• This may also include creating and analyzing adhoc reports using as needed. In addition, the Analyst will be responsible for managing various business activities supporting the overall GRO team, including compliance audits and supporting various contract-related activities as required. Experience with CARS/Medicaid, CCRA, Cognos, TRIM and market survey databases (IMS, Data Niche is preferred. Ability to work with large amount of data is required.
• Advance knowledge in Microsoft Office (Excel, Word and Outlook) is required. Ability to work independently and as part of a team is required.
• Knowledge of, SOP's (Standard Operating Procedure) and Work Instructions process is required. Ability to handle multiple priorities simultaneously, with strong attention to detail, while meeting strict deadlines is required.
• Being able to understand and respond to customer (both internal and external) requests in a timely manner is required. Strong interpersonal and communication skills are required.
• Ability to create new ways of performing tasks efficiently and effectively as a result of workflow analysis is highly desired.
Qualifications:
• A minimum of a Bachelor's/College degree required.
• Experience in Medicaid, Rebate Management, and compliance is highly preferred. Knowledge and understanding of product, industry trends and contracting processes is preferred.
• Strong analytical and time management skills are required.
• Having strong verbal & written communication skills and being able to communicate across all levels of the business is required.
• Qualified candidates must be willing and able to work in Piscataway, NJ since the position is located in Piscataway and is not eligible for relocation
Thanks in advance for your time and consideration, please call me on ************ or feel free to provide a current version of your resume. I look forward to hearing from you !!!!
Qualifications
Bachelors/College Degree Required
Additional Information
Thanks and Regards,
Shakeb Usmani | Team-Recruitment | Mindlance, Inc. | Office: ************
$70k-92k yearly est. 60d+ ago
Data Analyst
Ra 3.1
Reporting analyst job in Princeton, NJ
About Client: They are an equal opportunity employer and with value diversity at their company. They do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
Job Description:
As a healthcare consultant, you will be working independently on individual projects followed by handling an excellent relationship with the client. On the whole your going to be a passionate player in using statistical tools and positive attitude.
We are looking for a person who is too awesome, who loves the role and works with a lot of passion. We are awaiting to meet the excellent analytic specialist exactly like you.
We would love to listen to your career success and will anticipate for your interest towards this job and I believe:
You are powerful in data science, business reporting, and statistical analysis.
You are proficient in Business Intelligence and Reporting.
You are an expertise with R, SAS, SPSS.
You have worked in Healthcare.
You are amazing in using Predictive Modeling and advanced statistical techniques.
You are excellent in Data Visualization.
You are good in using Cognos and Business Objects.
You will be reporting to the Senior Consultant.
About our client:
They are an equal opportunity employer and with value diversity at their company. They do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
Additional Information
All your information will be kept confidential according to EEO guidelines.
$69k-105k yearly est. 16h ago
Data Analyst in Big Data
SRP Systems 4.3
Reporting analyst job in Princeton, NJ
SRP is a big data startup company located in Princeton, NJ focused on Dynamic Pricing, run by seasoned alumni from Stanford University and Wharton.
Job Description
We are looking for a big data analyst that can generate clear and insightful analyses on the data at hand.
Must have data mining skills (data aggregation, validation, etc), advanced modeling techniques, creating explanatory reports.
RESPONSIBILITIES:
Big data analyst should have a broad understanding and have experience with real-time analytics and business intelligent platforms
Ability to understand the meaning and use of the data, as well as analyze the data quality
Perform duties such as collecting, parsing, tagging, analyzing, mapping, managing, and visualizing large sets of data
Must have experience in using Python or similar language for conducting data manipulation and data analysis
Qualifications
Masters in Computer Science or equivalent
Additional Information
All your information will be kept confidential according to EEO guidelines.
$69k-98k yearly est. 60d+ ago
Temporary Contracts Data Analyst
IEEE 4.9
Reporting analyst job in Piscataway, NJ
The Temporary Contracts Data Analyst will play a key role in supporting IEEE's Conferences, Events, and Experiences (CEE) department through detailed contract data analysis and accurate, compliant payment processing. This highly collaborative role works closely with both the Contracts and Finance teams to ensure that all contractual commitments and financial obligations are accurately captured, tracked, and fulfilled on time.
The ideal candidate will combine strong analytical skills with exceptional attention to detail and a deep commitment to accuracy and compliance. This position is integral to ensuring that all executed contracts and associated payments align with IEEE policies, financial standards, and tax regulations.
The role reports to the Senior Manager, Event Vendor Management & Contracting, and does not manage direct reports. This position works under minimal supervision.
Key Responsibilities
* Review and analyze executed hotel contracts within IEEE's centralized contract management system (CMS).
* Identify, extract, and record key data points, including (but not limited to):
* Room block details (dates, quantities, rates, review/release dates)
* Food & Beverage minimums and review dates
* Deposit schedules, payment terms, and due dates
* Cancellation and attrition clauses, including tiered penalties and timelines
* Concessions, rebates, commissions, and other negotiated financial terms
* Special commitments, hotel obligations, or planner responsibilities
* Enter all collected information into standardized tracking templates or internal reporting tools.
* Flag missing, inconsistent, or ambiguous data for internal review and clarification.
* Summarize relevant contract details to provide visibility for internal teams and conference organizers.
* Partner with the Contracts team to ensure all commitments and deliverables are accurately reflected in tracking systems and communicated to stakeholders.
* Collaborate closely with the Finance team to process and reconcile payments tied to executed agreements, ensuring that all disbursements align with contract terms and are fully supported by proper documentation.
* Review and validate payment requests for vendors, speakers, and other payees to confirm accuracy, compliance, and proper authorization.
* Maintain organized records of all contractual and payment data to support timely reporting and clear audit trails.
* Proactively communicate with conference organizers and internal teams regarding payment status, missing documentation, or contract fulfillment requirements.
* Support continuous improvement by identifying process gaps and recommending efficiencies in contract tracking and payment workflows.
Qualifications - Education
* Bachelor's degree or equivalent experience
Work Experience
* 2-4 years' experience preferred with contract negotiation and document review in a procurement capacity
* 2-4 years' experience in a data analytics role
Skills and Requirements
*
* Prior experience reviewing contracts or working with contract data strongly preferred.
* Strong attention to detail and accuracy in data entry and analysis.
* Excellent organizational and communication skills.
* Proficient in Microsoft Excel, Word, and data tracking systems
* Ability to work independently and manage multiple tasks in a fast-paced environment.
* Excellent communication skills (verbal/written), time and project management skills, dedication to detail and the ability to work under pressure in a deadline driven environment.
* Positive attitude and a supportive, team-based approach towards the attainment of departmental goals.
* Must have the ability to represent the IEEE in a professional manner
*
$66k-85k yearly est. 41d ago
Enterprise Resource Planning (ERP) Data Analytics and Reporting Analyst
Philadelphia International Airport
Reporting analyst job in Philadelphia, PA
The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer (CIO). OIT oversees all major information and communications technology initiatives for the City of Philadelphia - increasing the effectiveness of the information technology infrastructure, where the services provided are advanced, optimized, and responsive to the needs of the City of Philadelphia's businesses, residents, and visitors. OIT responsibilities include: identifying the most effective approach for implementing new information technology directions throughout city government; improving the value of the city's technology assets and the return on the city's technology investments; ensuring data security continuity; planning for continuing operations in the event of disruption of information technology or communications services; and supporting accountable, efficient and effective government across every city department, board, commission and agency.
In partnership with the Office of the Chief Administrative Officer (CAO) and the Office of the Director of Finance, the Office of Innovation and Technology (OIT) is undertaking a major Citywide project to modernize core financial, grants, procurement, and supply chain business processes. This project (Optimize Procurement and Accounting Logistics Enterprise Resource Planning and Data Warehouse/Business Intelligence Tool, or "OPAL ERP and DW/BI project") will replace the existing General Ledger and Procurement systems (i.e. FAMIS, ADPICS, ACIS, PHLContracts, etc.) that support these business processes and will enable the City to realize benefits such as reducing transaction processing time and effort, providing better access to information for reporting and analysis, and making it easier to onboard new employees into these functions.
Job Description
The Enterprise Resource Planning (ERP) Data Analytics and ReportingAnalyst is responsible for day-to-day interactions with the project team and managing the development and implementation of assigned reports and related responsibilities. This is a permanent exempt position that will move to maintenance and support after the project is complete (in 3-4 years).
Essential Functions:
During implementation:
* Gather and document the requirements for ERP data and reports.
* Prepare and test the reporting configurations to validate the design setup.
* Create and deploy the business process and systems user procedures.
* Write/update technical specifications.
* Create new reports and retrofit existing reports.
* Meet delivery schedule.
* Execute and document unit test cases.
* Provide weekly tasks and reports to development leads.
Post Implementation:
* Identify, resolve, and report on ERP data and reporting issues and document enhancements requests.
* Analyze, define, and design new release reporting functionality to determine relevance to meet the current or new business processes & requirements.
* Document the business process revisions and application configuration training content.
* Create and deploy new process,s and systems changes to the end users.
* Participate in regression testing efforts.
* Look for opportunities to optimize the business reporting such as new processes to meet future requirements or leverage delivered systems functionality and technology.
* Participate in break fix and regression testing efforts.
Qualifications
* Completion of a Bachelor's or Master's degree in information systems, computer engineering, or a related field or equivalent experience;
* 3-5 years of experience with ERP systems, 3rd Party Applications and related reports development and deployment.
* Experience with implementing ERP and/or DW/BI solutions strongly preferred
Competencies, Knowledge, Skills and Abilities
* Experience with Finance and Grants / Supply Chain (SCM) and Procurement business intelligence (BI)/ data warehouse (DW) applications and report generation packages.
* Experience with query development, writing and implementation.
* Strong problem solving and analytic skillsets.
* Strong verbal and written communication skills with ability to create user and project security documentation and procedures, clearly and concisely.
* Strong meeting facilitation and interviewing skills.
* Ability to work well with individuals at all levels within and outside the organization; and
* Experience documenting business processes, writing functional specifications, creating test scripts, and researching testing issues. and documenting user procedures.
Additional Information
Salary Range: $90,000
Salary cannot exceed $90,000
All applications must include a cover letter. Applications without a cover letter will be considered incomplete.
Did you know?
* We are a Public Service Loan Forgiveness Program qualified employer : 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
* We offer Comprehensive health coverage for employees and their eligible dependents
* Our wellness program offers eligibility into the discounted medical plan
* Employees receive paid vacation, sick leave, and holidays
* Generous retirement savings options are available
* The successful candidate must be a city of Philadelphia resident within six months of hire
Effective May 22, 2023, vaccinations are no longer required for new employees that work in non-medical, non-emergency or patient facing positions with the City of Philadelphia. As a result, only employees in positions providing services that are patient-facing medical care (ex: Nurses, doctors, emergency medical personnel), must be fully vaccinated.
The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race,
ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at ************ or send an email to *********************** more information, go to: Human Relations Website:
******************************************************
Job Location
Google Maps requires functional cookies to be enabled
$90k yearly 29d ago
Data Analyst
Tata Consulting Services 4.3
Reporting analyst job in Philadelphia, PA
Must Have Technical/Functional Skills * Strong experience in SQL and working with relational databases (e.g., SQL Server, PostgreSQL). * Proven ability to analyze complex stored procedures and extract business logic. * Experience creating source-to-target mappings and data flow documentation.
* Solid understanding of financial and actuarial data, including claims, premiums, reserves, and forecasts.
* Familiarity with data quality frameworks and issue resolution techniques.
* Excellent analytical, problem-solving, and communication skills.
* Ability to work independently and manage tasks in a remote, distributed team environment.
Roles & Responsibilities
* Analyze and understand existing stored procedures to reverse engineer business logic and data flows.
* Create and maintain Source-to-Target Mapping (STTM) documents for data integration and transformation processes.
* Investigate and resolve data quality issues, including root cause analysis and recommendations.
* Perform data profiling and validation to ensure accuracy and completeness of financial and actuarial datasets.
* Collaborate with data modelers, developers, and business analysts to support data requirements and reporting needs.
* Document business rules, data definitions, and transformation logic clearly and accurately.
* Participate in daily stand-ups or sync meetings during onshore-offshore overlap hours.
TCS Employee Benefits Summary:
* Discretionary Annual Incentive.
* Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
* Family Support: Maternal & Parental Leaves.
* Insurance Options: Auto & Home Insurance, Identity Theft Protection.
* Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
* Time Off: Vacation, Time Off, Sick Leave & Holidays.
* Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range : $105,000-$125,000 a year
$105k-125k yearly 32d ago
Enterprise Resource Planning (ERP) Data Analytics and Reporting Analyst
City of Philadelphia, Pa 4.6
Reporting analyst job in Philadelphia, PA
The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer (CIO). OIT oversees all major information and communications technology initiatives for the City of Philadelphia - increasing the effectiveness of the information technology infrastructure, where the services provided are advanced, optimized, and responsive to the needs of the City of Philadelphia's businesses, residents, and visitors. OIT responsibilities include: identifying the most effective approach for implementing new information technology directions throughout city government; improving the value of the city's technology assets and the return on the city's technology investments; ensuring data security continuity; planning for continuing operations in the event of disruption of information technology or communications services; and supporting accountable, efficient and effective government across every city department, board, commission and agency.
In partnership with the Office of the Chief Administrative Officer (CAO) and the Office of the Director of Finance, the Office of Innovation and Technology (OIT) is undertaking a major Citywide project to modernize core financial, grants, procurement, and supply chain business processes. This project (Optimize Procurement and Accounting Logistics Enterprise Resource Planning and Data Warehouse/Business Intelligence Tool, or "OPAL ERP and DW/BI project") will replace the existing General Ledger and Procurement systems (i.e. FAMIS, ADPICS, ACIS, PHLContracts, etc.) that support these business processes and will enable the City to realize benefits such as reducing transaction processing time and effort, providing better access to information for reporting and analysis, and making it easier to onboard new employees into these functions.
Job Description
The Enterprise Resource Planning (ERP) Data Analytics and ReportingAnalyst is responsible for day-to-day interactions with the project team and managing the development and implementation of assigned reports and related responsibilities. This is a permanent exempt position that will move to maintenance and support after the project is complete (in 3-4 years).
Essential Functions:
During implementation:
* Gather and document the requirements for ERP data and reports.
* Prepare and test the reporting configurations to validate the design setup.
* Create and deploy the business process and systems user procedures.
* Write/update technical specifications.
* Create new reports and retrofit existing reports.
* Meet delivery schedule.
* Execute and document unit test cases.
* Provide weekly tasks and reports to development leads.
Post Implementation:
* Identify, resolve, and report on ERP data and reporting issues and document enhancements requests.
* Analyze, define, and design new release reporting functionality to determine relevance to meet the current or new business processes & requirements.
* Document the business process revisions and application configuration training content.
* Create and deploy new process,s and systems changes to the end users.
* Participate in regression testing efforts.
* Look for opportunities to optimize the business reporting such as new processes to meet future requirements or leverage delivered systems functionality and technology.
* Participate in break fix and regression testing efforts.
Qualifications
* Completion of a Bachelor's or Master's degree in information systems, computer engineering, or a related field or equivalent experience;
* 3-5 years of experience with ERP systems, 3rd Party Applications and related reports development and deployment.
* Experience with implementing ERP and/or DW/BI solutions strongly preferred
Competencies, Knowledge, Skills and Abilities
* Experience with Finance and Grants / Supply Chain (SCM) and Procurement business intelligence (BI)/ data warehouse (DW) applications and report generation packages.
* Experience with query development, writing and implementation.
* Strong problem solving and analytic skillsets.
* Strong verbal and written communication skills with ability to create user and project security documentation and procedures, clearly and concisely.
* Strong meeting facilitation and interviewing skills.
* Ability to work well with individuals at all levels within and outside the organization; and
* Experience documenting business processes, writing functional specifications, creating test scripts, and researching testing issues. and documenting user procedures.
Additional Information
Salary Range: $90,000
Salary cannot exceed $90,000
All applications must include a cover letter. Applications without a cover letter will be considered incomplete.
Did you know?
● We are a Public Service Loan Forgiveness Program qualified employer : 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
● We offer Comprehensive health coverage for employees and their eligible dependents
● Our wellness program offers eligibility into the discounted medical plan
● Employees receive paid vacation, sick leave, and holidays
● Generous retirement savings options are available
* The successful candidate must be a city of Philadelphia resident within six months of hire
Effective May 22, 2023, vaccinations are no longer required for new employees that work in non-medical, non-emergency or patient facing positions with the City of Philadelphia. As a result, only employees in positions providing services that are patient-facing medical care (ex: Nurses, doctors, emergency medical personnel), must be fully vaccinated.
The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race,
ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at ************ or send an email to *********************** more information, go to: Human Relations Website:
******************************************************
$90k yearly 28d ago
Data Analyst - I
Pioneer Data Systems
Reporting analyst job in Somerville, NJ
Job Title: Data Analyst (Cognos/Tableau, Sharepoint) Division: Global Business Insights Supervisor Title: Senior Director/Director or Manager, US Market Insights Somerville/Cincinnati Location: General Summary (brief description stating general nature, level and purpose of job):
With supervision, position is responsible for analyzing competitive insights within the Global Business Insights Center of Excellence team (GBI), supporting the assigned business unit / region. Position is responsible for executing competitive intelligence research and analysis.
Position will serve as representative on the assigned Business Unit / Regional Insight team, and will support both the Global Strategic Marketing and Regional Marketing Teams.
With supervision, role will work with the Business Unit teams to conduct competitive insight and analysis activities, including but not limited to competitor pipeline, commercial strategy, tactical and strategic plans, and marketplace conditions and technology scenarios.
Role will require business acumen and understanding, and must be able to work with competitive insight and analysis tools and techniques across the business.
Required Duties and Responsibilities:
Utilize COGNOS, Tableau reporting software to identify and analyze data to support key organizational strategies
Create integrated analyses from varied data sources
Develop and maintain MS Excel and MS Access sourcing databases
Support US Marketing and GBI team with ad-hoc projects
Develop and maintain internal SharePoint data libraries and communication materials
With direction, demonstrate an ability to implement competitive insight and analysis projects in support of assigned business unit / region.
With supervision, synthesize data to form recommendations and actionable insights
Demonstrate an ability to influence multiple stakeholders to ensure a high-level of team involvement in key business discussions
With direction, supports Business Unit / Regional Insight Team in
Providing competitive market assessments and scenarios
Flawless execution of all projects and activities required to drive success of the business
Provides fact based insights and analytics programs to address business needs
Executing insight and business analytics tools, techniques and processes
Provide foundational learning that helps to ensure understanding of marketplace dynamics
Support education and dissemination of existing knowledge estate and market information for key Business Unit / Region partners
Required Education and/or Experience:
Bachelor's degree and 6 months experience in Analyst or similar role
Proficiency with database management tools and presentation of data analysis - COGNOS, Tableau Data Visualizations business software knowledge is a plus
Strong quantitative and analytic abilities to analyze and validate data
Excellent computer skills (Excel, Word, PowerPoint, SharePoint, Access)
Exceptional interpersonal, communication and organizational skills
Detail oriented, dependable and motivated
Interested in learning new things and comfortable taking the initiative to seek out projects or new areas of responsibility
Experience in the medical device, hospital specialty, or healthcare field is preferred, but not required
Ability to work in a matrix environment where a high degree of collaboration is needed
Other Skills and Abilities
Excellent personal leadership, collaboration, communication and analytical skills are required.
Ability to support cross-functional teams
With direction, ability to understand, and translate customer insight/marketing research data tools and techniques into actionable insights to drive decision-making is required.
Strong analytic and critical thinking skills required
Able to work on multiple projects with conflicting deadlines.
Demonstrated success in creative problem solving and team partnership is required.
Due to the nature of information reviewed in the role, candidate must demonstrate a high level of discretion and confidentiality
Excellent verbal and written presentation skills are required.
Strong project management skills are required.
Ability to organize and present information to internal business partners
Strong project management skills are required.
Desired Characteristics:
Connect business partners to marketplace and competitor insights
Shape business strategy to meet future competitive needs
Lead insight development
Deliver insights that drive current and future Ethicon GSG competitive advantage
Disclaimer:
The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.
If you are qualified, available, interested, planning to make a change, or know of a friend who might have the required qualifications and interest, please call me ASAP at **************, even if we have spoken recently about a different position. If you do respond via e-mail please include a daytime phone number so I can reach you. In considering candidates, time is of the essence, so please respond ASAP.
Thank you.
Additional Information
Need only on W2 no C2C
$69k-98k yearly est. 60d+ ago
Data Analyst
Tectammina
Reporting analyst job in Hopewell, NJ
Responsibilities: " Design and prototype the solutions · Solution assessment and vendor assessment. · Critical thinking. · Good communication and presentation skills. Required Skills (Must have) - top 3 required skillsets based on priority: Microstrategy Additional Information
Job Status: Permanent / Full time postion
Eligibility: EAD GC/ GC/ US Citizen
Share the Profiles to **********************
Contact: ************
Keep the subject line with Job Title and Location
$69k-97k yearly est. Easy Apply 16h ago
Project Analyst
GSI Technology 4.6
Reporting analyst job in Trenton, NJ
The Project Analyst will perform a variety of tasks associated with planning, coordinating and executing the administration of a program.
The position will act as a coordinator for the Directorate of Human Resources (DHR) Casualty Operations Center in the conduct of Military Funeral Honors (MFH) and casualty notification; ensure that all notifications from the Casualty and Mortuary Affairs Operations Division to any of the eight (8) Casualty Assistance Centers are acknowledged within specified time parameters; coordinate directly with the DHR Casualty Operations Chief when special situations present a problem; ensure accuracy of personnel identified to conduct the burial; and advise participants on logistical and technical matters.
The position requires 40 hours per week, Monday through Friday, during normal business hours 0700 - 1830 onsite at the facilities at the DHR, 99th DIV (R), 5231 South Scott Plaza, Joint Base McGuire-Dix-Lakehurst (JB MDL), NJ 08640-5730.
DUTIES AND RESPONSIBILITIES
Primary duties and responsibilities include (but are not limited to):
Prepares a variety of narrative and tabular material (e.g. correspondence, reports, technical papers, charts, statistical tables, manuals, travel orders, messages and other documents) involving the common terminology of the unit for which the work is done and requiring accuracy in spelling, grammar, and syllabication.
Assures the propriety of formats, spacing, arrangements, and preparation of typed material in final form as prescribed by Army Regulations. Uses judgment regarding form and arrangement of statistical or tabular material involving numerous heading and subheadings.
Receives telephone calls and furnishes information requested in accordance with regulations; routes, controls and distributes mail; maintains files; and composes routine correspondence affecting the MFH Program and Casualty Operations.
Edits office memorandums and documents related to the MFH Program and Casualty Operations. Assemble documents for reproduction, distribution and mailing.
Maintains inventory of necessary equipment and supplies. Request materials for re-supply and reproduction. Request for non-emergency computer maintenance through local Information Technology help desk.
Answers all inquiries pertaining to all MFH Program and Casualty Operations matters in a courteous, professional manner.
Maintains computer database systems and access to include: Military Funeral Honors Database (formerly TAPS), Microsoft Outlook email account with Army Reserve Account Maintenance and Provisioning (ARAMP), MilConnect, Microsoft Excel spreadsheets, US Army Reserve Casualty SharePoint, and DHR Shared Drive.
Performs other duties as assigned.
MINIMUM QUALIFICATIONS, SKILLS, AND EDUCATIONAL REQUIREMENTS
Professional experience in a related field is preferred, with an ability to use advanced tools in the Microsoft family of products, including maintaining Access and Excel databases.
College degree or five years of professional experience in lieu of degree required.
Employees must be able to pass a background investigation and be able to secure a Secret Security Clearance prior to appointment.
We are committed to a merit-based hiring process that values individual skills, qualifications, and performance. Our hiring practices comply with all applicable federal, state, and executive orders, including the recent Executive Order on Equal Opportunity Hiring.
$70k-112k yearly est. Auto-Apply 60d+ ago
Fraud Data Analyst (onsite)
American Heritage Federal Credit Union 4.3
Reporting analyst job in Trevose, PA
American Heritage Credit Union, a $5+ billion credit union, has an immediate opening for a Fraud Data Analyst. This position will assist the Enterprise Risk and Compliance team in preventing fraud and managing losses to mitigate their effects on the credit union and its members. Provide analytic and project support to the ERM department for the advancement of controls and mitigation of risk by organizing, analyzing, and drawing conclusions from volumes of data to identify fraud trends by leveraging multiple technologies and working across verticals to help design mitigation strategies.
Responsibilities Include:
* Delve into production data to produce, maintain, and curate metrics and reports for the Fraud team to implement strategies to combat fraud.
* Review system-generated triggers for potentially fraudulent activity on members' accounts as well as credit and debit cards.
* Perform detailed research and investigation on alerts that are generated for potential fraud schemes.
* Work closely with variety of cross-functional teams to analyze suspicious activity and provide mitigation recommendations.
* Build and maintain tools and\/or processes to collect and track data and troubleshoot errors.
* Develop and maintain processes and documentation to ensure best practices for fraud identification, escalation, and mitigation are effectively adhered to and communicated.
* Develop, maintain, and publish periodic Key Performance Indicators (critical metrics) for the Fraud Program.
* Leverage data to understand fraudulent behavior, identify trends that indicate elevated risk, and report to appropriate team and management.
* Use relational database queries and spreadsheets to quickly analyze, manipulate, and visualize small to large datasets to guide fraud and risk policy discussions.
* Conduct research, work independently, and make complex investigation decisions.
* Develop strategies for the prevention and\/or detection of internal and external fraud.
* Support development of new fraud tools, processes, and third-party provided services.
* Work closely with third-party providers to promptly implement, update, and make changes to fraud preventive rules.
* Interpret data, analyze results using analytics, research methodologies, and statistical techniques.
* Prepare, analyze, and summarize various weekly, monthly, and periodic operational results for use by various key stakeholders by creating reports, specifications, instructions, and flowcharts.
* Conduct full lifecycle of analytics projects, including pulling, manipulating, and exporting data from project requirement documentation to design and execution.
* Respond to fraud alerts by notifying members, restricting cards or other account privileges, and closing accounts.
* Investigate claims of fraud against the member and credit union by following governing regulations, policies, and procedures when gathering evidence and information.
* Assist with subpoenas and legal requests and provide timely and accurate evidence to law enforcement agencies.
* Assist with the processing of fraudulent items by gathering information and presenting documentary evidence in an accurate and timely manner; Work with members to define and eliminate future fraudulent transactions.
* Assist the ERM team with the timely preparation of Fraudulent Check Crime Reports, Bad Check Reports, and Fraudulent Credit Card Reports.
* Assist with performing collection activities as needed on suspected or potentially fraudulent accounts; Track losses resulting from fraudulent transactions within the case management system.
* Assist the ERM team with any investigations requested at the direction of the AVP of Fraud Investigations.
* At the direction of the AVP of Fraud Investigations, assist branch staff and other departments throughout the credit union with resolving questionable activity on member accounts.
* Assist with implementing corrective action procedures as necessary to ensure compliance with policies and procedures and to avoid future compliance issues.
* Participate in establishing and maintaining professional business relationships with regulatory agencies, auditors, appraisers, and business associates including legal and law enforcement.
* Assist with prompt resolution of complaints, questions, and problems.
* Maintain awareness of new fraud techniques and security developments for counteracting fraud.
* Remain informed of trends and developments in loss and fraud issues and loan reviews.
QUALIFICATIONS:
* One to three years of similar or related experience using advanced data mining tools and large datasets, performing statistical analysis, and conducting predictive modeling.
* Financial institution experience and industry knowledge required.
* Equivalent to a college degree (BS or BA) preferably in a quantitative field (Finance, Risk, Mathematics or Statistics) or the equivalent combination of education and experience in Fraud Prevention.
* Experience with analyzing Payment Data, ACH\/Wire data, Fraud data, Financial Crime data.
* Experience in performing trend and detect analysis and building reports.
* Significant experience with relational databases, scripting languages, and database concepts.
* Knowledge of risk management and control principles.
* Working knowledge or the ability to learn and understand credit union products and services.
* Advanced analytical skills with experience collecting, organizing, analyzing, and disseminating abundant information with accuracy.
* Problem-solver with a strong analytic mindset, competent in research and problem resolution.
* Reliable and thorough with a deep commitment to quality and accuracy; Keen eye for details and exceptional analytical, planning, organizational and problem-solving skills.
* Considerable judgment is required. Must be able to analyze complicated factual situations, apply functional principles and develop solutions.
* Ability to understand broader business issues, objectively analyze data and information to form a big-picture view of risk.
* Creativity and ability to be data-driven and aggressive in delivering results required.
* Self-motivated with proven ability to work independently under minimal supervision, prioritize issues, work within ambiguity, and manage tight deadlines.
* Must be available for rotating weekend hours
* Must be available to work in office at the Neshaminy Interplex office.
Our commitment to your success is enhanced by our competitive rate commensurate with experience and an extensive benefits package including paid time off, health benefits, 401(k) with a generous escalating company match, and future growth opportunities within the company. We work to maintain the best possible professional and environmentally friendly atmosphere for our employees.
EOE M\/F\/D\/V","
$54k-67k yearly est. 19d ago
Project Operations Analyst
CME Associates 4.0
Reporting analyst job in East Brunswick, NJ
Job DescriptionDescriptionCME Associates is currently seeking for a
Project Operations Analyst
to join their team of professionals in our Business Operations Department. If you are a hard-working, self-motivated team player, we invite you to explore a career with CME Associates.
The Project Operations Analyst is a critical member of the Business Operations team, responsible for driving project excellence by partnering with Project Managers (PMs) and senior leadership. This role ensures that project reviews are conducted regularly and effectively, focusing on schedule adherence, forecasting accuracy, compliance, and operational insights. The Analyst will also play a key role in educating and enabling PMs to interpret and act on project data to drive performance and accountability.
Responsibilities• Lead Monthly Project Reviews.o Facilitate structured project review meetings with PMs and senior leaders, ensuring clear communication of schedule status, financial forecasts, risks, and required actions.• Analyze and Forecast Project Performanceo Develop and maintain tools for forecasting project progress, revenue, and margin performance; highlight variances and trends across the project portfolio.• Compliance and Controlso Monitor and highlight data compliance with internal project setup, phase tracking, timecard submissions, and end-date management.• PM Enablement and Trainingo Highlight training opportunities for PMs and work with SVPs and VP of Business Operations to facilitate training when applicable.• Data Interpretation and Insightso Translate complex project data into executive-level insights, project level insights, and summaries that drive decision-making and accountability.• Continuous Improvemento Identify gaps in project execution or reporting and collaborate with Operations and Finance to refine tools, templates, and standard processes.
Success Metrics
• % of project reviews completed monthly with full compliance• Improvement in forecasting accuracy across teams• Increase in PMs' operational literacy (measured through training feedback and behavior change)• Reduction in late end-date extensions, missed budget triggers, or compliance gaps
Qualifications• Bachelor's of Science Degree, preferably in Engineering, Environmental Science, Surveying, Construction Management, or other relevant job experience equivalent to these.
• 3-5 years of experience in project operations, financial analysis, or engineering consulting industry
Preferred Qualifications:
Technical Skills:• Knowledge of cost estimation techniques and software.• High competency in KPIs (Key Performance Indicators) for tracking project progress.• Proficient in Excel, project management systems (e.g., Deltek Vision/Vantagepoint), and business intelligence tools (e.g., Power BI)• Proficiency with Microsoft Teams for team communication and updates.
BenefitsCME offers a competitive compensation package including: medical, prescription, dental and vision coverage, 401(k) retirement plan with employer match, educational assistance program and paid time off.
$72k-94k yearly est. 19d ago
Temporary Contracts Data Analyst
Ieee 4.9
Reporting analyst job in Piscataway, NJ
Temporary Contracts Data Analyst - 250308: N/A Description Job SummaryThe Temporary Contracts Data Analyst will play a key role in supporting IEEE's Conferences, Events, and Experiences (CEE) department through detailed contract data analysis and accurate, compliant payment processing.
This highly collaborative role works closely with both the Contracts and Finance teams to ensure that all contractual commitments and financial obligations are accurately captured, tracked, and fulfilled on time.
The ideal candidate will combine strong analytical skills with exceptional attention to detail and a deep commitment to accuracy and compliance.
This position is integral to ensuring that all executed contracts and associated payments align with IEEE policies, financial standards, and tax regulations.
The role reports to the Senior Manager, Event Vendor Management & Contracting, and does not manage direct reports.
This position works under minimal supervision.
Key ResponsibilitiesReview and analyze executed hotel contracts within IEEE's centralized contract management system (CMS).
Identify, extract, and record key data points, including (but not limited to):Room block details (dates, quantities, rates, review/release dates) Food & Beverage minimums and review dates Deposit schedules, payment terms, and due dates Cancellation and attrition clauses, including tiered penalties and timelines Concessions, rebates, commissions, and other negotiated financial terms Special commitments, hotel obligations, or planner responsibilities Enter all collected information into standardized tracking templates or internal reporting tools.
Flag missing, inconsistent, or ambiguous data for internal review and clarification.
Summarize relevant contract details to provide visibility for internal teams and conference organizers.
Partner with the Contracts team to ensure all commitments and deliverables are accurately reflected in tracking systems and communicated to stakeholders.
Collaborate closely with the Finance team to process and reconcile payments tied to executed agreements, ensuring that all disbursements align with contract terms and are fully supported by proper documentation.
Review and validate payment requests for vendors, speakers, and other payees to confirm accuracy, compliance, and proper authorization.
Maintain organized records of all contractual and payment data to support timely reporting and clear audit trails.
Proactively communicate with conference organizers and internal teams regarding payment status, missing documentation, or contract fulfillment requirements.
Support continuous improvement by identifying process gaps and recommending efficiencies in contract tracking and payment workflows.
Qualifications Qualifications - EducationBachelor's degree or equivalent experience Work Experience2-4 years' experience preferred with contract negotiation and document review in a procurement capacity 2-4 years' experience in a data analytics role Skills and Requirements Prior experience reviewing contracts or working with contract data strongly preferred.
Strong attention to detail and accuracy in data entry and analysis.
Excellent organizational and communication skills.
Proficient in Microsoft Excel, Word, and data tracking systems Ability to work independently and manage multiple tasks in a fast-paced environment.
Excellent communication skills (verbal/written), time and project management skills, dedication to detail and the ability to work under pressure in a deadline driven environment.
Positive attitude and a supportive, team-based approach towards the attainment of departmental goals.
Must have the ability to represent the IEEE in a professional manner Job: Administration Primary Location: United States-New Jersey-Piscataway Schedule: Full-time Job Type: Temporary Job Posting: Nov 20, 2025, 1:38:45 PM
$66k-85k yearly est. Auto-Apply 5h ago
Enterprise Resource Planning (ERP) Data Analytics and Reporting Analyst
City of Philadelphia 4.6
Reporting analyst job in Philadelphia, PA
The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer (CIO). OIT oversees all major information and communications technology initiatives for the City of Philadelphia - increasing the effectiveness of the information technology infrastructure, where the services provided are advanced, optimized, and responsive to the needs of the City of Philadelphia's businesses, residents, and visitors. OIT responsibilities include: identifying the most effective approach for implementing new information technology directions throughout city government; improving the value of the city's technology assets and the return on the city's technology investments; ensuring data security continuity; planning for continuing operations in the event of disruption of information technology or communications services; and supporting accountable, efficient and effective government across every city department, board, commission and agency.
In partnership with the Office of the Chief Administrative Officer (CAO) and the Office of the Director of Finance, the Office of Innovation and Technology (OIT) is undertaking a major Citywide project to modernize core financial, grants, procurement, and supply chain business processes. This project (Optimize Procurement and Accounting Logistics Enterprise Resource Planning and Data Warehouse/Business Intelligence Tool, or “OPAL ERP and DW/BI project”) will replace the existing General Ledger and Procurement systems (i.e. FAMIS, ADPICS, ACIS, PHLContracts, etc.) that support these business processes and will enable the City to realize benefits such as reducing transaction processing time and effort, providing better access to information for reporting and analysis, and making it easier to onboard new employees into these functions.
Job Description
The Enterprise Resource Planning (ERP) Data Analytics and ReportingAnalyst is responsible for day-to-day interactions with the project team and managing the development and implementation of assigned reports and related responsibilities. This is a permanent exempt position that will move to maintenance and support after the project is complete (in 3-4 years).
Essential Functions:
During implementation:
Gather and document the requirements for ERP data and reports.
Prepare and test the reporting configurations to validate the design setup.
Create and deploy the business process and systems user procedures.
Write/update technical specifications.
Create new reports and retrofit existing reports.
Meet delivery schedule.
Execute and document unit test cases.
Provide weekly tasks and reports to development leads.
Post Implementation:
Identify, resolve, and report on ERP data and reporting issues and document enhancements requests.
Analyze, define, and design new release reporting functionality to determine relevance to meet the current or new business processes & requirements.
Document the business process revisions and application configuration training content.
Create and deploy new process,s and systems changes to the end users.
Participate in regression testing efforts.
Look for opportunities to optimize the business reporting such as new processes to meet future requirements or leverage delivered systems functionality and technology.
Participate in break fix and regression testing efforts.
Qualifications
Completion of a Bachelor's or Master's degree in information systems, computer engineering, or a related field or equivalent experience;
3-5 years of experience with ERP systems, 3rd Party Applications and related reports development and deployment.
Experience with implementing ERP and/or DW/BI solutions strongly preferred
Competencies, Knowledge, Skills and Abilities
Experience with Finance and Grants / Supply Chain (SCM) and Procurement business intelligence (BI)/ data warehouse (DW) applications and report generation packages.
Experience with query development, writing and implementation.
Strong problem solving and analytic skillsets.
Strong verbal and written communication skills with ability to create user and project security documentation and procedures, clearly and concisely.
Strong meeting facilitation and interviewing skills.
Ability to work well with individuals at all levels within and outside the organization; and
Experience documenting business processes, writing functional specifications, creating test scripts, and researching testing issues. and documenting user procedures.
Additional Information
Salary Range: $90,000
Salary cannot exceed $90,000
All applications must include a cover letter. Applications without a cover letter will be considered incomplete.
Did you know?
● We are a Public Service Loan Forgiveness Program qualified employer : 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
● We offer Comprehensive health coverage for employees and their eligible dependents
● Our wellness program offers eligibility into the discounted medical plan
● Employees receive paid vacation, sick leave, and holidays
● Generous retirement savings options are available
*The successful candidate must be a city of Philadelphia resident within six months of hire
Effective May 22, 2023, vaccinations are no longer required for new employees that work in non-medical, non-emergency or patient facing positions with the City of Philadelphia. As a result, only employees in positions providing services that are patient-facing medical care (ex: Nurses, doctors, emergency medical personnel), must be fully vaccinated.
The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race,
ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at ************ or send an email to *********************** more information, go to: Human Relations Website:
******************************************************
How much does a reporting analyst earn in Lower Makefield, PA?
The average reporting analyst in Lower Makefield, PA earns between $56,000 and $96,000 annually. This compares to the national average reporting analyst range of $56,000 to $95,000.
Average reporting analyst salary in Lower Makefield, PA
$73,000
What are the biggest employers of Reporting Analysts in Lower Makefield, PA?
The biggest employers of Reporting Analysts in Lower Makefield, PA are: