Note: The job is a remote job and is open to candidates in USA. AnewHealth is a healthcare solutions company specializing in pharmacy care management, pharmacy benefit management, and related support services. The Senior Data Engineer maintains complex data systems, develops scalable data solutions, supports pharmacy claims and reporting processes, and collaborates with stakeholders to improve analytics, business intelligence, and clinical and financial outcomes.
Responsibilities
- Work in an Agile development environment; actively participate in and contribute to all Scrum ceremonies
- Design, develop and deliver solutions per requirements and committed schedules
- Work closely with Product Owner in evaluating current systems and making decisions on future development
- Test, debug, and add enhancements to existing code, processes, or reports
- Maintain existing processes, including but not limited to: VisualCron schedules, SQL/ETL procedures, and reporting
- Assist in troubleshooting pharmacy claim related issues , reports and processes
- Support existing .NET applications and subsequent SQL code tied to NCPDP Pharmacy Encounter data submissions
- Produce detailed technical specifications based on requirements and design
- Monitor and optimize database performance, including query tuning and indexing strategies
- Review new and existing processes and provide recommendations for reliable and maintainable code
- Analyze and research software requirements to determine feasibility of design and market requirements within time and cost constraints
- Serve as a technical expert in the design, development, coding, testing, and debugging of new software or complex enhancements to existing software
- Learn new technologies and resolve challenges involved with integrating them with our Cloud and product infrastructure
- Proactively raise problems and solutions to staff engineers and management
- Communicate and propose solutions to updates, changes, and risks to stakeholders
- Share knowledge to help develop and advance the team through mentorship
- Keep abreast of emerging trends and best practices in database development and related technologies
Skills
- 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
- Proficient in database design, normalization, and data modeling
- Strong ability with dimensional data modeling and OLAP principles
- 10+ years of SQL database development, working with the full Microsoft SQL Server toolset (SSIS, SSRS, SSMS, SSAS, RDBMS)
- 5+ years' experience with Data Warehouse methodologies
- Expertise in query tuning, performance optimization, and troubleshooting
- Familiarity with cloud-based database solutions (e.g., Azure SQL Database, AWS RDS)
- Advanced SQL skills, including data modeling, DBO creation, management, and indexing
- Experience implementing high availability, high throughput, scalable systems
- Expertise in identifying and diagnosing application and database related issues, perform root cause analysis, and recommend corrective actions
- Experience with PowerShell, Python
- Experience using provided tools (AWS, GitLab, Visual Studio)
- Familiarity with .NET, C#, JSON, XML, VisualCron, PowerBI
- Familiarity with reporting and visualization tools (e.g., Power BI, Tableau)
- Knowledge of non-relational databases (e.g., MongoDB, Cassandra) and big data technologies (e.g., Hadoop, Spark)
- Knowledge of pharmacy industry standards such as NCPDP, HL7, ANSI X12, and/or related drug database terminologies and classifications
- Knowledge of Medicare Part D, PDE submissions & returns, pharmacy claims and benefit management
- Demonstrated ability to be creative, flexible, and passionate about building quality solutions
- Demonstrated ability to architect, design, develop and implement solutions around a micro-service and monolithic architectures
- Skilled in written and verbal communication with demonstrated ability to work collaboratively with a team and independently as needed
- Has initiative and follow-through on projects with minimal supervision or guidance
- Demonstrated expertise to work in multiple technical areas or disciplines
- Interest and ability to learn other coding languages and technologies as needed
- Hearing, seeing, sitting, standing, talking, and walking
- Must be able to commute to multiple site locations within assigned territory
- May be necessary to work extended hours as needed
- This is a full-time position with an expectation to work an average of 40 hours per week and be available outside of normal business hours to meet customer expectations on an ad-hoc basis
- This is a remote position
- Applicants must be eligible to work in this country
- Master's degree in Computer Science, similar technical field of study preferred
- Experience with agile methodology (Scrum, Kanban, Lean, etc.) preferred
- Experience in healthcare technology, online pharmacy claims adjudication preferred
Benefits
- This is a remote position.
- AnewHealth offers a comprehensive benefit package for full-time employees that includes medical, dental, and vision coverage.
- Flexible spending accounts for full-time employees.
- Company-paid life insurance for full-time employees.
- Short-term disability coverage for full-time employees.
- Voluntary benefits for full-time employees.
- 401(k) for full-time employees.
- Paid Time Off for full-time employees.
- Paid holidays for full-time employees.
- Medical, dental, and vision coverage are effective 1st of the month following date of hire.
Company Overview