Data Engineer

This is a remote position.

We are looking for a skilled and proactive Data Engineer to strengthen our data team. In this role, you will be responsible for designing and maintaining robust data pipelines, optimizing relational databases, and delivering accurate reporting models that support key business decisions across sales, finance, and operations.

If you have a strong background in SQL, hands-on experience with SSIS, and a solid understanding of Power BI and data modeling, this role offers an opportunity to work end-to-end across database architecture and business intelligence.

Key Responsibilities

• Database Optimization & Development: Write, review, and optimize complex SQL queries, stored procedures, and database structures in MS SQL Server and MySQL.

• ETL Pipeline Design: Build, deploy, and maintain reliable ETL/ELT processes primarily using SQL Server Integration Services (SSIS).

• Data Modeling & BI: Build end-to-end data models, custom calculated columns, and measures using DAX and Power Query to support business analytics.

• Reporting & Dashboards: Develop, deploy, and maintain insightful, interactive reports and executive dashboards in Power BI.

• Data Quality & Governance: Conduct data validation, reconciliation testing, and root-cause analysis for data discrepancies to ensure high data integrity.

• Application & Database Support: Provide operational support, performance tuning, and troubleshooting for databases backing internal business applications.

• Cross-Functional Collaboration: Partner closely with software developers and non-technical business stakeholders (Sales, Finance, Contracts) to translate functional requirements into scalable technical solutions.

Requirements

• Strong experience with MS SQL Server (T-SQL) - writing complex queries, stored procedures, functions, and query performance optimization.

• Good knowledge of MySQL in terms of administration and query development.

• Experience in building and maintaining ETL processes, particularly using SQL Server Integration Services (SSIS).

• Ability to design end-to-end data processing workflows, from source systems to reporting layers.

• Development of advanced reports and dashboards in Power BI.

• Data modeling in Power BI (relationships, hierarchies, and schema design).

• Proficiency in DAX and Power Query.

• Experience in publishing reports and managing Power BI workspaces, including access control and security settings.

• Experience in data validation and reconciliation testing.

• Ability to define and implement data quality rules.

• Competence in identifying and analyzing business data discrepancies and errors.

• Experience working in on-premises environments (SQL Server, MySQL).

• Experience working across all development stages (DEV, TEST, PROD).

• Ability to collaborate effectively with application development teams on database integrations.

• Troubleshooting and performance tuning for database systems.

• Maintenance and operational support of databases used by business applications.

Nice to have:

• Experience with BigQuery (SQL, ETL processes in Google Cloud Platform).

• Basic knowledge of Python for data analysis.