Data Engineer

Job Description:

• Gather and analyze user requirements and requests in detail, and design appropriate technical solutions to address those requirements.
• Develop, test, and monitor approved solutions before delivering them to end users.
• Develop and maintain data pipelines from source systems to the data warehouse using SSIS (or similar ETL tools), and build data marts to support the company's reporting and dashboard requirements.
• Troubleshoot issues within existing data pipelines and document identified problems along with their resolutions.
• Manage data quality processes, including data validation, cleansing, and monitoring to ensure data accuracy, consistency, and completeness.
• Optimize data pipeline performance and SQL queries to improve data processing efficiency.
• Support the implementation of Data Governance practices, including metadata management, data catalog maintenance, and adherence to enterprise data standards.
• Actively participate as a technical support member in solution development projects involving third-party vendors or partners.
• Follow and comply with the organization's Software Development Life Cycle (SDLC) processes and standards.
• Serve as the first-level support for data pipeline-related issues and incidents.
• Participate in strategic planning initiatives related to data engineering and analytics.
• Prepare and maintain comprehensive project documentation and other related technical documents.
• Provide recommendations and continuous improvements for policies, guidelines, and operational procedures.
• Perform data analysis to generate actionable insights and recommendations that support business decision-making.
• Develop dashboards, data visualizations, and analytical reports using Tableau or other Business Intelligence (BI) tools, including designing informative and interactive dashboards to support business monitoring and decision-making.
• Validate and interpret data analysis results, and present findings through clear and effective reports or presentations.
• Evaluate dashboard performance and continuously improve dashboards and visualizations based on user feedback and business requirements.

Requirements

• :Bachelor's Degree (S1) in Information Technology, Computer Engineering, Computer Science, or a related field
• .Candidates with at least 3 years of experience in Data Engineering projects or activities within the financial services industry or a similar sector are also encouraged to apply
• .Strong understanding of the Software Development Life Cycle (SDLC)
• .Proficient in Microsoft SQL Server, Oracle SQL, and PL/SQL
• .Hands-on experience with Data Integration tools, particularly SQL Server Integration Services (SSIS). Experience with Talend or Pentaho is considered an advantage
• .Proficient in Business Intelligence (BI) tools, especially Tableau. Experience with other BI platforms such as Qlik Sense or Power BI is an advantage. Ability to perform data analysis and develop informative, interactive analytical dashboards to support business needs
• .Strong teamwork and effective communication skills
• .Proficient in Microsoft Office Suite, including Microsoft Word, Excel, and PowerPoint
• .Strong analytical thinking and problem-solving skills
• .Ability to create mock-ups, data pipelines, Entity Relationship Diagrams (ERD), and Star Schema models
• .Detail-oriented with a high level of accuracy
• .Quality-oriented with a strong commitment to delivering high-quality results
• .Ability to prepare and maintain comprehensive project and data documentation