Neighborhood Health Plan Of Rhode Island - Smithfield, RI

posted 3 months ago

Full-time - Mid Level
Smithfield, RI
Insurance Carriers and Related Activities

About the position

The Data Warehouse Developer at Neighborhood Health Plan of Rhode Island is responsible for developing, implementing, and maintaining business-driven information system solutions that meet the needs of the organization. This role requires a solid background in data warehouse development, with a focus on designing, building, and maintaining data warehouse solutions. The ideal candidate will work closely with business analysts to understand business requirements and create technical solutions using appropriate tools. Proficiency in Power BI is preferred, as the role involves creating insightful visualizations and reports based on the data stored in the warehouse. In this position, the Data Warehouse Developer will design and develop new functionalities for existing and new applications to support the company's data warehouse and reporting strategy. Collaboration with cross-functional teams is essential to gather requirements and define data warehouse architecture and ETL processes. The developer will also be responsible for developing and optimizing SQL queries and stored procedures for data extraction, transformation, and loading (ETL). Monitoring and resolving data warehouse issues, as well as implementing solutions to improve efficiency and reliability, are key responsibilities. Additionally, the developer will create and maintain documentation for data warehouse processes, data mappings, and data dictionaries. They will develop and maintain Power BI reports and dashboards to visualize data and provide insights to stakeholders. The role also involves identifying new technologies or technological improvements to enhance usability, stability, and maintainability of applications. Providing technical consultation to internal business partners and seeking opportunities for improvement within the business intelligence and development team are also part of the job. Compliance with Neighborhood's Corporate Compliance Program and related policies is an essential function of this role.

Responsibilities

  • 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 dashboards 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 and outline and implement solutions
  • Corporate Compliance Responsibility - comply 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.

Requirements

  • Bachelor's degree in Information Systems or equivalent experience
  • Three (3)+ years of development experience within Microsoft SQL Server including stored procedures, user defined functions, triggers, views, and 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
  • Excellent customer service skills
  • Ability to effectively prioritize and implement tasks in a high-pressure environment
  • Flexible schedule to accommodate after hours and/or weekends when needed

Nice-to-haves

  • Experience working in HMO
  • Experience with Project Management Techniques
  • Experience with Microsoft Business Intelligence Tools (SSIS, SSAS, SSRS)
  • XML experience
  • EDI experience
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service