Job Details

Job Title: SQL Developer/data Analyst
Location: Montgomery, AL (100% Onsite)
Duration: 12 Months

Position Details:

• Employees in this class are responsible for performing moderately to highly complex programming and systems analysis work on projects with integrated systems that impact multiple applications to support end-user needs.
• Requires full proficiency in T-SQL as identified by the development manager Deliverables: Create Stored Procedures SSIS ETL Packages Unit tests Documentation of developed code Status updates as requested by the Project Manager and Development Manager

• Modify and maintain T-SQL stored procedures, views, user-defined functions, and SSIS packages.
• dvanced T-SQL skills, including CTEs, window functions, joins, dynamic SQL, and error handling.
• Strong experience with stored procedures, scalar/table-valued functions, and views.
• Proficient in SQL Server Management Studio (SSMS) and working in live production environments.
• Triage and resolve incoming production support tickets related to incorrect or missing data.
• Investigate data integrity issues and apply SQL-based fixes safely and efficiently.
• nalyze root causes and recommend long-term solutions to prevent recurring issues.
• Communicate findings clearly to both technical and non-technical stakeholders. Track fixes and outcomes for audit/compliance documentation.
• Perform performance tuning and query optimization for high-traffic queries.
• Familiarity with SSIS is especially modifying existing packages, understanding workflows, and debugging.
• Solid understanding of data structures, relational modeling, and normalization.
• Comfortable navigating and fixing issues without always having step-by-step documentation.
• Possesses a strong analytical mindset with a natural drive to identify root causes and deliver effective, sustainable solutions.
• Maintains focus when addressing live production issues. Pay attention to the details and likes figuring out what went wrong and how to fix it.
• They can work by themselves when needed, adjust when things change, and write things down clearly so others can understand and use their work later.
• Comfortable working in a ticket-driven production support environment, where timely and accurate resolution of issues is critical.

• Create moderate to advance T - SQL Stored Procedures and Triggers.
• bility to write moderate and advance SQL commands.
• bility to test and troubleshoot database procedures and ETL Packages.
• Excellent written and verbal communication skills.
• Experience developing code using C#, .NET, HTML, or other web front-end technologies.
• bility to document code developed by analyst.
• Elicit data requirements by assisting with interviews, document analysis, data requirements workshops, Data process descriptions, use cases, Data analysis, task and workflow analysis.
• SQL Servers version 2012 and later.
• Programming business requirements in database language.
• Develop new SSIS/SSRS packages to meet business needs.
• Working hands-on with all aspects of the System Development Life Cycle.
• Knowledge of Microsoft Team Foundation Server

• 5 years of experience in software development experience.
• 5 years of experience in database development.
• 5 years of experience in tools used for software development (e.g., Visual Studio, Developer Tools, SSRS).
• Experience using TFS as Source Control.
• Experience with Agile Scrum project development methodology and able to apply methodology in a practical manner.

• Experience with State Government, Medicaid, CHIP and DHR business area or healthcare industry.

• Bachelor's Degree in Computer Science, Information Systems or another related field. Or equivalent work

• SQL certification.

• Candidate will work 100% onsite in Montgomery, AL. No remote work will be considered at this time.
• This position has the possibility of converting to merit. Position does not offer sponsorship.