SQL Database Developer

NEIGHBORHOOD HEALTH CENTER-posted 1 day ago

Full-time • Mid Level

Hybrid • Tigard, OR

251-500 employees

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

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.

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.

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

Advanced SQL Programming is preferred.
EPIC Electronic Health Record certificate in Clarity, Caboodle Data is preferred.
Microsoft Certification.
EPIC Electronic Health Record.
Tableau.
Power BI.
Experience with Microsoft Power BI is preferred.

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.

Track Jobs with Teal

Job Search Resources

•

AI Resume Builder

•

SQL Server Developer Resume Examples

•

SQL Server Developer Cover Letter Examples

SQL Database Developer

Job Search Resources

Tools

Career Hubs

Guides

Company