Create and manage multiple databases and assist in capacity planning.
Monitor, maintain database systems and troubleshoot problems that may arise
Maintain data integrity and security (manage roles and permissions of database users
Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
Assist in developing strategies and implementing solutions for managing back-ups, restoration and replication.
Identify the potential risk of database software and work towards minimizing those risks.
Provide first level of support for any database related issues raised by team members.
Identify database framework gaps and design solution to fix the gaps and enhance the framework.
Support software developers with database operations including the development of complex SQL, tuning of DML, the creation of stored procedures and adopt new features provided by newer database versions.
Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
Mentor and monitor juniors on database related tasks to improve team efficiency.
Conduct regular code review of team members.
Research and learn relevant business processes and understand the data flow, criticality and dependencies.
Create detailed documentation including diagrams of database infrastructure.
Take ownership of projects for its timely delivery including (but not limited to) planning, estimation, development approach, assignment, reporting etc.
Involve in performance evaluation of team members.
Living Hitachi Energy’s core values of safety and integrity, which means taking responsibility for your own actions while caring for your colleagues and the business.
Required Knowledge, Skills, and Abilities:
Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
As a Senior Data Engineer, where your expertise in data engineering and data analytics will be pivotal in transforming the insurance industry. This hands-on role requires a combination of technical proficiency, effective communication, and strategic thinking.
Your responsibilities will include:
Engaging with business stakeholders to understand and define business requirements, ensuring that data solutions are aligned with business goals.
Leading the design, development, and implementation of data warehousing and data cataloging solutions, ensuring they effectively support data storage and retrieval needs.
Developing and optimizing data pipelines and ETL processes to ensure efficient and reliable data flow from various sources into the data warehouse.
Creating and maintaining BI dashboards using Tableau, focusing on the accurate representation of key insurance industry metrics and insights.
Managing the ongoing maintenance and monitoring of data infrastructure to ensure high performance, reliability, and scalability.
Proactively identifying and addressing data quality issues, implementing strategies and tools to ensure data accuracy and consistency across the organization.
Developing data quality metrics and conducting regular data audits and manual investigations to validate data integrity and compliance with quality standards.
Required Knowledge, Skills, and Abilities:
Comprehensive experience in large-scale data systems with relational databases and NoSQL technology on the public cloud (e.g., PostgreSQL, MySQL, MongoDB, etc.)
Proficiency in coding languages such as Python and SQL.
Extensive experience in designing and deploying data solutions using AWS services like Redshift, Appflow, and Airflow DAG.
Familiarity with data pipeline and transformation tools like DBT.
Deep experience with BI tools, specifically Tableau, and the ability to work with stakeholders to understand and implement KPIs and metrics.
Experience with ETL, ELT, and other data processing methodologies.
A proven track record of operationalizing data systems for scalability, reliability, and performance.
Solid understanding of PII standards, processes, and security protocols.
Comprehensive understanding of P&C insurance data models, ACORD standards, and OMG standards.
Experience with Salesforce (desirable).
Education + Experience:
Minimum of 5 years in data engineering roles, with a hands-on approach.
Interested candidates fulfilling the mentioned criteria are encouraged to Apply using the Easy Apply Button below. Registered candidates may also apply using Apply Now Button.