Neighborhood Health Center ยท 1 day ago
SQL Database Developer
Portland, OR
Full-time
Hybrid
Entry, Mid Level
2+ years expNeighborhood Health Center is a non-profit organization serving underserved patients in Portland, OR. The SQL Database Developer will design, develop, and maintain data infrastructure to support analytics and reporting solutions, collaborating with various teams to deliver secure and efficient data solutions.
DentalHealth CareMedicalNon Profit
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
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
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
Qualification
Required
Bachelor's degree in computer science or a related field is required; equivalent combination of education, experience, and training may be considered
2 years of relevant experience in data warehouse development/maintenance is required
Healthcare industry experience is required
Advanced SQL Programming is preferred
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
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
Preferred
EPIC Electronic Health Record certificate in Clarity, Caboodle Data is preferred
Microsoft Certification
Experience with Microsoft Power BI is preferred
Benefits
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
Life insurance
Company
Neighborhood Health Center
Neighborhood Health Center is a clinic that provides medical, dental, behavioral, and reproductive healthcare services.
201-500 employees
H1B Sponsorship
Neighborhood Health Center has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2023 (2)
2021 (3)
2020 (2)
Funding
Current Stage
Growth StageLeadership Team
Jeri Weeks
CEO
Recent News
2023-07-27
2022-08-04
Company data provided by crunchbase