SQL Database Developer

Who We Are:

Neighborhood Health Center is a non-profit organization local to Portland, OR serving underserved patients in the areas of primary care, internal medicine, dental services and more. Our patient-centered approach to care honors the unique needs and circumstances of each individual patient. NHC sees people, not problems, and recognizes that the time spent as a patient in a doctors office is only one factor in a persons overall health. Our leading edge, integrated clinical teams work in partnership with patients, their families, and the communities we serve to provide whole-person care, prevention, and ongoing support.

NHC is an Equal Opportunity Employer. We celebrate differences in the workplace and do not discriminate in employment opportunities or practices on the basis of race, color, religion, gender (sex), national origin, age, veteran status, sexual orientation, gender identity, disability, genetic information or any other characteristic protected by law.

Why work with us?

• We are a non-profit organization, passionate about providing the underserved population with medical and dental services across the greater Portland area, committed to making a difference daily.
• We offer our employees a competitive compensation and benefits package which includes 20 days of PTO (based on full time employment), 9 paid holidays, health/dental/vision insurance, quarterly wellness reimbursements, generous 401k retirement plan with employer match, employer paid disability insurance, EAP and life insurance.
• Our employees voted NHC a Top Workplace in 2020, 2021, 2022, 2023, and 2024!

Job Title: SQL Database Developer
Department:  IT Administrative
Reports To:  Data Analytics Manager
Work Type:  Hybrid
Classification:  Full-Time, Exempt
Language Differential:  Ineligible

SUMMARY

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). You will collaborate closely with BI developers, data analysts, IT staff, and business stakeholders to deliver secure, efficient, and scalable data solutions.

Key Responsibilities and Core Competencies

• 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.
• Ensure secure data access, compliance and application monitoring with HIPAA and internal governance standards.
• Provide operational support and incident management for data pipelines and data flows, including proactively updating internal clients and relevant parties on status changes and issues encountered.
• Author and maintain accurate and up-to-date technical documentation for systems, processes, procedures, architecture and technical designs.

Essential Job Duties

• Collaborate with the data team on report writing and data analytics. 
• Assist the delivery of data into Power BI and Tableau platform for analytics and visualization. 
• Collaborate with data team and organization to prioritize and understand data requests in the scheme of operational tasks. 
• Power BI Service Administration: Managing workspaces, datasets, and reports within the Power BI service.
• Data Connectivity: Expertise in connecting to various data sources, including SQL databases, Excel, and cloud services.
• Security and Compliance: Implementing and managing security settings, data governance policies, and compliance standards.
• Performance Optimization: Ensuring efficient performance of Power BI reports and dashboards by optimizing data models and queries.

Education and/or 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.

License and/or Certification

• EPIC Electronic Health Record certificate in Clarity, Caboodle Data is preferred.
• Microsoft Certification.

Knowledge, Technical Skills, Abilities & Behaviors

• EPIC Electronic Health Record.
• Tableau.
• Power BI.
• 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.
• Strong understanding of database structures, design, and reporting techniques required. Fluent in the creation of complex reports, scripts, and stored procedures.
• Analytical ability to gather and interpret requirements and then utilize those requirements to develop, recommend and implement reporting solutions.
• Must display good verbal and written communication skills.
•  Ability to work directly with business users and software vendors on problems and projects. Ability to communicate complex technical issues clearly and effectively to any audience.
• Excellent analytical and problem-solving skills.
• Strong communication and collaboration abilities.
• Attention to detail and a commitment to data accuracy.
• Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling. 
• Knowledge of API’s, XML, XSLT, basic java script.
• Strong understanding of relational and non-relational database structures, theories, principles, and practices. 
• Working knowledge of applicable data privacy practices and laws, including HIPAA. 
• Excellent written and oral communication skills and the ability to effectively communicate with personnel at all levels. 
• Exceptional analytical, conceptual, and problem-solving abilities. 
• Ability to prioritize and execute tasks in a high-pressure environment.
• Proven experience working in a team-oriented, collaborative environment. 
• Expert working knowledge of interface design and build.
• Expert working knowledge of IT standards and quality methods and metrics.
• Knowledge of user business practices, concepts, and terminology sufficient to support data mapping and translations.
• Ability to monitor and track highly detailed and multiple complex projects, systems, and data. 
• Strong organizational skills. 
• The ability to communicate effectively with leadership and subject matter experts.
• The ability and interest to learn new software and increase their knowledge over time.
• Must be proficient in reading, writing, and speaking English.

WORKING CONDITIONS

• Regularly sit while working on the computer; use hands and fingers to handle, control or feel objects tools or controls; repeat the same movements when entering data; ability to differentiate between colors, shades, and brightness; read from a computer screen for extended periods of time.
• Frequently stand and walk around the office to gather supplies, required to do filing, use office equipment, or collaborate with employees.
• Occasionally stand, stoop and lift or move objects, equipment and supplies weighing approximately 20-25 pounds up to 40-50 pounds.
• The noise level in the work environment is usually moderate.

Neighborhood Health Center Employment Offers are contingent on successful completion of reference checks, background checks, drug screening for illegal substances, Tuberculosis, and any position specific credentialing or licensure requirements.