SQL/Report Developer

$88,000 - $173,200/Yr

Optum - Naperville Park District, IL

Full-time - Mid Level

Naperville Park District, IL

Insurance Carriers and Related Activities

About the position

The SQL/Report Developer at Optum is responsible for developing and maintaining complex SQL queries and scripts to create data marts in Teradata, as well as designing and implementing Business Intelligence reports using healthcare claims data. This role involves gathering business requirements, performing data analysis, and improving health service delivery through advanced analytics. The position requires effective communication and collaboration with project teams and stakeholders to ensure successful project execution and delivery.

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
• Design, develop, implement, and maintain Business Intelligence reports using healthcare claims data
• Develop complex business intelligence solutions and supporting data strategy
• Create dashboards, scorecards, reports, and data analysis using X12/EDI pre-adjudicated data
• Maintain effective communication and relationships with all individuals involved with the project
• Utilize advanced analytics to improve health and human services programs
• Participate in project discussions to document and recommend alternative technical solutions
• Conduct unit, integration, and system testing
• Perform peer-reviews and provide technical support to the project team
• Support project manager and leadership in planning and executing activities
• Demonstrate deliverables to the team or customers for approvals
• Work with DBAs, data modelers, and application/system admins to maintain Teradata and application server hardware and software
• Learn new technologies as needed to perform job duties effectively
• Research and consult with resources and/or industry experts to ensure system effectiveness
• Perform additional duties as assigned

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
• 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

• Comprehensive benefits package
• Incentive and recognition programs
• Equity stock purchase
• 401k contribution