Senior Data Engineer

Job not on LinkedIn

🔥 3 minutes ago

🇺🇸 United States – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

ExactCare

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 2009

🏥 Healthcare

⚕️ Healthcare Insurance

💊 Pharmaceuticals

💰 Private Equity Round on 2016-03

Healthcare • Healthcare Insurance • Pharmaceuticals

ExactCare is a leading pharmacy care management provider that specializes in medication management for individuals with complex, chronic medical needs. With operations in all 50 states and Washington, D. C. , ExactCare supports more than 100,000 people nationwide, helping them manage their medications in assisted living, long-term care facilities, and at home. Partnering with healthcare organizations, ExactCare aims to improve clinical outcomes by ensuring better medication adherence, reducing readmissions, and lowering overall healthcare costs.

📋 Description

• Maintain complex data systems and improve existing processes • Build new data solutions for Pharmacy Benefit Management clients • Collaborate with peer engineers, business stakeholders, cross-functional teams, and the Product Owner • Work in an Agile development environment and participate in Scrum ceremonies • Design, develop, test, debug, and deliver software solutions according to requirements and schedules • Maintain VisualCron schedules, SQL/ETL procedures, reports, existing .NET applications, and related SQL code • Troubleshoot pharmacy claim issues, reports, and processes • Support SQL code tied to NCPDP Pharmacy Encounter data submissions • Produce detailed technical specifications from requirements and designs • Monitor and optimize database performance through query tuning and indexing strategies • Review processes and recommend reliable, maintainable code • Analyze software requirements for design feasibility and market requirements within time and cost constraints • Serve as a technical expert in design, development, coding, testing, and debugging • Integrate new technologies with cloud and product infrastructure • Raise problems and solutions to staff engineers and management • Communicate proposed solutions, updates, changes, and risks to stakeholders • Mentor team members and share knowledge • Monitor emerging trends and best practices in database development and related technologies

🎯 Requirements

• Bachelor's degree in Computer Science, similar technical field of study, or 4+ years of related experience and/or equivalent combination of education and experience required • Master's degree in Computer Science or similar technical field preferred • 10+ years of SQL database development using the Microsoft SQL Server toolset, including SSIS, SSRS, SSMS, SSAS, and RDBMS • 5+ years of experience with data warehouse methodologies • Proficiency in database design, normalization, and data modeling • Strong ability with dimensional data modeling and OLAP principles • Expertise in query tuning, performance optimization, and troubleshooting • Familiarity with cloud-based database solutions such as Azure SQL Database and AWS RDS • Advanced SQL skills, including data modeling, DBO creation, management, and indexing • Experience implementing high-availability, high-throughput, scalable systems • Expertise diagnosing application and database issues, performing root cause analysis, and recommending corrective actions • Experience with PowerShell and Python • Experience using AWS, GitLab, and Visual Studio • Familiarity with .NET, C#, JSON, XML, VisualCron, and Power BI • Familiarity with reporting and visualization tools such as Power BI and Tableau • Knowledge of non-relational databases such as MongoDB and Cassandra and big data technologies such as Hadoop and Spark • Knowledge of pharmacy industry standards such as NCPDP, HL7, ANSI X12, and related drug database terminologies and classifications • Knowledge of Medicare Part D, PDE submissions and returns, pharmacy claims, and benefit management • Ability to architect, design, develop, and implement microservice and monolithic architectures • Ability to work collaboratively and independently • Ability to learn other coding languages and technologies as needed • Must be eligible to work in the United States • Must be able to commute to multiple site locations within the assigned territory • May need to work extended hours and be available outside normal business hours on an ad-hoc basis

🏖️ Benefits

• Medical, dental, and vision coverage • Flexible spending • Company-paid life insurance • Short-term disability • Voluntary benefits • 401(k) • Paid Time Off • Paid holidays • Remote position • Flexible schedules adjusted to position and organizational needs