SQL Server Development & Administration ERP Data Management & Integration Support Maintain backend tables and data flows for 2020 Insight. Support ERP integration data pipelines with Salesforce, S2K, Avalara, Reconnex, and Yooz
Responsibilities: * Lead financial planning & analysis, budget creation, forecasting, financial forecasting using data analytics & visualization.
Job description* Accounts Payable GL entry and analysis Coordination with US teams English speaking and excel knowledge is must Job Type: Permanent Pay: ₹15,000.00 - ₹22,000.00 per month Benefits: Health insurance Education: Bachelor's (Required) Language: Fluent English (Required) License/Certification: Bcom (Required) Shift availability: Night Shift (Required) Expected Start Date: 20/11/2025
Job Title: ERP Engineer 2020 Insight/Construct Experience Level: 2-5 Years Role Overview The ERP Engineer will play a critical role in learning, configuring, and supporting the 2020 platform in-house. This position involves setting up the 2020 system, managing integrations, supporting business users, and documenting processes. Key Responsibilities 1. ERP System Ownership Develop deep, hands-on knowledge of 2020 Insight and 2020 Construct. Configure and maintain products, items, materials, MRP (POs, receiving, inventory, shipping) and MES (planning, scheduling, optimization) Customize forms, layouts, user management, security management and work flows using XML and SQL Act as the primary in-house SME (subject matter expert) for 2020 systems. 2. Integration & Data Flow Support Support and troubleshoot integrations between 2020 Insight and Salesforce, S2K (finance), Avalara (tax), Reconex (freight), and Yooz (AP automation). Understand JSON contracts, mapping rules, and data synchronization workflows. Document integration logic to reduce black-box dependency on external parties. 3. Knowledge Capture & Documentation Build a knowledge base of 2020 configurations, processes, and integrations. Translate consultant-driven implementations into internal reference guides . Document ERP best practices to enable training of future hires. 4. User Support & Training Provide first-line support for operations, finance, and customer service teams. Conduct internal training sessions to increase adoption of ERP features. Partner with business leaders to refine system use cases and reduce customizations. 5. Continuous Improvement Proactively identify opportunities to simplify workflows in 2020. Track and evaluate Cyncly updates/releases and assess adoption internally. Suggest automation or AI-driven enhancements (future Industry 4.0 roadmap). Required Skills & Qualifications Education: Bachelors degree in Information Systems, Engineering, or related field. Experience: 25 years ERP experience, ideally with 2020 Insight/Construct in manufacturing (furniture or similar). Knowledge: Working knowledge of any ERP system Technical Skills: SQL (or any RDBMS) for queries and troubleshooting. Basic API/JSON knowledge for integrations. Business Acumen: Understanding of manufacturing execution, order management, BOMs, and finance (invoicing, deposits). Soft Skills: Strong learner mindset (able to reverse-engineer consultant solutions). Documentation and training capability. Cross-functional collaboration (IT, Finance, Operations). Preferred Skills Experience with Workato or iPaaS tools for integration. Exposure to manufacturing domain. Key Outcomes (6-12 Months) Internal ownership of 2020 Insight setup and configurations. Complete documentation of ERP workflows and integrations Established ERP training materials for internal IT and business users.
Job Title: SQL Developer 2020 ERP (Backend & Automation Specialist) Experience Level: 36 Years Role Overview We are seeking a SQL Developer with strong skills in SQL Server backend development, data management, and Python automation to support our 2020 Insight ERP environment. This role focuses on building and maintaining queries, stored procedures, reports, dashboards, and automation scripts to ensure accurate data, smooth ERP operations, and efficient integrations with Salesforce, S2K, Avalara, Reconnex, and Yooz. The candidate will serve as the in-house backend expert, ensuring data integrity, system performance, and reducing reliance on external consultants. Key Responsibilities 1. SQL Server Development & Administration Design, develop, and optimize queries, views, stored procedures, and triggers to support ERP workflows. Perform data uploads, cleanup, and transformation for ERP modules (procurement, inventory, MES, shipping, invoicing). Monitor and maintain SQL Server performance, indexing, and health checks. Schedule and validate database backups and recovery processes. 2. Reporting & Dashboards Build custom reports and dashboards to support Finance, Operations, and Manufacturing teams. Automate recurring reports for forecasting, costing, and production KPIs. Collaborate with business users to design self-service reporting datasets. 3. Automation & Scripting Develop Python scripts to automate repetitive database tasks (data validation, cleanup, report generation). Integrate Python with SQL Server for ETL pipelines and data quality checks. Support ERP batch jobs and file-based integrations with external systems. 4. ERP Data Management & Integration Support Maintain backend tables and data flows for 2020 Insight. Support ERP integration data pipelines with Salesforce, S2K, Avalara, Reconnex, and Yooz. Troubleshoot backend issues (order updates, shipments, invoicing, and financial postings). 5. Knowledge Capture & Documentation Document SQL structures, stored procedures, and automation scripts. Build a knowledge base of ERP backend workflows to enable internal ownership. Train IT and business users on SQL-driven reports and dashboards. Required Skills & Qualifications Education: Bachelors degree in Computer Science, Information Systems, or related field. Experience: 36 years SQL/database development experience in ERP or enterprise systems. Technical Skills: Strong SQL Server skills (queries, stored procedures, views, triggers, indexing). Database administration (performance tuning, backups, monitoring). Python for automation, ETL, and reporting tasks. Experience building reports/dashboards in Power BI, Tableau, or SSRS. ERP Knowledge: Understanding of ERP modules (procurement, inventory, MES, shipping, finance). Ability to translate business requirements into backend logic and reports. Soft Skills: Analytical and troubleshooting abilities. Strong documentation and communication skills. Collaboration with IT, Finance, and Operations. Preferred Skills Experience with 2020 Insight/Construct ERP backend. Exposure to Salesforce or ERP data models. Familiarity with iPaaS tools (Workato, MuleSoft, Boomi). Scripting experience in PowerShell or Shell (in addition to Python). Key Outcomes (612 Months) Fully functional set of reports and dashboards for operations, finance, and manufacturing. Established automation scripts (Python + SQL) reducing manual work in data cleanup and reporting. Stable SQL Server health and backup processes documented and maintained. Internal expertise in ERP backend data flows with reduced reliance on vendor consultants. Accurate, reliable data pipelines across Salesforce, 2020, and S2K.
Manage and track the Key Performance Indicators (KPIs) Create and Build dashboards and Data Visualizations for key business functions Leverage technology and other IT tools Power BI, Etc for better Data Visualizations Improve data accuracy and reporting efficiency. Perform control checking between management finance systems and financial reports Ensure monthly management reporting is completed accurately and in time. Work closely with Clients in analyzing and reporting business performance reports Perform reconciliation processes between various management reports Support ad hoc reporting requirements with data and analysis Document and keep procedures for all reporting activities and tasks up to date Support the team tools/databases as well as reporting templates/models and macros Produce and interpret a detailed monthly reporting pack and present the financial position Identify and address issues which affect business performance. Preferred candidate profile