Support Data Engineer

Key Accountabilities and main responsibilities

Strategic Focus

• Timely, efficient, and high-quality investigation and resolution of high impact issues to ensure smooth ongoing operation of the Data and Analytics reporting systems.
• Monitor, maintain, and optimize data pipelines to ensure consistent data flow and processing.
• Identify and resolve bottlenecks or inefficiencies in existing data pipelines.
• Diagnose and resolve data-related issues, such as failed jobs, data inconsistencies, or performance degradation.

Operational Management

• Investigate bugs, root cause analysis, tune queries and perform peer review.
• Document investigations and solutions and maintain operational runbooks for common situations and tasks
• Provide timely support and technical guidance during incident triage by identifying the impact of failures and bugs.
• Proactively track the health and performance of data systems and pipelines
• Proactively identify potential issues and address them before they impact production.
• Work closely with data engineers, data scientists, and other stakeholders to understand data requirements and ensure accurate and timely data availability.
• Collaborate with development teams to implement improvements and updates to data systems.

Governance & Risk

• Ensure timely completion of activities by adhering with the agreed processes & quality standards.
• Individual should adhere to data design best practices.
• Adhere to MUFG s standards, policies, and procedures.
• Follow and identify improvements in team s procedures.
• The above list of key accountabilities is not an exhaustive list and may change from time-to-time based on business needs.

Experience & Personal Attributes

Experience

• Overall, 7-10 years of development experience in Visual Studio including SSIS, SSRS, and SSDT
• 5+ years experience writing and tuning SQL queries using SQL Server
• Strong understanding of Data Warehousing processes and concepts.
• Experience creating and maintaining reports through SSRS.
• Experience using the following applications is desirable: Control-M, Jira, ServiceNow and Azure DevOps

Personal Attributes

• Effective verbal and written communication skills, needed to communicate with global teams/stakeholders.
• Practical and simple problem-solving approach to provide timely, practical, and robust solutions
• Effective Team player with collaborative skills, learning and proactive attitude.
• Quality orientation with attention to detail.
• Commitment to continuous improvement.
• Collaborate and share knowledge with other members of the team to ensure we are always evolving our collective skills and staying on the cutting-edge.
• Effectively communicate complex technical concepts to non-technical stakeholders and collaborate closely to understand evolving business requirements.