Task on SQL + BigQuery

Channel requirements: 1. Content language: Russian or Ukrainian (mixed RU/UA content is allowed) 2. Number of subscribers: At least 500 subscribers 3. Activity: The last post published no later than 32 hours ago 4. Comments: Comments must be open under the posts (through a group or embedded) 5. Quantity: Minimum 15,000 lines 6. Theme: War, news, politics, fights, trash/gore, sports, cars, crypto, fishing, and others Data to be collected for each channel Mandatory fields: Channel name username (link) Number of subscribers Theme (news, crypto, humor, business, etc.) Language (RU / UA / MIX) Date and time of the last post Presence of comments (yes) File format: Google Sheets / Excel (.xlsx)

We are looking for an experienced 1C developer who can not only perform individual tasks but also deeply understand our business processes, suggest improvements, and participate in the development of the system.What you will be doing: Analyzing existing processes in 1C and understanding the company's operational logic. Developing new functionality and enhancing existing features. Optimizing business processes and automating routine operations. Integrating 1C with the website, CRM, marketplaces, and other external services via API. Creating and refining processing, reports, documents, print forms, and data exchanges. Identifying bottlenecks in the system's operation and proposing ways to eliminate them. Participating in the design of new processes together with management and the team. Our expectations: Confident knowledge of the 1C:Enterprise 8 platform. Experience in developing and optimizing complex configurations. Understanding of the principles of business process automation. Experience in integrating 1C with external systems. Ability to independently analyze tasks and propose optimal solutions, not just execute technical assignments. Responsibility, initiative, and a desire to achieve results. It would be a big plus: Experience working with online stores and e-commerce. Experience integrating with payment systems, delivery services, and CRM. Knowledge of SQL, HTTP/API, XML/JSON. Experience with high-load systems. Work format: Remote work. Long-term cooperation. Workload as tasks arise with the prospect of ongoing work. Payment is discussed individually (hourly or per project). When responding, please indicate: Your experience with 1C. What major projects you have implemented. Examples of optimizations or automations you are particularly proud of. Your hourly rate or desired payment format. How many hours per week you are willing to dedicate to the project.

A separate CRM system needs to be developed for the centralized processing of all retail orders from various sales channels (Prom, Rozetka, own websites, and manual orders). Main requirements: A unified order registry from all sources, preserving information about the source and its status. A separate internal CRM status that operates independently of the status on the marketplace or website, with two-way synchronization of statuses where supported. Flexible integration with 1C: for each source, the administrator can separately enable or disable automatic order export. Integration with carriers for automatic creation of shipping documents, saving their numbers in the CRM, and transmitting the shipping document numbers to Prom and Rozetka. Integration with Checkbox for creating receipt projects, using customizable payment method matching, with subsequent fiscalization control. Support for manual order creation (phone, Viber, Telegram, Direct, etc.) with a complete subsequent processing cycle through the CRM. All API keys and integration settings must be managed by the administrator through the CRM interface without the involvement of a programmer. A complete action log and integration logging for system operation control. Main goal The manager must be able to fully process orders in one CRM interface — from receiving the order to creating a document in 1C, shipping document, receipt project, and completing the order, without the need to access the cabinets of Prom, Rozetka, websites, carriers, or Checkbox.

We have synchronization of two data sources with the CRM. The system as a whole is stable. However, there remains a part that becomes desynchronized. The main hypothesis is that in one of the sources, the data changes after the initial synchronization, and these changes are not always pulled into the CRM. + the data in the two sources have different names/identifiers even though they represent the same entities.

Task: deploy an LLM service that knows all the company's documentation and answers questions from the sales department managers. Current situation: the client has independently assembled a prototype (a separate project with uploaded company information, hosted on a server), but the information from the database is not transmitted to the model — likely, there is an issue with the API. We will provide the code and access. The first step is an audit: fix the existing setup or justifiably rebuild from scratch. Required functionality: Upload all company documentation: description of each service, regulations, FAQ, pricing (all materials will be provided). Answers strictly based on the uploaded documents (RAG). The model does not invent facts; if the answer is not in the database — it honestly informs about it. Access for managers via a link (web interface), with authorization. Scenarios: the manager asks any question about the company's work; inserts the client's question "as is" and receives a ready answer for sending; finds the necessary regulation/report by request. Knowledge base updates without a developer (uploading files through the interface or a connected folder). English language. History of requests for quality control. Technical expectations: LLM via API (Claude/OpenAI — propose with a cost calculation for tokens), RAG pipeline (vector database, embeddings), hosting on our server or in the cloud, HTTPS. The architecture should allow for future connection of the assistant to the analytical data warehouse (parallel project). In the response, indicate: examples of similar RAG projects, stack, timeline, cost of work, and estimated monthly ownership cost (tokens + hosting).