ERP Systems Analyst
Core
Supporting, maintaining, and improving the company's enterprise resource planning systems, specifically Sage 300 CRE and Microsoft SQL Server, with a focus on Crystal Reports development, data analysis, and system integrations.
Role type
ERP Systems Analyst
Builds
Financial and operational reports, data integrations, and migration support for future ERP platforms
Domain
Construction and Real Estate / Enterprise Resource Planning
Deliverable
dashboards & analysis
Required skills
Sage 300 CRE administration, Crystal Reports development, SQL query writing and optimization, data extraction and cleansing, ETL process development, system integration troubleshooting, data mapping, database performance tuning
Preferred skills
Power BI, Sage Intelligence, legacy system modernization
Technologies
Sage 300 CRE, Microsoft SQL Server, Crystal Reports, Power BI, Sage Intelligence
Responsibilities
Develop and optimize complex Crystal Reports for financial and operational use; Write and optimize SQL queries for reporting and data analysis; Support Sage 300 CRE modules, workflows, and database structures; Extract, clean, and validate data for future ERP migration; Troubleshoot and maintain integrations between ERP and third-party systems; Document system configurations, customizations, and business processes.
Seniority
Mid-level, hands-on IC