Your personal job search agent

Find a job



    show more options

Senior Data Architect, Netezza - Eden Prairie, MN - Eden Prairie, MN

Company: UHG
Job type: full-time
Category: Information Technology and Services

Apply now
(no registration required)

Upload your resume
see similar jobs you may like
find connections at this company

Job description

Job Description:

At Optum, we're using leading-edge technology to create the health care system of tomorrow. When you join us as a Senior Data Architect , you'll become part of a team focused on innovation and change. You'll work a little harder. You'll aim a little higher. You'll expect more from yourself and others. And at the end of the day, you'll be doing a lot of good. Through a lot of inspired individuals, we are using technology to build a health care system that works better for more people in more ways than ever. We are looking to reinforce our team with people who are decisive, brilliant and built for speed - people like you. This role is responsible for working in Optum's Payment Integrity business with teams to develop schemas, ELT processes, stored procedures, unix shell scripts, diagrams, technical specifications, designs and test plans. The role will support multiple functional areas, architect databases, conduct investigative data analysis, provide user technical support, tasks and support customers with SQL query tuning and education on best practices. This position will maintain responsibility for gathering requirements, designing and developing, creating documentation to support the backend databases and data processing for multiple applications. The candidate is required to have excellent SQL development skills and previous Netezza experience. We need self-starter who can work in a virtual environment and likes to have fun while performing at a high level for our customers. Primary Responsibilities: * Use strong understanding of large scale system, information and technology architectures, including application integration patterns, messaging, service-oriented architecture, information models, and data lineage to create data solutions * Actively participate in all phases of project development life cycle including database policies, procedures, standards and supporting documentation, database design, process flow analysis, development, benchmark analysis, performance/tuning, capacity planning, and production implementation * Production support responsibilities include maximizing system availability, ensuring swift and complete database recovery, optimizing database and availability through ongoing maintenance, and ensure conformance to audit and operating standards * Participate in the evaluation, and recommendation of appropriate hardware and software resources * Assisting with communication interfaces/integration to associated systems * Upholds enterprise policy guidelines and recommends new and improved guidelines * Assist application development teams with planning and implementing database changes as well as query/job optimization * Work closely with IBM support through ticketing system to manage hardware/software failures, appliance upgrades and install patches * Participate in after-hours war-room calls if Netezza production server goes down working through disaster recovery plan this role will create * Create and maintain documentation including but not limited to standard operating procedures, functional specifications, detail design documents, high level solution summary documents, data and process flows, technical requirements, and impact assessments * Work with multiple functional areas to understand captured business requirements to create technical requirements, test plans, design document and coding for the solution * Support and develop ELT/ETL processes for Netezza including integrating error handling, audits, balance, job control, point in process restartability and ETL reporting * Identify gaps in existing process documentation, or areas where processes in development need further specification then create it * Make recommendations about platform adoption, including database servers, application servers, libraries, and frameworks * Help developers adopt Netezza through documentation, training, and mentoring * Architect solutions to move workloads off of Netezza to big data platforms * Architect databases with complex application and data security requirements * Translates highly complex concepts in ways that can be understood by a variety of audiences * Work toward improve process efficiency and automate processes where current manual still exist Required Qualifications: * 4 year degree required (Information Systems, Computer Science, Software Engineering, Healthcare Informatics, or related degree) * 10 years of experience with advanced SQL programming skills with ability to write programs against two or more of the following DBMS: * Netezza, Teradata, SQL Server, DB2, or Oracle * 5 years of experience in process analysis, systems analysis, data analysis, software development, or a combination of roles participating in SDLC and creating diagrams in MS Visio * 5 years of experience with information modeling, information visualization, data modeling, data management technologies, data integration, data sourcing, data analytics, data warehousing, metadata, semantics and ontologies * 3

More jobs you may like

Senior AIX Linux Engineer
Director of Business Applications Portfolio and Development
Senior Provider Data Specialist - Any UHG Office or Current Telecommut
Senior Marketing Manager, Member Engagement Foundational Strategy - Mi
Senior Business Systems Analyst - Eden Prairie, MN

New account

Log in

Current country: :: Contact us :: Terms of use :: Privacy policy :: Credits :: Benji Jobs international: Jobs in the US :: Jobs in the UK :: Jobs in Canada

Jobs in Argentina
Jobs in Australia
Jobs in Austria
Jobs in Bahrain
Jobs in Belgium
Jobs in Brazil
Jobs in Canada
Jobs in Chile
Jobs in China
Jobs in Colombia
Jobs in Czech Republic
Jobs in Denmark
Jobs in Finland
Jobs in France
Jobs in Germany
Jobs in Greece
Jobs in Honk Kong
Jobs in Hungary
Jobs in India
Jobs in Indonesia
Jobs in Ireland
Jobs in Israel
Jobs in Italy
Jobs in Japan
Jobs in Korea
Jobs in Kuwait
Jobs in Luxembourg
Jobs in Malaysia
Jobs in Mexico
Jobs in Netherlands
Jobs in New Zealand
Jobs in Norway
Jobs in Oman
Jobs in Pakistan
Jobs in Peru
Jobs in Philippines
Jobs in Poland
Jobs in Portugal
Jobs in Quatar
Jobs in Romania
Jobs in Russia
Jobs in Saudi Arabia
Jobs in Singapore
Jobs in South Africa
Jobs in Spain
Jobs in Sweden
Jobs in Switzerland
Jobs in Taiwan
Jobs in Turkey
Jobs in the United Arab Emirates
Jobs in the United Kingdom
Jobs in the United Stated
Jobs in Venezuela