Programmer Analyst Advisor - Remote | WFH

Join a forward-thinking organization dedicated to improving community health and well-being through innovative technology solutions. As a valued member of our team, you will experience numerous benefits including significant career growth, a flexible work environment that encourages continuous learning, and the opportunity to enhance your technical expertise through various training programs and certifications. Our robust leadership and technical development academies are designed to help you advance your skills and capabilities.

Job Overview

In the role of Advisor Programmer Analyst (SSIS Development), you will be integral in utilizing technology to positively impact the health outcomes of underserved populations. This position allows you to merge your technical passion with a meaningful mission, collaborating with a team of creative problem-solvers in addressing major challenges within healthcare.

Key Responsibilities

• Design and Maintain SSIS and SQL Applications: Develop, manage, and support SSIS and SQL applications for both internal teams and external clients.
• Collaborate with IT and Business Stakeholders: Partner with IT personnel and business stakeholders to create, maintain, and support ETL packages in a regulated environment.
• Escalate Concerns and Improve Practices: Identify issues and collaborate with project management to enhance current practices and suggest improvements.
• Participate in Design Sessions: Engage in Joint Application Design (JAD), Rapid Application Development (RAD), and Design Specifications Document (DSD) sessions to accurately define business needs.
• Develop and Implement SSIS Packages: Oversee the lifecycle of SSIS Packages from development through to production, ensuring smooth transitions.
• Administer SSIS: Manage SSIS maintenance by establishing jobs, alerts, and scheduling DTS/SSIS packages.
• Guide and Debug: Provide mentorship to fellow developers and display strong debugging capabilities.
• Automate Execution: Streamline the operation of SSIS packages via SQL Server Agent Jobs.
• Continuous Improvement: Actively contribute to initiatives aimed at process enhancements.
• Diagnose and Resolve Issues: Efficiently address incident tickets and troubleshooting errors.
• Develop Documentation: Create comprehensive ETL specifications, data mappings, and necessary documentation for the ETL development process.
• Perform Data Analysis: Utilize SQL to conduct thorough data analyses and manage data models, ensuring comprehensive understanding of business data.
• Quality Assurance Testing: Execute quality assurance testing to ensure data integrity and accuracy.
• Build Relationships: Foster positive working relationships with colleagues, clients, and stakeholders.
• Support Testing: Aid in various testing phases including Unit Testing, System Integration Testing, and User Acceptance Testing.
  
  

Required Skills

• Experience: A minimum of 9 years in application design and development with expertise in SQL Server and MS-SQL scripting, as well as SSIS development.
• Technical Skills: Proficiency in crafting complex queries and reports using Microsoft SQL, along with strong analytical capabilities.
• Leadership Experience: Demonstrated experience in team leadership, mentoring, and performance evaluation.
• Preferred Experience: Familiarity with healthcare plan data and the nuances of medical claims and compliance with Federal and State regulations.
  
  

Career Growth Opportunities

This role provides you with the unique chance to grow your career in a supportive environment that values professional development. You will have access to training programs and mentorship that can help you reach the next level in your career journey.

Company Culture and Values

Our organization thrives on collaboration, innovation, and inclusion. We are committed to fostering a diverse, equitable, and inclusive workplace where all qualified applicants are considered for employment without regard to race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, status as a protected veteran, or disability.

Compensation And Benefits

• Flexible Vacation Policy: Enjoy a work-life balance with a generous vacation policy.
• 401(k) Employer Match: Secure your future with our competitive 401(k) employer match.
• Comprehensive Health Benefits: Access to extensive health benefits to support your well-being.
• Educational Assistance: Benefit from support for your ongoing learning and development.
• Leadership and Technical Development Academies: Opportunities to grow your skills in leadership and technical domains.
  
  

Join us and contribute to a mission-driven team that is committed to transforming healthcare for the better!

Employment Type: Full-Time