Data Engineer (MS Access)

Job description

Role Overview: • Design and develop efficient database structures, queries, and reports tailored to business needs • Manage and maintain MS Access databases focused on reinsurance data to ensure data accuracy and integrity • Extract, clean, and manipulate complex reinsurance datasets for accurate analysis and reporting • Structure analytical solution to address business objectives and problem solving • Develop long-lasting, trusted consulting relationships with clients • Able to work in dual shore engagement across multiple time zones • Manage day-to-day project operations, serve as the functional and domain expert on the project team to ensure they meet client expectations • Provide quality oversight on deliverables prepared by the project team before submitting to client Responsibilities: • Design, develop, and maintain MS Access databases to support reinsurance data storage, processing, and reporting needs. • Extract, clean, and manipulate large sets of reinsurance data for reporting and analysis. • Create, automate, and manage complex queries, forms, and reports within MS Access. • Collaborate with actuarial, underwriting, and finance teams to understand data requirements and deliver actionable insights. • Troubleshoot database issues and optimize performance for large datasets. • Develop and maintain documentation on database structures, workflows, and reporting processes. • Support and enhance data quality controls and data integrity processes. • Build and maintain dashboards and visual reports; familiarity with Power BI to create interactive and insightful reports is highly desirable. • Work closely with IT and business stakeholders to implement improvements in data management and reporting workflows. • Stay updated with best practices in database management and reporting technologies. Candidate Profile: • Proven experience (5+ years) managing MS Access databases, preferably in the insurance or reinsurance industry. • Bachelor’s/master's degree in computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply • Strong MS Access and SQL skills for database automation and reporting within MS Access & Power BI • Experience handling complex data sets, data cleaning, and transformation • Proficiency in Power BI or other data visualization tools is a strong plus • Good understanding of insurance/reinsurance data and terminology preferred • Strong analytical, problem-solving, and communication skills • Ability to work independently and collaborate effectively with cross-functional teams. • Outstanding written and verbal communication skills • Able to work in fast pace continuously evolving environment and ready to take up uphill challenges • Is able to understand cross cultural differences and can work with clients across the globe. What we offer: • EXL Analytics offers an exciting, fast paced and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions. From your very first day, you get an opportunity to work closely with highly experienced, world class analytics consultants. • You can expect to learn many aspects of businesses that our clients engage in. You will also learn effective teamwork and time-management skills - key aspects for personal and professional growth • Analytics requires different skill sets at different levels within the organization. At EXL Analytics, we invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques. • We provide guidance/ coaching to every employee through our mentoring program wherein every junior level employee is assigned a senior level professional as advisors. • Sky is the limit for our team members. The unique experiences gathered at EXL Analytics sets the stage for further growth and development in our company and beyond.