SQL/Report Developer

$88,000 - $173,200/Yr

Optum - Naperville, IL

posted about 2 months ago

Full-time - Mid Level
Naperville, IL
Insurance Carriers and Related Activities

About the position

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 diversity and inclusion, talented peers, comprehensive benefits, and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together. You'll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges. In this role, you will be responsible for developing and maintaining complex SQL queries and scripts used to create data marts in Teradata. You will gather business requirements and prepare analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency supporting projects and change requests. Additionally, you will design, develop, implement, and maintain Business Intelligence reports using healthcare claims data. Your expertise will be crucial in developing complex business intelligence solutions and supporting data strategy, leveraging acquired subject matter expertise to identify and inform opportunities and risks. You will also be tasked with developing complex dashboards, scorecards, reports, and data analysis using X12/EDI pre-adjudicated data including 835, 277, and 837 transitions. Maintaining effective communication and relationships with all individuals involved with the project is essential. You will improve the delivery and management of health and human services programs by utilizing advanced analytics, including advanced algorithms, data visualizations, and maps. Participation in project discussions to document and recommend alternative technical solutions or requirements will be part of your responsibilities, along with performing unit, integration, and system testing. You will provide technical support and guidance to the project team, support the project manager and leadership in project planning and executing activities, and demonstrate deliverables to the team or customers for approvals.

Responsibilities

  • Develop and maintain complex SQL queries and scripts used to create data marts in Teradata.
  • Gather business requirements and prepare analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency supporting projects and change requests.
  • Design, develop, implement, and maintain Business Intelligence reports using healthcare claims data.
  • Develop complex business intelligence solutions and supporting data strategy leveraging acquired subject matter expertise to identify/inform opportunities/risks.
  • Develop complex dashboards, scorecards, reports, and data analysis using X12/EDI pre-adjudicated data including 835, 277, and 837 transitions.
  • Maintain effective communication and relationships with all individuals involved with the project.
  • Improve the delivery and management of health and human services programs by utilizing advanced analytics, including advanced algorithms, data visualizations, and maps.
  • Participate in project discussions to document and recommend alternative technical solutions or requirements.
  • Participate in unit, integration, and system testing.
  • Perform peer-reviews and provide technical support/guidance to the project team.
  • Support the project manager and leadership in project planning and executing activities, including presentations, risks/issues, and status reporting.
  • Demonstrate deliverables to the team or the customers for approvals and gain buy-in to implement solutions or adapt to new products/services/programs.
  • Work with the DBAs, data modelers, and application/system admins to support maintaining the Teradata and application server hardware and software (including patches, fixes, and upgrades) and leading industry level standards or best practices.
  • Learn new technologies as needed to be able to perform job duties effectively.
  • Research and consult with resources and/or industry experts to ensure the effectiveness and efficiency of systems and applications.

Requirements

  • 5+ years Teradata version 14+ experience, including SQL Assistant/Teradata Studio.
  • 5+ years of experience developing, implementing, and maintaining complex Tableau or MS Power BI dashboards, visualizations, and analytics.
  • 5+ years developing complex business intelligence solutions.
  • 5+ years of data warehouse project experience.
  • 5 years of experience developing complex SQL scripts (Teradata/DB2/Oracle Load Utilities) AND stored procedures.
  • 3+ years of experience using x12/EDI data including 835, 277, and 837.
  • Experience with healthcare claims.

Nice-to-haves

  • 5+ years of experience analyzing and delivering complex analytics using Medicaid or Managed Care claims.
  • 3+ years of Tableau Server Administrative experience.
  • Experience with State Medicaid / Medicare / Healthcare industry.
  • Experience in SAP Business Objects or SAS.
  • Experience in Tableau or BO version upgrades.
  • Experience in Agile.

Benefits

  • 401(k) matching
  • comprehensive benefits package
  • incentive and recognition programs
  • equity stock purchase
  • 401k contribution
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service