Logo
Rhode Island Staffing

Data Analyst

Rhode Island Staffing, Smithfield, Rhode Island, us, 02917

Save Job

Data Analyst

CGI is seeking to hire a seasoned Data Analyst who thrives in designing and optimizing scalable data solutions. In this role, you'll collaborate closely with Risk and Quantitative teams to build robust ETL/ELT pipelines, integrate diverse data sources, and support advanced analytics using Oracle PL/SQL, Python, and Snowflake. You'll play a key role in modernizing legacy systems, ensuring data integrity, and contributing to the development of data models that drive strategic insights. If you're passionate about data engineering, eager to solve complex challenges, and ready to make a meaningful impact, we invite you to apply and grow with us. This is a Full-Time employment opportunity based in Westlake TX or Smithfield, RI. Your future duties and responsibilities: Develop, optimize, and maintain scalable ETL/ELT pipelines using PL/SQL, Python, and Snowflake. Design and implement data integration solutions between various internal systems and external data sources. Collaborate with Risk and Quantitative teams to understand data needs related to risk pricing, exposure calculations, and performance metrics. Create and manage complex stored procedures, functions, and scripts in Oracle and Snowflake environments. Ensure data accuracy, completeness, and consistency across systems. Monitor data jobs and troubleshoot performance bottlenecks or failures. Assist in the migration of legacy systems to cloud-based platforms like Snowflake. Contribute to the development of data models that support analytics and reporting needs in the investment risk space. Follow best practices for data security, quality, and governance. Required qualifications to be successful in this role: 10+ years of software development experience Strong expertise in Oracle PL/SQL development. Hands-on experience with Snowflake writing SQL, managing data pipelines etc. Proficiency in Python for scripting, automation, and data manipulation. Solid understanding of ETL/ELT concepts and data integration workflows. Experience working with large datasets and complex data models. Ability to troubleshoot and optimize SQL queries for performance. Strong communication and documentation skills. Excellent problem-solving skills and attention to detail. Excellent communication and interpersonal skills. Ability to work independently and in a team-oriented environment. Education: Bachelor's degree in computer science or related field Compensation: A reasonable estimate of the current range for this role in the U.S. is $86,200.00 - $156,800.00. CGI's benefits are offered to eligible professionals on their first day of employment to include: competitive compensation, comprehensive insurance options, matching contributions through the 401(k) plan and the share purchase plan, paid time off for vacation, holidays, and sick time, paid parental leave, learning opportunities and tuition assistance, wellness and well-being programs. Skills: ETL, Python, Snowflake, SQL What you can expect from us: Together, as owners, let's turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction. Your work creates value. You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise. You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons. Come join our teamone of the largest IT and business consulting services firms in the world.