Chubb Benefits is seeking a Senior SQL & ETL Lead Developer to join our fast-paced, high energy, growing company. We are proud of our tradition of success in the insurance industry of over 100 years. Come join our team of hard-working, talented professionals!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:Work with cross-functional teams to understand business requirements and translate them into technical specifications.Plan and manage project delivery scope, sprint planning, task assignment to developers and tracking completion.Create and maintain documentation for database designs, processes, and procedures, as defined by CHUBB engineering and architecture.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.Troubleshoot and resolve database issues and performance bottlenecks.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.Must-Have Skills:7+ years of experience in SQL development and database management.Excellent communication and collaboration skills.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 SSISKnowledge of ETL processes and tools.Experience with data warehousing concepts and practices.Strong analytical and problem-solving skills.Nice-to-Have 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).Education:Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).Office Location: 8750 W. Bryn Mawr Avenue Chicago, Illinois (Near Rosemont) In-Office Expectation: 4 days in office, 1 day remoteThe pay range for the role is $122,000 to $178,000. The specific offer will depend on an applicant’s skills and other factors. This role may also be eligible to participate in a discretionary annual incentive program. Chubb offers a comprehensive benefits package, more details on which can be found on our careers website. The disclosed pay range estimate may be adjusted for the applicable geographic differential for the location in which the position is filled."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 insuranceDental insuranceTuition reimbursementA company-match 401(k) planDisability insuranceLife insuranceEmployee referral bonuses
We are seeking a motivated and energetic Prep/Line Cook to join our dynamic culinary team! In this vital role, you will be responsible for preparing high-quality ingredients and dishes in a fast-paced environment, ensuring every plate meets our standards of excellence. ...
...Position Purpose: Food and food service delivery Drivers fulfill a critical role in the countrys food... ...relationships with our customers! The Driver, Formula CDL-B is responsible for driving a tractor trailer or straight truck on intrastate and interstate local, over-the-road...
...Job Description Job Description Swimming Pool Service Technician - $2528/hr + Bonuses + PTO (Los Feliz /Hollywood Hills / Hollywood... ...support to help you succeed. JOB RESPONSIBILITIES: Weekly maintenance of residential swimming pools Testing and balancing...
...experiences? Look no further! Moseys RoadHouse is seeking a talented Chef to join our team in Beach Lake, PA. As a Chef at our restaurant and bar, you will have the opportunity to showcase your culinary skills and contribute to our vibrant and dynamic kitchen environment...
...established health system, a major teaching hospital, and one of the nation's 100 Top Hospitals* has an excellent opportunity for a Nocturnist to join our dedicated team of physicians providing outstanding care at St. Luke's University Health Network. *Department...