Expert Software Engineer - SQL - Remote - US

Altera, a new member of the N. Harris Computer Corporation family, delivers health IT solutions that support caregivers around the world. These include the Sunrise™, Paragon®, Altera TouchWorks®, Altera Opal, STAR™, HealthQuest™ and dbMotion™ solutions. At the intersection of technology and the human experience, Altera Digital Health is driving a new era of healthcare, in which innovation and expertise can elevate care delivery and inspire healthier communities across the globe. A new age in healthcare technology has just begun.

Altera/NSHS is looking for a talented report analyst/developer to join its Data Management team as it builds out a Revenue Cycle BI platform using Microsoft SQL Server technologies.  This role will be involved in all aspects of development lifecycle, including analysis, technical design and specifications, development and rollout to end-users.  The individual will work directly with team members, leadership and partners to design scalable and extendable solutions, visual and interactive dashboards and reports.

Responsibilities:

ESSENTIAL FUNCTIONS / JOB DUTIES:

• Implement the reporting responsibilities in the data warehouse
• Design report solutions that align with data management principles, policies, standards and best practices
• Support reporting cycles (ie daily, weekly, monthly)
• Adhere and develop all documentation standards, development lifecycle tasks, and status reporting requirements
• Efficiently deliver high-quality solutions through formalized technical design documents and specifications, proactive testing and on-going quality monitoring
• Work with the Manager to provide technical application solutions for assigned business areas.
• Identify the common causes of the defects, prioritize them and systematically remove them so that they do not reoccur in further development work.
• Participate in focus groups and workshops, attend vendor training and demonstrations.
• Possess technical knowledge of assigned application technology.
• Work with Business Analyst to understand the customer’s product-specific requirements and configuration and translate them to technical design specifications and data flow from which programs are developed and coded.
• Codes, tests, debugs, implements, and documents programs or technical configuration.
• Ensure programs meet technical specifications and standards.
• Interact with Business Analysts during the software build or configuration and testing process.
• Perform technical application configuration and configure /run reports at user request.
• Design and execute unit, system and integration test plans for new developments/releases/reports.
• Maintain technical documentation based on standard operating procedures in support of the assigned application.
• Perform application maintenance activities.
• Provide production support.
• Interface with Business Analyst to assist in resolving support calls escalated by the Service Desk.
• Interact with the team as the technical lead in development, which includes analysis, design and development.

These are consistent accountabilities for all staff.

• Assist in supporting activations and rollouts.
• Consistent efforts to deliver quality solutions as per agreed scope.
• Customer focus and close alignment with the customers’ business objectives.
• Ensure efforts to continually improve domain knowledge.
• Ensure the quality of the deliverables as per the defined defects standards
• Document issues with resolutions and share with team members to improve team productivity.
• Provide data to generate team performance metrics.
• Knowledge transfer with other team members to improve overall team education level
• Take complete ownership for the assigned task and timely inform the progress of the project / task to all stakeholders.
• Adherence to the defined standards.
• Take initiative and drives to bring to logical conclusion; proactive approach.
• Provide accurate and timely information and escalates when there are issues.
• Actively participate in meetings and make valuable contribution.
• Provide production support for application issues.
• Identify, coordinate and communicate issues, requirements and status related to application functionality with other team members and software vendors.
• Ensure the quality of the deliverables as per the defined defects standards and excelling within that

Qualifications:

PREFERRED SKILLS/EXPERIENCE/QUALIFICATIONS:

• Bachelor's degree in Computer Science, Information Systems, or related field; or equivalent work experience
• Minimum 7-10 years of experience in SQL and report development
• Proficient in MS SQL Server 2008 R2, MS SQL SERVER 2019 including T-SQL, SSIS, SSRS and SSAS
• Proficient in Microsoft development in C#, Windows Powershell, Visual Basic and Crystal Reporting
• Effective troubleshooting and performance tuning skills - should be able to identify and resolve moderate performance issues
• Demonstrated understanding of relational database design and architecture
• Demonstrated ability to develop online reporting solutions that meet business need
• Minimum of 5 years with experience in designing and building interactive and visual dashboards for delivering information for senior leadership
• Customer service with ability to develop effective partnerships across the organization
• Strong communication (written and verbal) and analytical skills
• Ability to organize, plan, and carry out multiple concurrent objectives or activities, and effectively make judgments in prioritizing and time allocation
• Ability to work independently

Academic and Professional Qualifications:

• BA or BS degree preferred or other relevant combination of training and experience.

Experience:

• 5-10 years Industry experience preferred
• 7-10 years practical experience in providing technical support and maintenance in assigned product preferred

Travel Requirements:

• May require local travel
• May require other travel for business needs

Working Arrangements:

• May require after hours on call support
• Work is performed in a standard office environment with minimal exposure to health or safety hazards

Our company complies with all local/state regulations in regard to displaying salary ranges. If required, the salary range(s) are displayed below and are specifically for those potential hires who will perform work in or reside in the location(s) listed, if selected for the role. Any offered salary is determined based on internal equity, internal salary ranges, market data, ranges, applicant's skills and prior relevant experience, certain degrees and certifications (e.g. JD, technology), for example.

 Altera is an Equal Opportunity/Affirmative Action Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state or local law.

If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at:

HR.Recruiting@AlteraHealth.com