Infovision is a global it services company dedicated to providing innovative solutions that drive digital transformation and enhance operational efficiency. We foster a collaborative environment that empowers our teams to grow, while working on impactful projects with leading clients.
role overview
we are seeking a highly skilled senior sql developer to design, optimize, and maintain critical data solutions. This role is pivotal in bridging core insurance systems with analytics platforms, ensuring that policy, claims, and underwriting data are accurate, efficient, and accessible for strategic decision‑making.
key responsibilities
1. Advanced sql development & performance engineering
* develop, optimize, and maintain complex sql queries, stored procedures, and high‑performance database objects.
* execute etl processes (extraction, transformation, and loading) using sql‑based pipelines to ensure seamless data flow.
* maximize database performance through proactive query tuning, advanced indexing strategies, and execution plan analysis.
* ensure data integrity and consistency across multiple core systems and analytics platforms.
* manage large‑scale structured datasets, specifically focusing on underwriting, claims, policy, and billing data.
* design and document scalable data models, database schemas, and technical specifications.
* collaborate on data integration between legacy systems, data warehouses, and modern cloud data platforms.
3. Analytics & business stakeholder support
* provision optimized datasets for actuarial, claims analytics, and operational reporting teams.
* support bi tools and dashboards by ensuring accurate transformation logic and high data availability.
* partner with business analysts and stakeholders to translate complex business requirements into technical data solutions.
required qualifications
technical expertise
* experience: 5+ years of hands‑on sql development in large‑scale enterprise environments.
* rdbms mastery: strong experience with sql server, postgresql, oracle, or similar relational databases.
* advanced sql: expert‑level knowledge of complex joins, window functions, ctes, and query optimization.
* database programming: proficient in creating robust stored procedures, triggers, and views.
* modeling: solid understanding of data modeling, normalization, and data warehousing concepts.
domain & industry experience
* insurance sector: strong experience with insurance data (claims, policy, underwriting, billing) is highly preferred.
* methodology: proven experience working within agile development processes and sprint cycles.
preferred & nice‑to‑have skills
* insurance platforms: experience with duck creek or other core insurance platforms.
* cloud platforms: exposure to snowflake, azure, aws, or gcp data environments.
* data engineering: familiarity with python, pyspark, or modern etl orchestration tools.
* visualization: experience supporting bi tools such as power bi, tableau, or looker.
* compliance: knowledge of data governance and regulatory reporting requirements in the insurance industry.
soft skills
* problem solving: exceptional analytical skills to resolve complex data logic issues.
* communication: excellent documentation skills and the ability to explain technical concepts to non‑technical teams.
* global collaboration: ability to work effectively in distributed offshore/onshore team structures.
what we offer
competitive salary & benefits – including attractive legal and above-the‑law perks.
collaborative, innovative work environment.
career growth opportunities & skill development.
flexible remote work options.
ready to take the next step in your career and join a dynamic, forward‑thinking team? Apply today!
contact
abdi.bernal@infovision.com
* the position is not eligible for employment‑based visa/immigration sponsorship.
#j-18808-ljbffr