McKesson Jr. SQL Developer in Atlanta, Georgia
McKesson is in the business of better health and we touch the lives of patients in virtually every aspect of healthcare. At Macro Helix, we are a leader in providing 340B software focused on helping customers improve financial performance, increase operating efficiencies and maintain regulatory compliance.
Every single McKesson employee contributes to our mission—by joining McKesson you act as a catalyst in a chain of events that helps millions of people all over the globe. We understand the importance of a system that works together. You’ll collaborate on the products and solutions that help us carry out our mission to improve lives and advance healthcare. Your expertise, drive and passion can help us improve everything we touch, from providers to payors to pharmacies. Working here is your opportunity to shape an industry that’s vital to us all.
Join our team of leaders to begin a rewarding career.
As a SQL developer, you will work closely with the MacroHelix internal project teams to implement our applications/solutions in the most effective way to maximize the client investment and meet their business and technical objectives. This position will be part of the development team and will be maintaining and creating SQL procedures and logic. The position will be involved in variety of activities including SSRS, creating procedures, patching bugs/faulty logic, and working closely with Product Management and Operations to understand the evolving platform and its features.
Establishes database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy. Documents and communicates database design. Evaluates and installs database management systems. Codes complex programs and derives logical processes on technical platforms. Builds windows, screens and reports. Assists in the design of user interface and business application prototypes. Participates in quality assurance and develops test application code in client server environment. Responsible for devising, negotiating, and defending the tables and fields provided in the database. Adapts business requirements, developed by modeling/development staff and systems engineers, and develops the data, database specifications, table and element attributes for an application. At more experienced levels, helps to develop an understanding of client's original data and storage mechanisms. Determines appropriateness of data for storage and optimum storage organization. Determines how tables relate to each other and how fields interact within the tables for a relational model.
Use TFS & Salesforce as primary methods to track enhancements/bugs .
Create new logic and features using TSQL, SSIS, & SSRS
Correct and patch bugs in existing code/processes using TSQL, SSIS, & SSRS
Create database objects (tables, views, stored procedures, triggers, etc)
Make recommendations to improve and gain efficiency for existing processes
Create ER diagrams for proposed database
Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints
Proactively identify potential blocking, deadlocking and address
Develop and schedule reports in SSRS
Documentation of any processes created or updates made
Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the application
2 years experience in programming on enterprise or department servers or systems
Knowledge of TSQL and OLTP topics such as Normalization, data types, query tuning, indexing, constraints, and query plan
Ability to break down and solve complex engineering problems
Ability to work independently and as a contributing team member.
Additional Knowledge & Skills
Healthcare experience and/or working knowledge of medical terminology preferred
Experience in SSIS & SSRS
Ability to write technical documents
Ability to be effective in a rapidly growing organization
Possess excellent listening skills and a commitment to communicating in a clear, concise and timely manner at all times
Possess exceptional skills in partnering with clients staff and in developing and maintaining long-term supportive relationships
Ability to organize time effectively while identifying barriers to progress, proposing solutions and setting priorities
4-year degree in computer science or related field or equivalent experience
Benefits & Company Statement
We believe you should be rewarded for the important work you do. For that reason, you'll receive a competitive compensation and benefits package when you join our team.
It starts with you. That's a simple sentence but it says a lot. It reminds each one of us that what we do matters. Every single McKesson employee contributes to our mission - whatever your title, whatever your role, you act as a catalyst in a chain of events that helps millions of people all over the globe. By connecting and improving the business of healthcare, we're helping to ensure that millions of patients get the treatment they need. And by choosing a career with McKesson Pharmacy Systems & Automation, you'll join a team of passionate people working together to improve lives and advance healthcare.
At McKesson, we believe we can empower healthcare. And it all starts with you.
Qualified applicants will not be disqualified from consideration for employment based upon criminal history.
McKesson is an equal opportunity and affirmative action employer - minorities/females/veterans/persons with disabilities.
No agencies please.
Organization: McKesson Rx Tech Solutions
Title: Jr. SQL Developer
Requisition ID: 17001595