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 scalable data solutions and collaborating effectively 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 ModelingDimensional Data ModelingOLAP PrinciplesPowerShellPythonMicroservice ArchitectureHigh-Availability SystemsRoot Cause Analysis
Soft Skills
CollaborationMentoringProblem-SolvingCommunicationIndependence
Tools & Technologies
Microsoft SQL ServerSSISSSRSSSMSSSASAzure SQL DatabaseAWS RDSGitLabVisual StudioPower BI
Industry Keywords
NCPDPHL7ANSI X12Medicare Part DPharmacy ClaimsPharmacy Benefit ManagementPDE SubmissionsDrug Database TerminologiesBig Data TechnologiesNon-Relational Databases
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 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
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
- 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
Comp & perks- 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