Note: The job is a remote job and is open to candidates in USA. Blue Cross & Blue Shield of Rhode Island is seeking a Data Warehousing Analyst to manage and analyze business data within the enterprise data warehouse. The role involves working with stakeholders to define business requirements, ensuring data integrity, and supporting data processes.
Responsibilities
- 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
Skills
- 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
- 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
Benefits
- Flexible work arrangements that include remote and hybrid opportunities
- Paid time off
- Tuition reimbursement
- Assist with student-loan repayment
- Health, dental, and vision insurance
- Programs that support your mental health and well-being
- Bonuses
- Investment plans
- Paid time to volunteer
Company Overview