Data Engineer

Job Description

We are looking for a Data Engineer to join our team. They will be responsible for creating scalable data solutions to support data-intensive applications and analytics. This includes not only the technical development of data pipelines and reports but also overseeing data engineering projects and contributing to the strategic direction of data initiatives within the organization.

Requirements

Technical Solution Development

Translate business requirements into technical data solutions.

Participate in and contribute to architectural forums within the Business Intelligence (BI) team.

Design and implement ETL/data pipeline architectures using tools like ADF (Azure data factory).

Automate processes and design system architectures.

Develop and manage Power BI semantic models, including understanding DAX queries and cubes.

Visualization and Dash boarding: translate metrics into visual Power BI reports

Integrate data between legacy and modern systems.

Create ad-hoc SQL scripts to support user queries.

Deploy and manage data solutions on cloud platforms like Azure.

Data Modeling and Management

Understanding of Data Warehouse modeling and Techniques: Data schemas, Facts, dimensions and building data warehouses.

Writing complex SQL queries, joins, views and stored procedures to extract and manipulate data.

Apply knowledge and practical experience in the Data Warehouse Life Cycle.

Perform data modeling including dimensional, multi-dimensional, and relational models.

Utilize TSQL for database management and querying.

Support batch processing and scheduling tasks.

Documentation and Support

Create and maintain technical documentation such as data architecture diagrams, ETL workflows, and system documentation to ensure maintainability.

Participate in design, peer, and code reviews.

Provide daily technical, functional, and operational support for existing BI solutions.

Monitoring and Optimization

Monitor data pipeline and infrastructure performance.

Identify bottlenecks and optimize for scalability, reliability, and cost-efficiency.

Troubleshoot and resolve data-related issues.

Strategic and Emerging Technology Contributions

Contribute to evolving the architecture towards modern platforms, whether on-premise or cloud-based.

Maintain working knowledge of Power BI reporting....