What are the responsibilities and job description for the SQL Developer position at Brooksource?
Summary
We are seeking a skilled SQL Developer to join our team in supporting the development and maintenance of Electronic Data Interchange (EDI) data feeds for a Third-Party Administrator (TPA) platform. The ideal candidate will have a strong background in SQL development, experience in the healthcare industry, and familiarity with Visual Studio. Prior experience with TPAs and QicLink is highly desirable.
Responsibilities:
- Design, develop, and maintain SQL-based EDI data feeds to support healthcare claims processing and reporting.
- Collaborate with business analysts, data analysts, and operations teams to gather requirements and translate them into technical solutions.
- Utilize Visual Studio for development, debugging, and deployment of SQL scripts and related components.
- Ensure data integrity, accuracy, and compliance with healthcare data standards (e.g., HIPAA, ANSI X12).
- Troubleshoot and resolve issues related to EDI transactions and data workflows.
- Optimize SQL queries and stored procedures for performance and scalability.
- Document processes, data mappings, and technical specifications.
Qualifications:
- 3 years of experience in SQL development, including stored procedures, views, and performance tuning.
- Proficiency with Microsoft Visual Studio for database development.
- Solid understanding of EDI formats and standards, particularly in healthcare (e.g., 837, 834, 270/271).
- Experience working in a healthcare environment, preferably with exposure to claims processing or provider data.
- Strong analytical and problem-solving skills.
Preferred Skills:
- Experience working with or for a Third-Party Administrator (TPA).
- Familiarity with QicLink or similar TPA platforms
- Knowledge of healthcare payer systems and Medicare/Medicaid data feeds.
- Experience with version control systems (e.g., Git) and Agile methodologies.