Middle Data Engineer

Компания "Научсофт"

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

We are expanding our team and looking for a Middle Data Engineer.

Requirements:

1.Technical Skills

• Crystal Reports: Strong understanding of report structures, formulas, and data sources.
• SSRS: Proficiency in designing, deploying, and managing SSRS reports.
• SQL Server: Advanced SQL skills, including stored procedures, views, and functions.
• ETL Tools: Familiarity with SSIS or other ETL platforms.
• Data Modeling: Understanding of relational databases and data warehouse concepts.
• English proficiency at B1+/B2+ level (spoken and written) for documentation, collaboration, and stakeholder communication.

2. Migration Experience

• Hands-on experience converting Crystal Reports to SSRS.
• Ability to analyze existing Crystal Reports logic and replicate it in SSRS.
• Knowledge of differences in formatting, parameters, and data handling between platforms.

3. Soft Skills

• Strong analytical and problem-solving abilities.
• Good communication skills to work with stakeholders and document requirements.
• Attention to detail for validating report accuracy post-migration.

Key Responsibilities:

Design and Develop Reports

• Create, maintain, and optimize SSRS reports based on business requirements.
• Collaborate with stakeholders to gather reporting needs and translate them into technical specifications.
• Ensure reports are visually clear, accurate, and performance-optimized.

Migrate Crystal Reports to SSRS

• Analyze existing Crystal Reports and convert them to SSRS while preserving functionality and layout.
• Identify and resolve compatibility issues during migration.
• Document migration processes and maintain version control.

Manage Data Sources and Datasets

• Configure and maintain shared data sources and datasets for reporting solutions.
• Ensure secure, efficient, and reliable access to data.
• Optimize queries and data models to support reporting needs.

Report Testing and Validation

• Perform unit, integration, and user acceptance testing (UAT) on reports and ETL processes.
• Validate data accuracy and consistency across reports.
• Work with QA and business teams to resolve discrepancies and ensure quality.

Documentation and Support

• Maintain technical documentation for reports, ETL processes, and data flows.
• Provide support and training to end-users on report usage and interpretation.
• Troubleshoot and resolve issues related to reporting and data delivery.

Query Performance Tuning

• Analyze and optimize SQL queries, indexes, and execution plans to ensure efficient data retrieval.

Nice to Have:

• Experience with Power BI or other modern BI tools.
• Familiarity with version control systems (e.g., Git).
• Knowledge of report scheduling and automation.
• Experience with Azure Data Factory for orchestrating data pipelines.
• Knowledge of Azure SQL Database and Azure Synapse Analytics.
• Familiarity with Azure Blob Storage and Data Lake for handling large datasets.
• Understanding of Azure DevOps for CI/CD pipelines and version control.
• Experience with Azure Monitor or Log Analytics for performance and diagnostics.

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.