Key Responsibilities:
- ETL Development and Maintenance:
- Design develop and implement ETL processes using SSIS to support data integration and warehousing requirements.
- Maintain and enhance existing ETL workflows to ensure data accuracy and integrity.
- Collaborate with data analysts data architects and other stakeholders to understand data requirements and translate them into technical specifications.
- Extract transform and load data from various source systems into the data warehouse.
- Perform data profiling validation and cleansing to ensure high data quality.
- Monitor ETL processes to ensure timely and accurate data loads.
- Write and optimize complex SQL queries to extract and manipulate data.
- Work with SQL Server to manage database objects indexes and performance tuning.
- Ensure data security and compliance with industry standards and regulations.
- Business Intelligence and Reporting:
- Develop and maintain interactive dashboards and reports using Power BI or SSRS.
- Collaborate with business users to gather requirements and create visualizations that provide actionable insights.
- Integrate Power BI with other data sources and platforms for comprehensive reporting.
- Scripting and Automation:
- Utilize Python for data manipulation automation and integration tasks.
- Develop scripts to automate repetitive tasks and improve efficiency.
- Insurance Domain Expertise:
- Leverage knowledge of insurance industry processes and terminology to effectively manage and interpret insurance data.
- Work closely with business users and stakeholders within the insurance domain to understand their data needs and provide solutions.
Qualifications :
Required Skills and Qualifications:
Technical Skills: Proficient in SQL and experience with SQL Server. Strong experience with SSIS for ETL development and data integration.
Proficiency in Python for data manipulation and scripting.
Experience with Power BI/SSRS for developing interactive dashboards and reports.
Knowledge of data warehousing concepts and best practices.
Domain Knowledge: Solid understanding of insurance industry processes terminology and data structures.
Experience working with insurance-related data such as policies claims underwriting and actuarial data.
Additional Skills:
Strong problem-solving and analytical skills.
Excellent communication and collaboration abilities.
Remote Work :
No
Employment Type :
Full-time