Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably. There's no room for error. Join us and start doing your life's best work.(sm)As an IT Data Analytics Analyst, you will provide advanced database tools to provide specialized data analysis. They organize, sort and filter data in order to distinguish patterns and recognize trends. They develop and maintain data preparation and validation routines to support data mining and have experience in creating complex data mining algorithms. They select, recommend and apply appropriate analytic and statistical methodologies and techniques to execute against an analysis plan or research objectives.This position is for 2.30pm - 12pm shiftPrimary Responsibilities:Reports to the IT DirectorAssessing and interpreting business partner's and customer's reporting needs and requirementsInvestigates non-standard requests and problemsDesigning and implementing scalable analytical methodologies and reporting solutionsQuerying data sources to support their initiativesScrubbing and monitoring data to make sure that it meets legal requirementsMaintain, monitor and execute against the data transfer schedule and goalsUses pertinent data and facts to identify and solve a range of problems relative to HIPAA, ARRA and data releaseProvides explanations and briefings to colleagues on topics related to analytics and data transfersLead requirements gathering, analysis and design activities and interact with ClientsProvide hands - on leadership, coaching, mentoring, and software engineering best practices to junior developersCreate and maintain Stored Procedures, Views, Sequences, Triggers, Distributed Transactions and Scheduler JobsKeep Documentation up to date and perform any other operation related duties as assigned
Required Qualifications:Associate's Degree or higher level of education or equivalent experience6-8 years of IT experience2+ years experience with relational database management systems (e.g.. Access, SQL or Oracle, FileMaker Pro 9)2+ years experience performing data analytics and reporting5+ years PL/SQL experience with Oracle 11g and 12c1+ years of HIVE experience2+ years UNIX experience2+ years Advanced level of proficiency with MS ExcelExpertise with development tools like Toad, Ervin, SQL Advisor, SQL developer etc.Experience in Logical and Physical data modelingExperience in designing and developing of HIVE tables and schemaExperience in migration of Oracle database to HIVEAbility to create complex stored procedures, packages, functions in OracleAble to analyze the TKProof and trace filesAWR and ASH report analysis to find the bottle necksPerformance tuning of complex SQL queriesAble to design the SCHEMA and OBJECTS for business requirementsAdvanced PL/SQL programming and featuresAbility to multi task, attention to detail are vital for success in this positionStrong problem solving and analytical skillsPreferred Qualifications:Experience with object-oriented programming systemsProficiency with MySQL/PHPKnowledge of data release precautions and HIPAA regulationsTechnology Careers with Optum. Information and technology have amazing power to transform the health care industry and improve people's lives. This is where it's happening. This is where you'll help solve the problems that have never been solved. We're freeing information so it can be used safely and securely wherever it's needed. We're creating the very best ideas that can most easily be put into action to help our clients improve the quality of care and lower costs for millions. This is where the best and the brightest work together to make positive change a reality. This is the place to do your life's best work.(sm)Job Keywords: Senior Software Engineer, Software Engineer, Relational Database Management Systems, Access, SQL, Oracle, FileMaker Pro 9, Data Analytics, Reporting, PL/SQL, Oracle 11g and 12c, HIVE, UNIX, Hyderabad, Telangana, Noida, Uttar Pradesh
Our mission is to help people live healthier lives and to help make the health system work better for everyone.- We seek to enhance the performance of the health system and improve the overall health and well-being of the people we serve and their communities. - We work with health care professionals and other key partners to expand access to quality health care so people get the care they need... at an affordable price. - We support the physician/patient relationship and empower people with the information, guidance and tools they need to make personal health choices and decisions.