ERP Developer/Analyst

About the role

The Beck Group is seeking an ERP Developer/Analyst to join our IT team. This role involves developing, debugging, and optimizing database objects using Oracle PL/SQL, supporting the ERP system, and collaborating with various departments to improve system efficiency.

Responsibilities

• Developing, debugging, and optimizing database objects using Oracle PL/SQL
• Writing ad-hoc queries and reports; developing BI dashboards to meet business needs
• Supporting the ERP system, including integrations with external systems
• Ensuring ERP system stability, security, and functionality; monitoring backups of all databases and database servers
• Partnering with HR, Accounting, and Design and Construction teams to identify system improvements and implement solutions
• Coordinating system upgrades, patches, and releases; conducting regression testing and validation
• Participating in disaster recovery planning and testing
• Running monthly processes in the ERP system to support corporate/field operations
• Creating new user accounts
• Triaging customer issues
• Managing vendor relationships, submitting and tracking vendor help requests and feature requests
• Accurately recording, updating, and documenting requests using the IT service desk system
• Creating user guides and other related documentation
• Building rapport and communicating effectively with technical and non-technical colleagues at all levels in the organization
• Maintaining compliance with all company policies and procedures

Requirements

• Bachelor’s degree in computer science, engineering, information systems, or equivalent
• 4+ years database development in Oracle environment
• 4+ years writing and debugging stored procedures, functions, views, triggers, indexes, constraints
• 2+ years experience with Business Intelligence tools such as Tableau or PowerBI
• Experience with SQL Server Reporting Services, Oracle Forms, Oracle Reports or Jasper
• Strong analytical, problem solving, and troubleshooting skills
• Excellent written and verbal communication skills
• Proactive approach to customer service
• Experience in database design and modeling
• Experience in performance tuning and query optimization
• Advanced use of Windows applications and file systems, including RDP, UNC paths, folder permissions, and batch scripting
• CMiC or other construction ERP experience a plus
• Experience with Toad a plus
• Advanced use of Excel formulas, Power Queries, and Pivot Tables a plus
• Knowledge of HTML, CSS a plus
• Experience with PowerShell, Python, or other scripting languages a plus
• Desire to continue education through trade shows, conferences, online courses, etc.

Qualifications

• Ability to prioritize tasks, manage schedule, and work under pressure
• Desire to continue education through trade shows, conferences, online courses, etc.

Skills

• Advanced use of Windows applications and file systems, including RDP, UNC paths, folder permissions, and batch scripting
• CMiC or other construction ERP experience a plus
• Experience with Toad a plus
• Advanced use of Excel formulas, Power Queries, and Pivot Tables a plus
• Knowledge of HTML, CSS a plus
• Experience with PowerShell, Python, or other scripting languages a plus

Benefits

At Beck, we offer a comprehensive benefits package including:

• 401k match and free SmartDollar program for financial wellness
• Free dedicated financial coach
• Personal health & fitness program for tracking activities & earning rewards
• Paid family leave
• Health discounts on medical premiums
• Free comprehensive health screenings
• Free health coach program for weight-loss & hypertension management
• Free Life Coach
• Pet insurance discount
• Organized projects and events to support our communities