Data Warehousing Analyst

Pay Range:

$83,200.00 - $124,800.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:

Analyze, define, maintain, and manage business data contained within the enterprise data warehouse.  Map and verify data from new data sources into the warehouse, ensuring the integrity of the data. Maintain operational and user-facing data documentation.

What you will do:

• Work with business stakeholders to understand business requirements for changes to business processes, policies and information systems to shape their needs into documentation (System Requirement Specification, Source to Target Mapping) that developers and testers can use to create the proper technical solution.
• Profile, analyze, and transform data in existing datastores and work with third party vendors to understand their capabilities and data sources in order to shape functional requirements and source to target mapping rules for the development team.
• Work with the business community to communicate and validate functional designs (ingestion, transformation, extraction) for data ingestion or extraction to ensure proper functionality of ELT processes.
• Support the business and technical stakeholders throughout projects. Help them understand what data is available in the data warehouse and ingest new data sources. Serve as a liaison and translator between end-user community and the corporate technical resources. Participate in SDLC activities including requirements refinement, design reviews, testing support, and production validation.
• Define and maintain user-facing data documentation and definitions for the data warehouse.
• Analyze and improve operational processes and documentation related to maintaining the data warehouse.
• Define data validation rules and perform data reconciliation to ensure accuracy and completeness of data within the warehouse. Investigate and remediate data quality issues in partnership with various teams.
• Perform other duties as assigned.

What you need to succeed:

• Bachelor’s degree in Computer Science, Information Science or related field; or an equivalent combination of education and experience
• Three to five years experience with database management systems, business intelligence tools and systems
• Data warehouse or data mart experience
• Experience on an operations or development team