Senior Data Engineer

Overview:

As a Data Engineer at Wyzet, you will play a crucial role in developing and maintaining our data architecture, pipelines, and databases. Your work will directly impact our ability to analyze trends, optimize operations, and enhance customer experiences. You’ll collaborate with cross-functional teams to support data-driven decision-making, ensuring the integrity, accessibility and scalability of our data systems.

Key Responsibilities:

Data Integration and ETL: Design, implement, and optimize data pipelines preferably using Microsoft ETL tools (e.g., Azure Data Factory, SQL Server Integration Services) to ensure efficient data extraction, transformation, and loading processes. Extract and integrate data from diverse sources, including ERP systems, CRM databases, and other enterprise applications, to ensure comprehensive data availability for analytics and reporting purposes.

Data Modeling: Create and maintain data models, ensuring data is organized, structured, and easily accessible for reporting and analytics.

Data Warehousing: Manage and enhance our data warehouse using Microsoft Synapse (formerly Azure SQL Data Warehouse) to provide scalable and high-performance data storage solutions.

Dashboard Development: Develop interactive and insightful dashboards and reports using Power BI to enable data visualization and self-service analytics.

Performance Tuning: Monitor and optimize database and ETL processes for maximum efficiency and performance.

Data Quality Assurance: Implement data quality checks, validation rules, and data profiling to maintain data accuracy and integrity.

Documentation: Create detailed documentation for data engineering processes, data models, and ETL workflows.

Collaboration: Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand their data requirements and deliver solutions accordingly.

Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field.
• Proven experience as a Data Engineer with a focus on Microsoft BI Stack, Synapse, and Power BI (minimum 5 years of full-time experience using the tools).
• Strong proficiency in Microsoft ETL tools such as Azure Data Factory and SQL Server Integration Services.
• In-depth knowledge of Microsoft Synapse or Data Fabric and data warehousing concepts.
• Proficiency in creating interactive dashboards and reports using Power BI.
• Strong SQL and T-SQL skills for data manipulation and querying.
• Experience with data modeling and database design.
• Familiarity with data quality assurance practices.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Ability to work in a fast-paced, dynamic environment.

Preferred Qualifications:

• Microsoft Certified: Azure Data Engineer Associate certification.
• Knowledge of accounting, supply chain or manufacturing.