What are the responsibilities and job description for the Senior Data Engineer position at Blue Cross & Blue Shield of Rhode Island?
Pay Range: $98,100.00 - $163,400.00 Please email HR_Talent_AcquisitionTeam@bcbsri.org if you are a candidate seeking a reasonable accommodation for the application and/or interview process. At BCBSRI, our greatest resource is our people. We come from varying backgrounds, different cultures, and unique experiences. We are hard-working, caring, and creative individuals who collaborate, support one another, and grow together. Passion, empathy, and understanding are at the forefront of everything we do—not just for our members, but for our employees as well. We recognize that to do your best work, you have to be your best self. It’s why we offer flexible work arrangements that include remote and hybrid opportunities and paid time off. We provide tuition reimbursement and assist with student-loan repayment. We offer health, dental, and vision insurance as well as programs that support your mental health and well-being. We pay competitively, offer bonuses and investment plans, and are committed to growing and developing our employees. Our culture is one of belonging. We strive to be transparent and accountable. We believe in equipping our associates with the knowledge and resources they need to be successful. No matter where you’re at in the organization, you’re an integral part of our team and your input, thoughts, and ideas are valued. Join others who value a workplace for all. We appreciate and celebrate everything that makes us unique, from personal characteristics to past experiences. Our different perspectives strengthen us as an organization and help us better serve all Rhode Islanders. We’re dedicated to serving Rhode Islanders. Our focus extends beyond providing access to high-quality, affordable, and equitable care. To further improve the health and well-being of our fellow Rhode Islanders, we regularly roll up our sleeves and get to work (literally) in communities all across the state—building homes, working in food pantries, revitalizing community centers, and transforming outdoor spaces for children and adults. Because we believe it is our collective responsibility to uplift our fellow Rhode Islanders when and where we can, our associates receive additional paid time to volunteer. Why this job matters: We are seeking a skilled and collaborative Data Engineer to join our Advanced Analytics organization. This role is focused on enabling analytics and insights by enhancing and maintaining data warehouse and data mart structures. The Sr Data Engineer (DE) will collaborate directly with Data Warehousing, Data Science, and Governance teams to drive operational efficiency through building data assets. This role will be responsible for designing, building, and maintaining robust data pipelines, models, and assets that support enterprise-wide advanced analytics, insights, and reporting. Vital to various initiatives, the Sr. DE should be curious and ready to learn various facets of the healthcare data sources, establish sustainable practices, and build relationships with other technical teams. The ideal candidate will be ready to support innovation while leveraging operational principles. What you will do: Partner with analytics teams to understand data requirements and translate them into data warehouse/mart enhancements. Leverage Matillion and Snowflake platforms to build ELT/ETL workflows, pipelines, views, and data structures optimized for analytics Design and implement quality monitoring and alerting systems for reliability and accuracy. Collaborate with Governance to ensure proper data catalog and sustainability. Collaborate with data architects and IT to ensure alignment with enterprise data strategies and conduct design reviews. What you need to succeed: Bachelor’s degree in a quantitative field (e.g., Computer Science, Engineering, Information Technology) or equivalent experience. Ability to commute 2 days a week to 500 Exchange St, Providence, RI. 5 years of experience in data engineering Proven ability to work in Agile environments and manage multiple priorities Proven experience working with data warehouses, data marts, and dimensional modeling Experience with healthcare data (CPT, ICD-10, etc.) as well as HL7 standards Strong communication and collaboration skills, with the ability to work cross-functionally Familiarity with Machine Learning and Statistical Analysis. Expert in SQL development, relational data modeling, and DBT. Experienced with: Cloud data platforms/tools like Snowflake. ETL tools such as Matillion, or IBM Datastage. Python or other scripting languages (R, SAS). CI/CD, DevOps, and Agile methodologies. Unit and automated testing. Visualization tools like PowerBI or Tableau. Spark, Kafka, Iceberg Location: BCBSRI is headquartered in downtown Providence, conveniently located near the train station and bus terminal. We actively support associate well-being and work/life balance and offer the following schedules, based on role: In-office: onsite 5 days per week Hybrid: onsite 2-4 days per week Remote: onsite 0-1 days per week. Permitted to reside in the following states, pending approval from the Human Resources Department: Arizona, Connecticut, Florida, Georgia, Louisiana, Massachusetts, North Carolina, Oklahoma, Rhode Island, South Carolina, Texas, Virginia Our culture of belonging at Blue Cross & Blue Shield of Rhode Island (BCBSRI) is at the core of all we do, and it strengthens our ability to meet the challenges of today’s healthcare industry. BCBSRI is an equal opportunity employer. The law requires an employer to post notices describing the Federal laws. Please visit www.eeoc.gov/know-your-rights-workplace-discrimination-illegal to view the "Know Your Rights" poster. Introduce yourself to our recruiters and we'll get in touch if there's a role that seems like a good match. At BCBSRI, our greatest resource is our people. We come from varying backgrounds, different cultures, and unique experiences. We are hard-working, caring, and creative individuals who collaborate, support one another, and grow together. Passion, empathy, and understanding are at the forefront of everything we do—not just for our members, but for our employees as well. We recognize that to do your best work, you have to be your best self. It’s why we offer flexible work arrangements that include remote and hybrid opportunities and paid time off. We provide tuition reimbursement and assist with student-loan repayment. We offer health, dental, and vision insurance as well as programs that support your mental health and well-being. We pay competitively, offer bonuses and investment plans, and are committed to growing and developing our employees. Our culture is one of belonging. We strive to be transparent and accountable. We believe in equipping our associates with the knowledge and resources they need to be successful. No matter where you’re at in the organization, you’re an integral part of our team and your input, thoughts, and ideas are valued. Join others who value a workplace for all. We appreciate and celebrate everything that makes us unique, from personal characteristics to past experiences. Our different perspectives strengthen us as an organization and help us better serve all Rhode Islanders. We’re dedicated to serving Rhode Islanders. Our focus extends beyond providing access to high-quality, affordable, and equitable care. To further improve the health and well-being of our fellow Rhode Islanders, we regularly roll up our sleeves and get to work (literally) in communities all across the state—building homes, working in food pantries, revitalizing community centers, and transforming outdoor spaces for children and adults. Because we believe it is our collective responsibility to uplift our fellow Rhode Islanders when and where we can, our associates receive additional paid time to volunteer. Location: BCBSRI is headquartered in downtown Providence, conveniently located near the train station and bus terminal. We actively support associate well-being and work/life balance and offer the following schedules, based on role: In-office: onsite 5 days per week Hybrid: onsite 2-4 days per week Remote: onsite 0-1 days per week. Permitted to reside in the following states, pending approval from the Human Resources Department: Arizona, Connecticut, Florida, Georgia, Louisiana, Massachusetts, North Carolina, Oklahoma, Rhode Island, South Carolina, Texas, Virginia Our culture of belonging at Blue Cross & Blue Shield of Rhode Island (BCBSRI) is at the core of all we do, and it strengthens our ability to meet the challenges of today’s healthcare industry. BCBSRI is an equal opportunity employer. The law requires an employer to post notices describing the Federal laws. Please visit www.eeoc.gov/know-your-rights-workplace-discrimination-illegal to view the "Know Your Rights" poster.
Salary : $98,100 - $163,400
