Senior SQL & ETL Developer (Finance)
JOB DESCRIPTION
We are seeking an experienced SQL and ETL Developer with over 7 years of experience to join our dynamic team. The ideal candidate will be responsible for designing, developing, and maintaining SQL databases and Extract Transform Load (ETL) jobs, ensuring data integrity, and optimizing performance. You will work closely with data analysts, data scientists, and other stakeholders to support data-driven decision-making within the organization.
Key Responsibilities:
- Design, develop, and maintain SQL databases and data models.
- Write complex SQL queries for data extraction, transformation, and loading (ETL).
- Optimize SQL queries and database performance.
- Ensure data integrity and security across all databases.
- Collaborate with cross-functional teams to gather requirements and provide data solutions.
- Troubleshoot and resolve database issues and performance bottlenecks.
- Create and maintain documentation for database designs, processes, and procedures.
- Work with cross-functional teams to understand business requirements and translate them into technical specifications.
- Ability to work independently and Support Team members in a team-oriented, collaborative environment
- Stay updated with the latest industry trends and technologies related to SQL and database management.
- 7+ years of experience in SQL development and database management.
- Proficiency in writing complex SQL queries, stored procedures, and functions.
- Strong understanding of database design principles and data modeling.
- Experience with performance tuning and optimization of SQL queries.
- Experience with Microsoft SQL Server 16 and above versions, and Azure SQL Database.
- Experience with development of ETL jobs in SSIS
- Knowledge of ETL processes and tools.
- Experience with data warehousing concepts and practices.
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Experience with cloud-based database solutions (e.g., Azure SQL Database, Azure Synapse, Snowflake).
- Experience with Informatica Intelligent Cloud Services (IICS)
- Experience with data visualization tools (e.g., Power BI).
- Knowledge of programming languages such as Python, or Java.
- Knowledge of .Net programming.
- Understanding of data governance and compliance standards.
- Familiarity with Agile methodologies and project management tools.
- Familiarity with NoSQL databases (e.g., MongoDB, Cassandra).
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
ABOUT US
OUR BENEFITS
As a Chubb corporate employee, you have access to one of the most comprehensive benefit plans in the business, designed to meet your needs and help you reach your financial goals. More details can be found here. Chubb is committed to supporting its employees with a comprehensive compensation package that is appropriate in the market where they work. Below are several of the many benefits we offer our employees:
- Health insurance
- Dental insurance
- Tuition reimbursement
- A company-match 401(k) plan
- Disability insurance
- Life insurance
- Employee referral bonuses
ABOUT COMBINED INSURANCE
Combined Insurance Company of America is a Chubb company and a leading provider of supplemental accident, health, disability, and life insurance products in North America. Headquartered in Chicago, with satellite office in Columbia, SC, Combined is celebrating over 100 years in business. We are committed to making the world of supplemental insurance easy to access and understand. The company has an A+ rating by the Better Business Bureau and an A + (Superior) financial strength rating by A.M. Best. We are ranked by VIQTORY as the number one Military Friendly® Employer in 2023 (over $1 billion revenue category), marking Combined's twelfth consecutive year on the Top 10 list. We pride ourselves on approaching all situations with a Positive Mental Attitude (PMA) and encouraging collaboration.
ABOUT CHUBB
Chubb is a world leader in insurance. With operations in 54 countries, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance, and life insurance to a diverse group of clients. The company is distinguished by its extensive product and service offerings, broad distribution capabilities, exceptional financial strength, underwriting excellence, superior claims handling expertise and local operations globally.
Connect with us on Twitter, Facebook, LinkedIn, and Instagram
#combined
