Join to apply for the Data Warehouse Developer role at Neighborhood Health Plan of Rhode Island
Join to apply for the Data Warehouse Developer role at Neighborhood Health Plan of Rhode Island
Get AI-powered advice on this job and more exclusive features.
DescriptionThe Data Warehouse Developer will develop, implement and maintain business driven information system solutions, on time and within budget. The ideal candidate will have a solid background in data warehouse development, with expertise in designing, building, and maintaining data warehouse solutions. This position works closely with the business analysts to understand the business requirements and create a technical solution using the appropriate tool(s). Proficiency in Power BI is preferred for this role to create insightful visualizations and reports based on the data stored in the warehouse.
DescriptionThe Data Warehouse Developer will develop, implement and maintain business driven information system solutions, on time and within budget. The ideal candidate will have a solid background in data warehouse development, with expertise in designing, building, and maintaining data warehouse solutions. This position works closely with the business analysts to understand the business requirements and create a technical solution using the appropriate tool(s). Proficiency in Power BI is preferred for this role to create insightful visualizations and reports based on the data stored in the warehouse.Duties and Responsibilities: Responsibilities include, but are not limited to the following:
- Design and develop new functionality for existing and new applications to support the company's data warehouse and reporting strategy
- Collaborate with cross-functional teams to gather requirements and define data warehouse architecture and ETL processes
- Develop and optimize SQL queries and stored procedures for data extraction, transformation and loading (ETL)
- Monitor and solve data warehouse issues and implement solutions to improve efficiency and reliability
- Create and maintain documentation for data warehouse processes, data mappings and data dictionaries
- Develop and maintain Power BI reports and dashboard to visualize data and provide insights to stakeholders
- Identify new technologies or technological improvements to include in the application to improve usability, stability and maintainability
- Provide technical consultation to internal business partners
- Seek opportunities for improvement within the business intelligence and development team (i.e., improving documentation, software quality improvement, etc.) and outline and implement solutions
- Other duties as assigned
- Corporate Compliance Responsibility - As an essential function, responsible for complying with Neighborhood's Corporate Compliance Program, Standards of Business Conduct, applicable contracts, laws, rules and regulations, policies and procedures as it applies to individual job duties, the department, and the Company. This position must exercise due diligence to prevent, detect and report unlawful and/or unethical conduct by fellow co-workers, professional affiliates and/or agents
QualificationsQualificationsRequired:
- Bachelor's degree in Information Systems and/or sufficient experience to equate to the degree
- Three (3)+ years of development experience within Microsoft SQL Server including:
- Stored Procedures
- User Defined Functions
- Triggers
- Views
- Indexes
- Three (3)+ years of designing relational database structures
- Three (3)+ years of designing and developing data analysis/reporting solutions
- Experience using a System Development Life Cycle
- Experience with Power BI for creating interactive reports and dashboards
- Solid analytical and problem-solving skills with the ability to analyze complex datasets
- Experience with cloud-based data warehousing platforms (Azure SQL Data Warehouse)
- Strong verbal and written communications skills and collaboration skills with the ability to work effectively in a team environment
- Excellent customer service skills
- Ability to effectively prioritize and implement tasks in a high-pressure environment is crucial
- Flexible schedule to accommodate after hours and/or weekends when needed
Preferred:
- Experience working in HMO
- Experience with Project Management Techniques
- Experience with Microsoft Business Intelligence Tools (SSIS, SSAS, SSRS)
- XML experience
- EDI experience
Grade Level: H/TNeighborhood is an Affirmative Action and Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, national origin, genetic information, age, disability, veteran status or any other legally protected basis.Seniority level
- Seniority levelMid-Senior level
Employment type
Job function
- Job functionInformation Technology
- IndustriesInsurance
Referrals increase your chances of interviewing at Neighborhood Health Plan of Rhode Island by 2x
Get notified about new Data Warehouse Engineer jobs in Smithfield, RI.
Massachusetts, United States $60,000.00-$80,000.00 18 hours ago
Data Engineer (Snowflake) Hybrid RI W2 Only
Providence, RI $118,000.00-$122,000.00 8 hours ago
Data Engineer, Amazon Robotics (AR) (Entry Level)
Massachusetts, United States $140,000.00-$160,000.00 6 days ago
Johnston, RI $52,700.00-$100,700.00 2 days ago
Norton, MA $50,000.00-$65,000.00 6 days ago
Massachusetts, United States 15 hours ago
Massachusetts, United States 11 hours ago
Norton, MA $50,000.00-$65,000.00 3 hours ago
Staff Engineer - Finance Data Specialist (Remote)
Providence, RI $115,000.00-$260,000.00 1 week ago
Milford, MA $134,500.00-$179,500.00 2 weeks ago
Providence, RI $140,000.00-$185,000.00 2 weeks ago
Rhode Island, United States $103,968.00-$184,049.00 2 days ago
Johnston, RI $52,700.00-$100,700.00 1 week ago
Massachusetts, United States $103,968.00-$184,049.00 2 days ago
We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr