Pay Range:$83,200.00 - $124,800.00
Please email if you are a candidate seeking a reasonable accommodation for the application and/or interview process.
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
