Data Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Create and oversee robust data pipelines.

• Enhance relational databases for better performance.

• Provide precise reporting models that aid business decisions in sales, finance, and operations.

• Compose, assess, and refine intricate SQL queries, stored procedures, and database architectures in MS SQL Server and MySQL.

• Construct, implement, and sustain ETL/ELT processes primarily utilizing SQL Server Integration Services (SSIS).

• Develop comprehensive data models, calculated columns, and measures using DAX and Power Query.

• Create, deploy, and maintain interactive Power BI reports and executive dashboards.

• Execute data validation, reconciliation testing, and root-cause analysis for data discrepancies.

• Offer operational support, performance optimization, and troubleshooting for databases that support internal business functions.

• Collaborate with software developers and non-technical stakeholders in Sales, Finance, and Contracts to translate requirements into scalable technical solutions.

⛳️ Requirements

• Strong expertise in MS SQL Server (T-SQL), encompassing complex queries, stored procedures, functions, and query performance enhancement.

• Good understanding of MySQL administration and query development.

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

• Capability to design complete data processing workflows from source systems to reporting layers.

• Proven experience in developing advanced reports and dashboards using Power BI.

• Proficient in data modeling within Power BI, including relationships, hierarchies, and schema design.

• Strong proficiency in DAX and Power Query.

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

• Familiarity with data validation and reconciliation testing.

• Ability to establish and implement data quality standards.

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

• Experience working in on-premises environments with SQL Server and MySQL.

• Exposure to DEV, TEST, and PROD development phases.

• Ability to work collaboratively with application development teams on database integrations.

• Skills in troubleshooting and performance tuning for database systems.

• Maintenance and operational support experience for databases used by business applications.

• Familiarity with BigQuery, including SQL and ETL processes in Google Cloud Platform (nice to have).

• Basic Python skills for data analysis (nice to have).

🏝️ Benefits

• Flexible remote work arrangement.