Senior Data Engineer

Nauchsoft is an international IT consulting and software development company. We have been in the IT business for 36 years and continue growing. We are looking for a Senior Data Engineer to take the lead in designing, evaluating, and evolving the core data model that underpins the Accounting Module of a globally distributed ERP system. This role is prospective and has been created in line with the company’s planned team expansion.

Responsibilities:

• Data Modeling Leadership:
  • Architect the canonical data model for the Accounting module within a distributed, multi-tenant ERP ecosystem;
  • Define normalized and denormalized schema layers for OLTP + OLAP hybrid performance models;
  • Align the model with key accounting domain concepts such as journal entries, GL, sub-ledgers, tax, reconciliation, cash flow, and regulatory reporting.
• Scalable Database Design (Aurora PostgreSQL):
  • Design for performance, partitioning, and high-concurrency read/write patterns in Aurora PostgreSQL;
  • Apply best practices in indexing, foreign key constraints, and transaction modeling for financial accuracy and auditability.
• Reporting & Analytics Integration:
  • Ensure the model supports real-time and batch reporting for financial dashboards, KPIs, and compliance (e.g., GAAP/IFRS);
  • Collaborate with data analysts to define materialized views, reporting schemas, and BI interfaces.
• LLM/ML Integration Enablement:
  • Design semantic layers and metadata structures to support prompt engineering, data retrieval, and context grounding for downstream LLM integrations;
  • Ensure the model supports vectorized features, if applicable, for semantic financial search and AI-driven classification.
• Evaluation & Continuous Optimization:
  • Establish data model evaluation criteria including query performance, correctness, integrity, and change impact;
  • Lead or support data model reviews, A/B schema tests, and versioned model evolution over time.
• Cross-Functional Collaboration:
  • Work closely with product managers, financial domain experts, backend engineers, and data scientists to convert complex functional requirements into robust data structures;
  • Serve as the technical steward for the Accounting data domain, ensuring long-term model maintainability.

Requirements:

• 6+ years of experience in data engineering or data architecture, preferably within SaaS ERP or FinTech platforms;
• Proven expertise in PostgreSQL/Aurora PostgreSQL at scale, including performance tuning, partitioning, and data lifecycle management;
• Demonstrated success in data modeling for accounting or financial systems;
• Deep understanding of OLTP vs OLAP separation, data warehousing principles, and event-sourced or time-series design patterns;
• Familiarity with compliance and audit requirements for financial data (e.g., SOX, GAAP).

We offer:

• Opportunity for professional self-realization and growth;
• Friendly team;
• 25-days of paid vacation;
• Medical insurance and 100% payment for sick leave;
• Professional training and obtaining certificates at the company's expense;
• Foreign language courses and other corporate programs;
• A variety of corporate events;
• Bonuses in case of wedding or a child’s birth;
• The possibility of remote work from any location.