Job Location : Smithfield,RI, USA
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. Description The 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. Description The 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 Qualifications Qualifications Required: 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/T Neighborhood 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 level Mid-Senior level Employment type Employment type Full-time Job function Job function Information Technology Industries Insurance 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