SQL Developer

Primary 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 solution 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 preadjudicated 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 but not limited to advanced algorithms, data visualizations, and maps.

• Participate in project discussions to document and recommend alternative technical solutions or requirements.

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

• Perform additional duties that are normally associated with this position, as assigned.

Required Qualifications:

• At least 8 years of current/recent experience developing complex SQL queries (preferably in Teradata database)

• At least 4 years of current/recent experience developing Tableau reports and dashboards.

• At least 3 years of current/recent Health Insurance or Medicaid domain experience.

• Experience with healthcare claims

• More than seven years of experience developing, implementing, and maintaining complex Tableau or MS Power BI dashboards, visualizations, and analytics

• Proven strong development of high performing SQL with more than five years of experience developing complex SQL scripts (Teradata/DB2/Oracle Load Utilities) or stored procedures

• At least three years of experience using x12/EDI data including 835, 277, and 837

• At least five years developing complex business intelligence solutions

• At least five years of data warehouse project experience

• At least five years Teradata version 14 experience, including SQL Assistant/Teradata Studio

• Excellent verbal/written communication skills, end client-facing skills, team collaboration, and mentoring skills

• Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology

• Strong organization skills and ability to set priorities and schedule work deadlines

• Adapting to and collaborating with the team and organizational culture

Preferred Qualifications:

• More than five years of experience analyzing and delivering complex analytics using Medicaid or Managed Care claims.

• Experience with State Medicaid / Medicare / Healthcare industry

• More than three years of Tableau Server Administrative experience

• Experience in SAP Business Objects or SAS

• Prior Experience in Tableau or BO version upgrades

• Experience in Agile