SQL Database Developer

The SQL Database Developer designs, develops, and maintains our data infrastructure including operational databases and a scalable enterprise data warehouse. This role will focus on data integration, modeling, and transformation to support analytics, reporting, and business intelligence solutions. The ideal candidate will have extensive experience with SQL Server, Power BI, Tableau, and data warehousing concepts, as well as a strong understanding of ETL pipelines, data modeling and relational database management systems (RDBMS).

Essential job duties:

    • 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.

Education and experience:

  • Bachelor’s degree in computer science or a related field is required; equivalent combination of education, experience, and training may be considered. 
  • 5 years of relevant experience in data warehouse development/maintenance is required.  
  • Healthcare industry experience is preferred. 
  • Advanced SQL Programming is preferred.

APPLY NOW

To apply for this job email your details to zilkek@nhcoregon.org