Data Warehouse Senior Teradata Developer

UnitedHealth Group-posted 7 months ago
$89,800 - $176,700/Yr
Full-time • Mid Level
Remote • Lansing, MI
Insurance Carriers and Related Activities
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together. This candidate will be part of a 45 person team made up of 6-7 Sr Analysts, along with Project Managers, Teradata and Web Developers, Data Modelers, DBAs, and Report Analysts. You'll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges.

  • Perform server configuration to ensure that the entire database system is capable of providing the services needed.
  • Monitor performance to identify bottlenecks and places where throughput can be improved.
  • Administer security to ensure that the database cannot be accessed by unauthorized parties or damaged by anyone.
  • Configure access to the data warehouse and communication between the warehouse and other servers.
  • Translate logical database design to physical database design for optimal performance.
  • Establish standards and guidelines for access to MDHHS data warehouse databases.
  • Collaborate with DTMB to provide data/database integrity for software installation and updates.
  • Optimize queries for State DW developers and clients.
  • Develop and analyze highly complex system standards, thresholds, and recommendations to maximize system performance.
  • Evaluate products and upgrades for appropriateness and lead the implementation and upgrade strategies.
  • Create/Modify database tables, views, or other database objects to support projects and change requests.
  • Support Teradata patch and upgrades.
  • Perform Teradata SQL troubleshooting and fine-tuning of scripts.
  • Support database or system issues reported by Helpdesk or business users.
  • Coordinate with the team and customers in supporting database needs.
  • Support internal or external audit processes and address vulnerabilities or risks proactively.
  • Generate and maintain capacity management, Space, and CPU reports.
  • Analyze project requirements and develop detailed specifications for new and existing data warehouse database related requirements.
  • Review and validate database related test scenarios and results.
  • Develop or acquire test data and initiate tests to determine the accuracy of database logic.
  • Communicate effectively with programmers, analysts, management, system users, and other stakeholders.
  • Meet with users for clarification and elaboration to define problems and conceptualize development plans.
  • Facilitate modification of the logical design to create a physical design suited to business needs.
  • Work with developers and EDW team to create and maintain database standards.
  • 5+ years of experience with Teradata V18/19/20.
  • 5+ years of experience with Teradata Utilities (TPT, Mload, Fastload, BTEQ, etc.).
  • 5+ years of experience in ETL using Teradata Utilities in a Unix/Linux environment.
  • 5+ years of experience with Teradata SQL Assistant.
  • 5+ years of deep experience with performance tuning within a Teradata environment (SQL, Viewpoint, Explains).
  • 5+ years of expert experience with SQL.
  • 5+ years of experience working with customers and technical users to understand business issues.
  • 3+ years of experience with Viewpoint.
  • 1+ years of experience with BI Query reporting tool.
  • Certified Teradata Master.
  • Emerging Data Architect experience.
  • Proven data modeling skills.
  • Experience with Medicaid and public health data sets.
  • Ability to work independently.
  • Ability to communicate effectively with various stakeholders.
  • Ability to recognize, gather, correlate, and analyze facts.
  • Experience with Data Governance.
  • Comprehensive benefits package.
  • Incentive and recognition programs.
  • Equity stock purchase.
  • 401k contribution.
Track Jobs with Teal

Job Search Resources

•
AI Resume Builder
•
Data Warehouse Developer Resume Examples
•
Data Warehouse Developer Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service