Data Warehousing Analyst

Blue Cross & Blue Shield of Rhode Island•Providence, RI

1d•$83,200 - $124,800•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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.
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.