Sr. Data Warehouse Developer (Healthcare)

We wanted a PBM that worked better… so we created one. Southern Scripts, the leading disruptor in the PBM industry, simplifies the complexities of navigating through the Pharmacy Benefit Manager world by offering a value-added approach to ensure the employer absolute freedom, control, and choice to their health plan structure without compromising patient experiences and outcomes. We improve healthcare and reduce rising prescription costs for employers and their employees. We are looking for individuals who are passionate, strong, and committed to developing systems and service solutions that promote our business goals and commitments.Southern Scripts is searching for incredible talent! We continue to experience accelerated growth in a rapidly changing industry. There’s never been a better time to join our team. We are currently seeking a Sr. Data Warehouse Developer. This is a fully remote/work from home position. Role and ResponsibilitiesThe Senior Data Warehouse Developer is responsible for handling the delivery of data and information relating to the business intelligence of Southern Scripts and our Clients. They design, develop and maintain data warehouse and analytics architecture to meet our business analysis and reporting needs. The Senior Data Warehouse Developer is responsible for the successful delivery of business intelligence information to the entire organization. The Senior Data Warehouse Developer designs, develops and modifies relational database structures, relationships, data flows and data interfaces within the data warehouse as needed. The Senior Data Warehouse Developer is required to perform, but not limited to, the following duties and undertake the following responsibilities in a professional manner:Experience with Azure Data systems, such as Azure SQL Managed Instances, 3 + yearsDesign stable and reliable code to import, export, and analyze mission critical data to and from relational databases and data warehouses. Candidate will be responsible for developing, improving, and maintaining new and existing Azure Analysis Services, SISS package, C# projects.Design new Data Warehouse using Azure Data Factory, Azure Synapsis, and other Azure Based Systems Create and maintain data automation processes created in Azure Services.Design new Snowflake/Star Schema for reporting systems to replace SSAS on premises using Azure SQL Services with an ability to troubleshoot SSAS.Develop custom solutions to improve and automate business processes.Work with PBM/Pharmacy-specific data such as eligibility, accumulator, and claimsCommunicate with external customers and vendors to plan and trouble shoot data issues.Work in an agile development lifecycle and collaborate with team members to deliver solutions.Develop solutions in a testable fashion, work with QA on testing work items, Experience with TDD is a bonus.Abide by all obligations under HIPAA related to Protected Health Information (PHI).If a HIPAA violation is discovered, whether individually or by another, you must report the violation to the Compliance Officer and/or Human Resources.Attend, complete, and demonstrate competency in all required HIPAA Training offered by the company.Flexibility to understand, appreciate and embrace that this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice. What We Have to OfferOur benefits package is designed to keep our employees happy and healthy – physically, mentally and financially. Servant CultureMedical, Dental, Vision insuranceDisability and Life insuranceEmployee Assistance ProgramRemote work optionsGenerous Paid-Time OffAnnual Reviews and Development PlansRetirement Plan with company match immediately 100% vested Required Skills and CompetenciesAzure Analysis ServicesAzure Data FactoryTSQLAzure SQL or SQL 2019 or aboveVisual Studio 2017 or aboveC#Git RepositoriesSSISSSRS Supervisory ResponsibilityNone Position Type and Expected Hours of WorkThis is a full-time, salaried position. Days and hours of work are Monday through Friday, 8:00 a.m. to 5:00 p.m., with occasional after-hours or weekend duties. TravelThis position requires minimal travel from the Charleston area. Qualifications and Education RequirementsUndergraduate degree in Information System, Computer Science or relatedPreferred: 5 or more years’ experience with SQL serverPreferred: 1 or more with C# and visual studio Any experience with Azure Elastic Search is a bonusSouthern Scripts, LLC and all entities provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Southern Scripts complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.Southern Scripts expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Southern Scripts employees to perform their job duties may result in discipline up to and including discharge. EOE M/F/V/D PI207336386