GHX
Senior Software Engineer - ETL / MSSQL Louisville, Colorado, United States
GHX, Louisville, Colorado, United States, 80028
GHX is seeking a Senior Software Engineer to work on our CCX and Price Workbench product. This individual will be responsible for leading development efforts toward the creation, implementation, and support of existing and next-generation software solutions. Reporting to the Director, Software Development, the Senior Software Engineer will analyze, design, program, debug, and modify software enhancements and/or new products used in local, networked, or Internet-related computer programs. This role is responsible for interacting with users to define system requirements and/or necessary modifications in an Agile/Scrum environment. Duties and responsibilities Serve as team lead and coordinates code & design reviews and key project deliverables. Design, develop, and support next-generation web-based SaaS solutions. Design and develop data architecture, data definition and data manipulation structures in MSSQL Coordinate with the offshore development team, perform code & design reviews, and participate in daily standup meeting. Codes web applications across domains following specifications and using the appropriate tools. Identifies best practices and guides other team members in the implementation of best practices. Generates supporting unit test as well as system test specifications and implementations. Builds the automated test framework, drives best practices, and troubleshoots issues. Maintains, modifies, and improves existing applications. Qualifications Requires a minimum of 5-8 years of experience in software development. BS Degree in Computer Science or equivalent experience. 5-8 years Relational database experience in the areas ofdefiningentities (physical/logical), dependencies, SQL queries, stored procedures, performance tuning with respect to queries/schema/etc., executing DB explain plans and diagnosis. 3 years ETL and an understanding of ETL best practices. 3 years experience using source code management software. Prior experience working in an agile environment. Must be able to work independently and as part of a team on multiple overlapping projects. Proven track record of successfully delivering large projects. Preferred Qualifications GIT source code management software MSSQL RDS SQL Performance monitoring tools Understanding the principles of Kanban Knowledge, Skills, and Abilities Proficient with multiple technologies and may have some understanding of architectural principles. Identifies, implements, and applies best practices. Is the go to person on the team. Defines how the work should be done; provides intelligent alternatives to the status quo. Sells and drives ideas. Owns issues and can work effectively inside and outside of the team to influence and drive results. Ability to handle multiple projects and possesses a proven track record of high-quality deliverables. Ability to effectively communicate technical concepts to technical staff and can work effectively with cross-functional departments with varying degrees of technical experience. Understands and can explain up and downstream impacts across products, teams, and the organization. Constructively challenges the status quo; develops, proposes, and supports the implementation of innovative and creative solutions. Iterates and improves across multiple business domains. Displays flexibility in adapting to changing conditions and helps lead others through change. Leads by example, promotes a common purpose, and is a catalyst for success. Thinks strategically, displays a high degree of emotional maturity, and demonstrates a positive outlook. Strong team player, makes a valuable contribution to team objectives, displays trust and mutual understanding, accepts constructive feedback, and handles confrontation constructively. Possesses a broad understanding of Agile/LEAN principles and the ability to apply the agile methodology, competent AGILE team member. The base salary range represents the anticipated low and high end of the GHX's salary range for this position. The base salary is one component of GHX's total compensation package for employees. Other rewards and benefits include: health, vision, and dental insurance, accident and life insurance, 401k matching, paid-time off, and education reimbursement, to name a few. To view more details of our benefits, visit us here: No 3rd party, agencies or C2C allowed. #LI-SR GHX: It's the way you do business in healthcare Global Healthcare Exchange (GHX) enables better patient care and billions in savings for the healthcare community by maximizing automation, efficiency and accuracy of business processes. GHX is a healthcare business and data automation company, empowering healthcare organizations to enable better patient care and maximize industry savings using our world class cloud-based supply chain technology exchange platform, solutions, analytics and services. We bring together healthcare providers and manufacturers and distributors in North America and Europe - who rely on smart, secure healthcare-focused technology and comprehensive data to automate their business processes and make more informed decisions. It is our passion and vision for a more operationally efficient healthcare supply chain, helping organizations reduce - not shift - the cost of doing business, paving the way to delivering patient care more effectively. Together we take more than a billion dollars out of the cost of delivering healthcare every year. GHX is privately owned, operates in the United States, Canada and Europe, and employs more than 1000 people worldwide. Our corporate headquarters is in Colorado, with additional offices in Europe. Disclaimer Global Healthcare Exchange, LLC and its North American subsidiaries (collectively, GHX ) provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, national origin, sex, sexual orientation, gender identity, religion, age, genetic information, disability, veteran status or any other status protected by applicable law. All qualified applicants will receive consideration for employment without regard to any status protected by applicable law. This EEO policy applies to all terms, conditions, and privileges of employment, including hiring, training and development, promotion, transfer, compensation, benefits, educational assistance, termination, layoffs, social and recreational programs, and retirement. GHX believes that employees should be provided with a working environment which enables each employee to be productive and to work to the best of his or her ability. We do not condone or tolerate an atmosphere of intimidation or harassment based on race, color, national origin, sex, sexual orientation, gender identity, religion, age, genetic information, disability, veteran status or any other status protected by applicable law. GHX expects and requires the cooperation of all employees in maintaining a discrimination and harassment-free atmosphere. Improper interference with the ability of GHX's employees to perform their expected job duties is absolutely not tolerated. Create a Job Alert Interested in building your career at GHX? Get future opportunities sent straight to your email. Apply for this job indicates a required field First Name * Last Name * Email * Phone * Resume/CV * Enter manually Accepted file types: pdf, doc, docx, txt, rtf Enter manually Accepted file types: pdf, doc, docx, txt, rtf Are you legally authorized to work in the United States? * Select... Will you now or in the future require visa sponsorship? * Select... Please describe your current work authorization status. * How many years of professional software development experience do you have? * Select... How many years of relational database experience in the areas ofdefiningentities (physical/logical), dependencies, SQL queries, stored procedures, performance tuning with respect to queries/schema/etc., executing DB explain plans and diagnosis. * Select... How many years of experience with ETL and an understanding of ETL best practices? * Select... How many years of experience do you have using source code management software? * Select... How many years of experience do you have with GIT source code management software? * Select... How would you rate your experience with MSSQL RDS? * Select... How would you rate your experience with SQL Performance monitoring tools? * Select... This position is working hybrid 1 day a week in our Louisville, CO Office. Are you open to working hybrid? * Select... What are your expectations for pay in this role? * What City do you live in? * What State do you live in? * Select... If you were referred to this position by a current GHX employee, or other individual, please provide the person's name. * Pre-employment Statement: Applicants and Employees are evaluated without regard to mental or physical disability, gender identity, race, religion, sexual orientation, color, gender, national origin, age, marital status, military or veteran status or any other protected local, state, or federal status. I represent that the information I provide in this Application for Employment is complete, true and accurate, and if provide any incomplete, inaccurate or false information during the selection process, the organization may deny my application and/or terminate my employment if it discovers such information after I am hired. I authorize the organization to contact anyone that it deems appropriate to verify the information I have provided or to further investigate my background, past performance and suitability for employment. I consent to being discussed by any person contacted by the organization and waive all rights to bring any action for defamation, invasion of privacy or any similar claim against anyone who provides information to the organization with a good faith belief that the information provided is true. I understand that this Application for Employment is not an offer of employment and only a written offer signed by an authorized representative of the organization will be effective (Checking the box is equivalent to a handwritten signature.) * Select... Pre-Employment Statement When you apply to a job on this site, the personal data contained in your application will be collected by the GHX Compliance & Privacy Officer (CPO), which is located at 1315 W Century Dr., STE 100, Louisville, CO 80027 and can be contacted by emailing compliance@ . Your personal data will be processed for the purposes of managing GHX's recruitment related activities, which include setting up and conducting interviews and tests for applicants, evaluating and assessing the results thereto, and as is otherwise needed in the recruitment and hiring processes. Such processing is legally permissible under Art. 6(1)(f) of Regulation (EU) 2016/679 (General Data Protection Regulation) as necessary for the purposes of the legitimate interests pursued by the CPO, which are the solicitation, evaluation, and selection of applicants for employment.Your personal data will be shared with Greenhouse Software, Inc., a cloud services provider located in the United States of America and engaged by GHX to help manage its recruitment and hiring process on the CPO's behalf. Accordingly, if you are located outside of the United States, your personal data will be transferred to the United States once you submit it through this site. Because the European Union Commission has determined that United States data privacy laws do not ensure an adequate level of protection for personal data collected from EU data subjects, the transfer will be subject to appropriate additional safeguards. You can obtain a copy of the standard contractual clauses by contacting us at humanresources@.Your personal data will be retained by GHX as long as GHX determines it is necessary to evaluate your application for employment. Under the GDPR, you have the right to request access to your personal data, to request that your personal data be rectified or erased, and to request that processing of your personal data be restricted. You also have to right to data portability. In addition, you may lodge a complaint with an EU supervisory authority. * Select... Voluntary Self-Identification For government reporting purposes, we ask candidates to respond to the below self-identification pletion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file. As set forth in GHX's Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law. If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows: A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability. A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service. An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense. An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985. Select... Voluntary Self-Identification of Disability Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026 Voluntary Self-Identification of Disability Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026 Why are you being asked to complete this form? We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years. Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at . How do you know if you have a disability? A disability is a condition that substantially limits one or more of your major life activities. If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to: Alcohol or other substance use disorder (not currently using drugs illegally) Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS Blind or low vision Cancer (past or present) Cardiovascular or heart disease Celiac disease Cerebral palsy Deaf or serious difficulty hearing Diabetes Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders Epilepsy or other seizure disorder Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome Intellectual or developmental disability Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD Missing limbs or partially missing limbs Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports Nervous system condition, for example, migraine headaches, Parkinson's disease, multiple sclerosis (MS) Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities Partial or complete paralysis (any cause) Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema Short stature (dwarfism) Traumatic brain injury Disability Status Select... PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete. #J-18808-Ljbffr