BI Data Engineer

Nauchsoft is an IT consulting and software development company. We have been in the IT business for 36 years and continue growing.

The ideal candidate will have hands-on experience in ETL/ELT, data warehouse design, and query performance optimization, along with a solid foundation in BI development and data engineering practices. The candidate will play a key role in building scalable data solutions and delivering actionable insights to business stakeholders.

Responsibilities:

• Design and optimize data warehouse (DWH) architectures, including dimensional models (star/snowflake schemas), staging layers, and data marts to support scalable analytics.

• Analyze and fine-tune SQL queries, indexes, and execution plans to maximize performance and efficiency.

• Build and maintain robust ETL/ELT pipelines for extracting, transforming, and loading data from diverse sources.

• Administer and enhance relational and non-relational databases using SQL and modern database tools.

• Integrate and reconcile data from multiple systems, ensuring accuracy, consistency, and reliability.

• Develop and maintain high-performing, user-friendly BI dashboards using tools such as Power BI.

• Implement rigorous data quality controls, validation rules, and cleansing processes to maintain integrity across datasets.

• Utilize cloud platforms (AWS, Azure, or GCP) to enable scalable, high-availability data storage and processing solutions.

• Collaborate cross-functionally with analysts, data scientists, and business stakeholders to understand requirements and deliver actionable insights.

Requirements:

• Education & Background: Bachelor’s degree in Computer Science, Information Systems, or a related field.

• Professional Experience: 4–5 years of hands-on experience in data engineering, BI development, or report migration projects.

• Technical Skills:

  • Proficiency in Python and SQL; Java or Scala is a plus.

  • Strong expertise in Power BI, including DAX, Power Query (M language), and dashboard performance optimization.

  • Familiarity with data orchestration tools such as Apache Spark, Airflow, or Talend.

  • Experience designing efficient data structures for analytics and reporting.

  • Practical experience with cloud data services such as Amazon Redshift, BigQuery, or Azure Synapse.

  • Proficiency in Git for collaborative development and version control.

• Soft Skills:

  • Ability to clearly explain technical concepts to non-technical stakeholders.

  • Strong analytical mindset with the ability to troubleshoot and optimize data systems.

  • Proven ability to work effectively in cross-functional teams and mentor junior engineers.

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.