This position will be responsible for enhancing & designing Database setup for reporting. This position will need to be able to gather requirements, produce efficient database/tool designs, perform user acceptance testing and manage releases into the production environment. The role will also be responsible for ideation as regards the tools; having the ability to suggest enhancements based on design/security/performance in an on-going fashion.The role requires the Developer to participate in enterprise projects and provides technical leadership to project teams, clarifying business needs and requirements, performing analysis, design, development, integration, and maintenance of highly complex systems.Primary Responsibilities:Understanding Business needs and accordingly Designing/Managing DatabasesWork with the DBA group, analyses and resolves root causes of slow running extracts, queries, dashboards or reportsConceptualize design and produce documentation illustrating proposed enhancementsVerify application results by conducting system audits of technologies implementedActively participate in design and analysis sessions with functional groups and Business Analysts to ensure flawless designPlaying a role of Data Architect while providing guidance to Business Analysts / ClientsPreserve assets by implementing disaster recovery and back-up procedures and information security and control structuresDesigns and develop reporting metadata layer to support reporting initiatives and ad-hoc requests within established guidelines Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, benchmarking state-of-the-art practices, participating in professional societiesContribute to team effort by accomplishing related results as neededActively participate in the full software development life cycle (SDLC) to enhance the Enterprise Data Warehouse and Business Intelligence solutions, including detailed design, configuration, documentation, testing, and deploymentsMeet with clients and users to gather and analyze business requirements Design technology solutions for data load and reporting requirements Assist in testing reports and program objects for quality Review deliverables to ensure suitability Manage developer utilization and assist in managing the software release schedule Provide business consulting to teammates, managers, and users
Required Qualifications:We are looking for strong database skill set and below are the technologies our developers need to be skilled and experienced for ERA:Bachelor in Computer Science1+ years developing reports using Tableau 4+ years of total experience in ETL4+ years of MS SQL Database Architect experience1+ years of experience on managing projectsBusiness Analytics and Data Analytics experienceMust have the interpersonal skills and business acumen to work directly with clients on key initiatives Very Good in SSIS, SSRSWell versed in writing complex SQL queries, SSIS JobsVery good in database performance tuning and to be provide best execution plan for any Database RequestsGood Communication SkillsStrong attention to detailIntermediate or greater skills with Microsoft Office (PowerPoint, Outlook, Excel) Technology 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: IT DB Analyst, IT Analyst, DB Analyst, Analyst, Tableau, SQL, ETL, SSIS, SSRS, Hyderabad, Telangana
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.