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.
