Senior Business Intelligence Developer

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

Preferred Qualifications :