Neighborhood Health Center is looking to solve the problem of designing, developing, and maintaining their data infrastructure, including operational databases and a scalable enterprise data warehouse, to support analytics, reporting, and business intelligence solutions.
Requirements
- Extensive experience with SQL Server, Power BI, Tableau, and data warehousing concepts
- Strong understanding of ETL pipelines, data modeling and relational database management systems (RDBMS)
- Experience with Microsoft SQL Server and related tools: SQL Server Analysis Services, SQL Server Integration Services, SQL Server Management Studio
- 5+ years of IT industry experience designing and developing data warehouse solutions, SQL database design and Microsoft SQL server administration
- Experience with Microsoft Power BI is preferred
- Strong technical background in database administration and development is a must
- Knowledge of API’s, XML, XSLT, basic java script
Responsibilities
- Design, build, implement, deploy data extraction, load, transform, maintain ETL/ELT pipelines of structured and unstructured data from various sources including databases, APIs, and flat files.
- Develop and optimize complex SQL queries, stored procedures, and data models for reporting and analytics.
- Develop, configure, customize and manage integration tools, databases, warehouses and analytical systems with the use of data related software.
- Build and manage data marts, cubes, and data warehouse schemas (e.g., dimensional modeling, star/snowflake schema) and monitor regular data replication of data tables through FTP site.
- Collaborate with IT teams to monitor and maintain SQL Server performance, including storage, replication, server capacity, operational support for data pipelines and resolve data integrity or performance issues.
- Develop and deploy data into visualization platforms such as Power BI and Tableau.
- Act as a technical liaison with business units to elicit requirements, prioritize tasks, and define agile delivery plans.
Other
- Bachelor’s degree in computer science or a related field is required
- 2 years of relevant experience in data warehouse development/maintenance is required
- Healthcare industry experience is required
- Must display good verbal and written communication skills
- Ability to work directly with business users and software vendors on problems and projects
