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.
• 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 certificate in Clarity, Caboodle Data is preferred.
• Microsoft Certification.

APPLY NOW