Data Warehousing Analyst

Pay Range:

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
• Experience with system analysis, data engineering, or equivalent, with project management and SDLC experience
• Advanced analytical skills, with the ability to interpret and synthesize complex business processes and data sets
• Intermediate SQL skills for analysis, validation, and troubleshooting
• Data modeling
• Familiarity with Python
• Familiarity with cloud computing concepts
• Familiarity with data dictionaries and metadata repositories
• Familiarity with various Business Intelligence tools
• Good business acumen and political savvy
• Knowledge of business process improvement techniques and strategies
• Excellent verbal and written communications skills
• Negotiation skills
• Presentation skills
• Decision-making skills
• Good problem-solving skills
• Ability to interface with employees with different skillsets
• Ability to effectively navigate ambiguous situations with limited direction
• Excellent organizational skills and ability to successfully prioritize multiple tasks
• Ability to handle multiple priorities/projects

The extras:

• Master’s in Business Administration or Master’s degree in Computer Science, Information Systems or other related field
• HIAA Certification
• Knowledge of the health insurance industry and systems
• Experience with data warehouse platforms, ETL, and BI tools
• Experience with data governance

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.