FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in SQL database development, including advanced skills in query tuning, performance optimization, and data modeling. Proficient in building and maintaining data solutions within the Pharmacy Benefit Management sector, while effectively collaborating with cross-functional teams in an Agile environment.
Highest-signal resume keywords
SQL Database DevelopmentData Warehouse MethodologiesQuery Tuning and Performance OptimizationCloud-Based Database SolutionsPharmacy Industry Standards
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLDatabase DesignData ModelingETL ProceduresPerformance OptimizationMicroservice ArchitectureDimensional Data ModelingRoot Cause AnalysisHigh-Availability SystemsTroubleshooting
Soft Skills
CollaborationMentoringCommunicationProblem-SolvingAdaptability
Tools & Technologies
Microsoft SQL ServerSSISSSRSSSMSSSASAzure SQL DatabaseAWS RDSPowerShellPythonPower BI
Industry Keywords
Pharmacy Benefit ManagementNCPDPHL7ANSI X12Medicare Part DPDE SubmissionsPharmacy ClaimsBig Data TechnologiesMongoDBCassandra
Tech Stack
Tools & technologiesAWSAzureCassandraCloudETLHadoopMongoDBMS SQL ServerPythonRDBMSSparkSQLSSISTableau.NET
About the role
Key responsibilities & impact- 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 solutions according to requirements and schedules
- Maintain VisualCron schedules, SQL/ETL procedures, and reporting processes
- Troubleshoot pharmacy claim-related issues, reports, and processes
- Support existing .NET applications and SQL code for 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 designing, coding, testing, and debugging software and complex enhancements
- Integrate new technologies with cloud and product infrastructure
- Raise problems and solutions to staff engineers and management
- Communicate proposed updates, changes, and risks to stakeholders
- Mentor team members and share knowledge
- Keep current with database development trends and best practices
Requirements
What you’ll need- 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
- 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, data modeling, dimensional data modeling, and OLAP principles
- Expertise in query tuning, performance optimization, troubleshooting, root cause analysis, and corrective actions
- Familiarity with cloud-based database solutions such as Azure SQL Database and AWS RDS
- Advanced SQL skills, including data modeling, DBO creation, database management, and indexing
- Experience implementing high-availability, high-throughput, scalable systems
- 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 work in multiple technical areas or disciplines
- Interest and ability to learn additional coding languages and technologies
- Must be able to commute to multiple site locations within the assigned territory
- Must be available outside normal business hours on an ad-hoc basis
- Applicants must be eligible to work in this country
Benefits
Comp & perks- Medical, dental, and vision coverage
- Flexible spending accounts
- Company-paid life insurance
- Short-term disability coverage
- Voluntary benefits
- 401(k)
- Paid Time Off
- Paid holidays
- Remote position
- Flexible work arrangements implied by remote work